Web Wiz Forums - Access - SQL upgrade tip

Print Page | Close Window

Access - SQL upgrade tip

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11765
Printed Date: 09 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access - SQL upgrade tip

Posted By: JohnKn
Subject: Access - SQL upgrade tip
Date Posted: 11 September 2004 at 6:10pm

I imported a 50 meg Web Wiz Access db into SQL using Enterprise Manager. After doing the rest of the manual tweaks to get the forum running I found that searchs would take 5 seconds or more and sqlserver.exe would use 99% of the CPU until the search completed.

I ran sp_updatestats on the SQL db and searchs dropped to peaking at 60% CPU and taking under 1 second to complete. This is on a forum with 36,000 posts, the server is a Athlon 2400 with 512 meg of ram and no other load or websites on the machine.

I hope this helps someone else out.