sql vs access on my server.
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8702
Printed Date: 30 March 2026 at 11:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: sql vs access on my server.
Posted By: Badaboem
Subject: sql vs access on my server.
Date Posted: 08 January 2004 at 6:09pm
|
I've setup two forums on my server. One is sqlserver: http://129.125.101.174/c4dportal2/forum/default.asp - http://129.125.101.174/c4dportal2/forum/default.asp Access database has been ported upsized to sql. It looks like it's too large, because I've seen Borg post a message where he said his database is 30 mb. Load time when searching for ''the'' on access: 0.5400 seconds. It looks like access is faster here. Question here is...is it caused by the sql database that is probably too large, or not entirely correct because of upsizing (forum is working 100 % though), or does sql become faster once the post count is fairly large (currently have 9000 posts on my forum)? |
Replies:
Posted By: dpyers
Date Posted: 08 January 2004 at 6:45pm
|
Check the indexing and log options on the SQL DB. Many servers default to an initial log size that's almost as big/bigger than the DB ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: michael
Date Posted: 09 January 2004 at 9:59am
|
42 seems to be way to big, run the following in your QA BACKUP LOG databasename WITH TRUNCATE_ONLY DBCC Shrinkdatabase (databasename) It should shrink your db quite a bit. I have noticed that Access upsized databases have a lot of free pages in the db and some maintanance is acutally a must afterwards ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: Badaboem
Date Posted: 09 January 2004 at 10:11am
|
The size is now 17.63 mb. That's a huge difference The speed of the sql server is still the same though. No difference. I've set the priority to high in enterprise manager and kicked the cpu cycles up. Still no difference. I wonder if it has something to do with cpu optimization, since my processor is listed as intel pentium although I have an AMD. Futhermore, could licensing be an issue here. I've checked the sql server statistics under admin of the forum , and it says licensing unknown. I'm not sure what this means. |
. Posted By: WebWiz-Bruce
Date Posted: 09 January 2004 at 10:45am
|
For smaller databases Access can sometimes be quicker becuase of the
way the different systems work, but as databases get bigger SQL server
is always far superior. With Access you have a flat file instead of a server, with the flat file of access the entire database needs to be loaded into memory, this means that with smaller databases it is sometimes faster for things like searches as the data is in memory. Also with Access the file is local and loaded into the local servers memory, with SQL server, often the SQL server database is located on another server, this can mean that sometimes you have delays on the network trnasffering data between the servers. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |