Search Index

Jeff · December 03, 2007, 02:43:14 PM

For the next hour you "might" experience some slowness with the server as I work to ultimately speed it up. Right now when someone searches the forum, it takes the resources of the forums database to create the results. To many searches can drag the forum's response time.

I am currently creating a search index that is separate from the database. Searches performed once the index is created will search the index, not the database, Those searches will have no effect on the forum resources as it does now. I am currently about 6% into this. It should be completed within an hour.

thecfarm · December 03, 2007, 04:34:11 PM

Thank you jeff.You really help people out that just have dail up.I really appreacate it.

Jeff · December 03, 2007, 04:38:06 PM

This is taking considerably longer then I planned. I am at only 25%

Oh Well.

Jeff · December 04, 2007, 08:21:18 AM

The search indexing seems to be a success.

Jeff · December 04, 2007, 08:28:55 AM

Searching seems to be almost instantaneous, at least from here. IT turns out that it took me a little over 11 hours instead of 1 so I was only a little off. :-\

Norm · December 07, 2007, 07:58:27 AM

I wonder if the search function is what was causing some timeouts. Since you've redone it I get almost none of them. Of course this is cutting into coffee and bathroom breaks for me. ;D

Jeff · December 07, 2007, 09:00:18 AM

It could have been part of it. Searching the forum took a lot of resources. I'm thinking I still have a database issue yet to clear up before some of those little time outs go completely away.

Jeff · December 18, 2007, 04:13:13 PM

I am updating our search index. searches for the next couple hours will most likely fail until this is completed.

Jeff · January 08, 2008, 11:41:54 PM

I'll be updating our search index tonight. Attempted searches may be slow or timeout until morning.

Jeff · January 09, 2008, 11:01:33 AM

This was interrupted during the night so it continues.... Searching the forum will be slow yet for the morning.

Tom · January 09, 2008, 05:41:17 PM

Database Error: Lost connection to MySQL server during query
File: /home/www/forestryforum/board/Sources/MessageIndex.php
Line: 606Database Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
File: /home/www/forestryforum/board/Sources/Load.php
Line: 2020

Jeff · January 09, 2008, 05:46:14 PM

I was rebooting the mysql server

Tom · January 09, 2008, 05:50:09 PM

well, kick it again while it's down.

Jeff · January 09, 2008, 05:50:53 PM

I'm doing just that.

Furby · January 09, 2008, 06:53:19 PM

Fight, fight, fight!

Jeff · February 26, 2008, 09:22:49 AM

I'll be updating the search index throughout the day to day, so searching the forum could prove to be problematic. It'll get good again when I am finished.

Jeff · March 16, 2008, 08:42:01 AM

With the time outs and things going on the last few weeks I had been unable to successfully create an updated search index for the Forestry forum. Searches had been slow and adding to the problems on the forum. It appears I might have a few things sorted out as last night I was finally able to work on the index again and complete it, and enable it.

Searches should be very fast now.

StorminN · March 16, 2008, 12:28:27 PM

WHOA!! That's a HUGE difference! Great job!

8) 8) 8) 8) 8) 8) 8) 8) 8) 8)

I had been having trouble getting the search to even work, and had noticed if I was specific with naming just one forum, it would work, but now this is great!!

-N.