[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