PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Troubleshooting

Reply
 
Thread Tools
Old 03-16-2004, 04:01 AM   #1
airplay
Green Mole
 
Join Date: Mar 2004
Posts: 7
Slow Searches

Charter
Hey, thanks for the help in getting my site indexed. I asked you about the slow indexing before. It ended up taking 36-48 hours for it to index the whole site.

Any ways, now I'm running into a problem with some search results. Sometimes when you search it takes under a second, while other times it takes several HUNDRED seconds! Everything apears to be set up correctly (indexes ect). Any ideas? Is this search not made for hundreds of thousands of key words? I have almost 500,000 in my keywords table.

Thanks!
Airplay...
airplay is offline   Reply With Quote
Old 03-16-2004, 04:15 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Hi. Is this slowdown related to what radio button is selected (and operator, exact phrase, or operator) or does it appear to be r****m?
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote
Old 03-16-2004, 03:51 PM   #3
airplay
Green Mole
 
Join Date: Mar 2004
Posts: 7
In the stats

Start/any/exact

All of them are "s"

I hope that helps....

Airplay...
airplay is offline   Reply With Quote
Old 03-18-2004, 11:50 AM   #4
airplay
Green Mole
 
Join Date: Mar 2004
Posts: 7
Any ideas?
airplay is offline   Reply With Quote
Old 03-22-2004, 10:45 PM   #5
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Hi. The 's' means start (and operator). The slowdown may be due to the number of pages indexed. You might try afterBURNER*Cache or some such program or maybe check into what it would take to go dedicated or set up a cluster of servers, none of which I have personally tried with PhpDig so I cannot give a fail-safe solution.
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote
Old 03-30-2004, 05:10 PM   #6
Wayne McBryde
Orange Mole
 
Join Date: Oct 2003
Location: NC, USA
Posts: 34
Airplay,

Here's what's in my database:
DataBase status
Hosts : 937 Entries
Pages : 7883 Entries
Index : 1173175 Entries
Keywords : 132606 Entries
Temporary table : 16 Entries

My serches never took more than 5 to 7 seconds and most of the time less than 1 sec. Then I moved the site to a faster server, now searches never take more than 1/2 sec. I suspect you are on a slow server that is VERY slow at peak times.

Wayne
__________________
Wayne Mcbryde
http://LakeNormansWeb.com
We search all of Lake Norman!
Wayne McBryde is offline   Reply With Quote
Old 03-31-2004, 03:30 PM   #7
airplay
Green Mole
 
Join Date: Mar 2004
Posts: 7
Wayne
Thanks for responding!

Here's my info
Hosts : 1 Entries
Pages : 30998 Entries
Index : 11598106 Entries
Keywords : 449938 Entries
Temporary table : 0 Entries

It looks like I have an index that is 10 times the size of yours and I have 4-5 times as many pages. Maybe that would explain why my searches take longer. I don't think the server setup should be a problem. I actually have 2 servers, one runs the web serving and the other only runs mysql.
airplay is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to filter your searches yveslebeau How-to Forum 1 05-22-2006 11:01 PM
Totally Limiting Searches to a Particular Filetype elroy How-to Forum 4 11-18-2005 04:59 AM
Indexing slow.... no, _really_ slow bluntman Troubleshooting 1 09-24-2004 01:23 PM
different searches on a same site zaartix Mod Requests 2 05-05-2004 09:42 PM
Modify look of found searches straycatco How-to Forum 8 05-05-2004 09:16 AM


All times are GMT -8. The time now is 09:32 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.