| Author |
 Topic  |
|
|
Pikachoad
Starting Member
12 Posts |
 Posted - 25 May 2004 : 09:17:29
|
Not to be facetious, but I found a way to make the search function work properly in Snitz with SQL Server and not time out- brute force. 
My forums arent huge, but big enough that if someone were to search for a single word in all forums, all post dates, it would process for 30 seconds or whatever and then time out.
Well I recently built a new dedicated SQL server. Previously my site was hosted locally but the data was elsewhere (I know thats awful, but it timed out before even with the forums and db hosted in the same location). Now the SQL machine is in the same location as the site itself (on the same internal network).
The specs:
2.4G P4
1 GB DDR
1 60GB IDE drive for the system drive
2 SATA 80GB drives in RAID 1 for the data and log files of SQL Server.
Now, with that new machine working just on SQL Server, I can do a super simple search, like on the word "the", and it takes at most six seconds and returns with no problem. Server CPU activity spikes up to about 54% during that time- which is quite high, but on everything else my site does, it never goes above 2%.
I know this isnt a practical solution for most people- just wanted to pass on the word that brute force does work.  |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 25 May 2004 : 09:24:59
|
| There's a search page mod written specifically for SQL Server. Try a search! |
The UK MkIVs Forum |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 25 May 2004 : 09:25:07
|
| dedicating an entire SQL server to one forum is hardly a solution. There is a SQL optimised search page available for download which also solves the timeout without the need for a dedicated sql server. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Pikachoad
Starting Member
12 Posts |
Posted - 26 May 2004 : 13:50:36
|
Yes, thanks, I already knew about that page. Even with that page my forum had problems. Its funny, in my own forum I tell people to do searches when they ask silly questions, and I come here having used Snitz for several years now just to shed a bit of light on something, and I get told to do a search as well. 
I even said I knew this wasnt a practical solution. Maybe I needed more smilie faces for you to not think I was recommending that people actually all go out and get a dedicated box?
And not that it matters, but the dedicated SQL machine isnt just for the forums. Its for my whole site, and at least two other sites.
I have been knee deep in discussions on optimizing the search functions before regarding this forum, and just SQL Server in general. I know that in the past, it was stated with a large degree of officiality that the timeout issue was a "bug" in SQL Server/IIS implementation. So frankly, I was expecting the bug to still exist in some degree after the upgrade. When it went from a 40 second timeout to a full webpage in front of my eyes in six seconds, I was pleasantly suprised.
EDIT:
I forgot that now I am just using the SH core pages, and I wasnt using this no-paging fix. So I went back and replaced my search.asp with the fixed one again (same one you linked me to). Without the paging the pages now take almost twice as long to load, if not more. The word "the" took 2.85 second before (using the timer built into Snitz) and with the new improved search page, it took 4.85 seconds but took longer for the huge list to appear in my browser.
Now I dont know what search mods are done in the SH mod, but I guess for me and my impractical setup, it works just fine.
Sorry to have bothered everyone. Feel free to delete this thread. |
Edited by - Pikachoad on 26 May 2004 14:11:01 |
|
|
| |
Topic |
|
|
|
Topic Locked
