Slow Searches

airplay · 03-16-2004, 05:01 AM

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...

Charter · 03-16-2004, 05:15 AM

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?

airplay · 03-16-2004, 04:51 PM

In the stats

Start/any/exact

All of them are "s"

I hope that helps....

Airplay...

airplay · 03-18-2004, 12:50 PM

Any ideas?

Charter · 03-22-2004, 11:45 PM

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.

Wayne McBryde · 03-30-2004, 06:10 PM

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

airplay · 03-31-2004, 04:30 PM

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.

03-16-2004, 05: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...

03-16-2004, 05:15 AM	#2
Charter Head Mole 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.

03-22-2004, 11:45 PM	#5
Charter Head Mole 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.

03-30-2004, 06: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!

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

03-16-2004, 04: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...

03-18-2004, 12:50 PM	#4
airplay Green Mole Join Date: Mar 2004 Posts: 7	Any ideas?

03-31-2004, 04: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.