I am writing an appointment scheduler and I have three queries running one after the other. I can also do it with one join query but that will take more time to arrange and test.
I was wondering if it is a better idea to go in for the latter [join query] or the former.
How many queries can one have on one page at the most without making little or no compromise on efficiency ?
Will my pages load faster by having just one join query or if I run them separately?
Would a join query be better if the size of the table is relatively small only ?, because as I understand it a join query involves checking one value in one table with every value in the other
I was wondering if it is a better idea to go in for the latter [join query] or the former.
How many queries can one have on one page at the most without making little or no compromise on efficiency ?
Will my pages load faster by having just one join query or if I run them separately?
Would a join query be better if the size of the table is relatively small only ?, because as I understand it a join query involves checking one value in one table with every value in the other