[FX.php List] Sluggish load time for query... part two...

[Bob Patin]

On Mar 20, 2006, at 3:55 PM, Andy Gaunt wrote:

> Can you not do a single query to the database?

I'm in the process of taking the query out of the page and putting in  
a blank page, so I can see how that works. However, in CDML, with the  
exact same graphics, it always loaded in about 3-4 seconds, and  
that's coming from fairly slow FileMaker Pro machines, same web server.

It's really discouraging; I haven't seen this from any other site  
where I've used PHP... maybe there's something goofy in my page that  
is causing this...

No unstored calcs; in fact, none of the fields that I'm searching on  
have calcs. What I do is to mark the recent articles by checking a  
field so that it equals "Yes". Then I search for these records (about  
a dozen of them, usually) and display their titles on the home page.

The other 2 queries are the same, except that the search is on a  
different field, again a non-calc field.

Puzzling...

>
> Have you tried putting each query on a vanilla page by itself and  
> printing
> the result to screen (this can show you load time for just the data)?
>
> No unstored calcs I take it?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060320/9fc7fa33/attachment.html