[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