Posted by Jerry Stuckle on 08/08/06 11:22

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");
>>>
>>> foreach ($query1->result as $row) {
>>> echo '<a href="httplink/'.$row['topic_id'].'/"
>>> title="'.htmlspecialchars(trim($row['screen_name'])).':
>>> '.htmlspecialchars(trim($row['title'])).'">&raquo;
>>> '.substr($row['title'], 0, 20)." ...</a><br />
>>> ";}
>>> foreach ($query2->result as $row) {
>>> echo '<a href="httplink/'.$row['topic_id'].'/"
>>> title="'.htmlspecialchars(trim($row['screen_name'])).':
>>> '.htmlspecialchars(trim($row['title'])).'">&raquo;
>>> '.substr($row['title'], 0, 20)." ...</a><br />
>>> ";}
>>>
>>> and so on....
>>>
>>> Looking only at performance is there a quicker way to do this? Could
>>> I use a different loop (other than foreach) to get better performance?
>>>
>>> I found the following page, but I am not sure which one would help me
>>> and how to change the code around to make it work. Any ideas would
>>> help. Thank you!
>>> http://www.php.lt/benchmark/phpbench.php
>>>
>>> david
>>>
>>
>> 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.

Even at 100 page requests/min. you'll be one of the busiest on the
internet - but the 8ms won't be noticeable.

I understand your desire to optimize the code. But some things just
aren't worth the effort.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: Changing between times
• Prev in forum: Re: how to send a plain text version of an email with html
• Thread view: Re: Is foreach the fastest way to do this?

[Reply to this message]