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

[Andy Gaunt]

Bob,

Can you not do a single query to the database?

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?


Andy Gaunt
T: 407.810.4722
andy at fmpug.com
http://www.fmpug.com    

Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award

For chapter locations, dates & times please visit the website at
http://www.fmpug.com If you can make it to a meeting, please RSVP at
http://www.fmpug.com/rsvp.php


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
Sent: Monday, March 20, 2006 4:46 PM
To: FX.php Discussion List
Subject: [FX.php List] Sluggish load time for query... part two...

I decided to go ahead with my revamp of an existing site, and  
implemented PHP throughout the site. Sometimes the queries seem to be  
quick, sometimes not, but I don't think it's related to server load.

At any rate, I thought I'd post the link here for anyone to check  
out; there are 3 queries on the page:

http://www.afm257.org

Query #1: searches for marked records among about 350 records;  
displays the title of the article in a table at the top right of the  
page
Query #2: searches for a marked record, shows its title, pulls in a  
URL for loading an image, loads the image caption
Query #3: same as #2, but finds a 2nd marked record

There are only 350 records in this database, and these queries don't  
even do searches within the articles' text. In all 3 cases they're  
searching for records with a field marked "Yes"; this ought to be  
quick, I'd think.

Any thoughts would be greatly appreciated.

Thanks,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA SKYPE:
      USERNAME: longtermsolutions

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: bob at patin.com
      ICQ: 159333060


_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list