[FX.php List] Sluggish load time for query... part two...
DC
dan.cynosure at dbmscan.com
Mon Mar 20 14:57:17 MST 2006
also, i noticed that your website vhost redirect to index.html is not
set up properly.
if you leave off index.html you get a different page than if you put it on.
http://www.afm257.org
http://www.afm257.org/index.html
you might want to fix that as it is a little confusing.
dan
DC had written:
> 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
>>
> _______________________________________________
> 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