|
|
Posted by Colin McKinnon on 08/08/06 21:46
Jerry Stuckle wrote:
> david wrote:
>> On 2006-08-06 09:46:02 -0700, s a n j a y <sanjay.debian@gmail.com> said:
>>
>>> david wrote:
>>>
>>>> I need 5 queries from the database, which I display in a php foreach
>>>> loop the following way.
>>>>
>>>> $query1 = $DB->query("SELECT ... DESC LIMIT 20");
>>>> $query2 = $DB->query("SELECT ... DESC LIMIT 20");
>>>> $query3 = $DB->query("SELECT ... DESC LIMIT 30");
>>>> $query4 = $DB->query("SELECT ... DESC LIMIT 9");
>>>> $query5 = $DB->query("SELECT ... DESC LIMIT 9");
>>>>
>>> Why do you want to split hairs? How does 8 ms different than 12 ms in
>>> practical sense?
>>
>>
>> Well, when you have hundreds of requests coming in within a short period
>> of time, those ms add up. This is why I am trying to optimize this
>> function. Any ideas on how to make this the quickest?
>
> David,
>
> What do you mean by a "short period"? 1 second? 10 seconds?
>
> Even 100 page requests in 10 seconds would be over 860K requests/day,
> which would make your site one of the busiest on the internet. And if
> that's the case you'll have a lot more things to worry about -
> bandwidth, for instance.
>
No need to *&(% all over his post - how do you know he's NOT doing that
volume?
Faster is not the same thing as more scalable though - its kind of tortoise
and hare thing.
....but if I had to fix the code I'd be looking to do a single query (UNION?)
rather than worrying about which loop construct to use.
C.
Navigation:
[Reply to this message]
|