https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 07:01:37 +0000 Sun, 02 May 2004 08:39:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10252 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/slow-searchs-after-sql-upsize_topic10252_post55859.html#55859 Author: WebWiz-Bruce
Subject: 10252
Posted: 02 May 2004 at 8:39am

Often you won't get a speed increase using the SQL server version onsearchs until you have a large number of posts, on smaller databasesAccess is often faster at the searches.]]> Sun, 02 May 2004 08:39:06 +0000 https://forums.webwiz.net/slow-searchs-after-sql-upsize_topic10252_post55859.html#55859 https://forums.webwiz.net/slow-searchs-after-sql-upsize_topic10252_post55838.html#55838 Author: JohnKn
Subject: 10252
Posted: 01 May 2004 at 11:48pm

Today I installed MSDE and setup a SQL version of the forum. Everythingworks fine, except searchs are orders of magnitued slower than onAccess. Using the same data, no users on the server (it's a testserver) a search that takes 0.7 seconds on Access takes 6 seconds ormore in the SQL version. Browsing the forum thread pages load in thesame amount of time.

I tried reindexing the SQL db but that had no effect on the search speed. Is there some other SQL tip that I'm missing?

Server:
AMD Athlon 2400
512 meg ram
Access db 27 meg
WW 7.6, no mods
]]> Sat, 01 May 2004 23:48:12 +0000 https://forums.webwiz.net/slow-searchs-after-sql-upsize_topic10252_post55838.html#55838