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

DC dan.cynosure at dbmscan.com
Mon Mar 20 14:49:05 MST 2006


does one of your layouts have a container field? those are slow.

dan

Bob Patin had written:
> 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
> 


More information about the FX.php_List mailing list