Posted by s a n j a y on 08/06/06 16:46

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?

• Next in forum: Re: array bugs?
• Prev in forum: Re: Source Displayed With include_once()
• Thread view: Re: Is foreach the fastest way to do this?

[Reply to this message]