Print Page | Close Window

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 access: http://129.125.101.174/c4dportal/forum/default.asp - http://129.125.101.174/c4dportal/forum/default.asp
Database size: 10 mb

One is sqlserver: http://129.125.101.174/c4dportal2/forum/default.asp - http://129.125.101.174/c4dportal2/forum/default.asp
Database size: 42 mb

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.

average load time default.asp page on access: 0.8125 seconds. 
average load time default.asp page on sql     : 1.3828 seconds.

Load time when searching for ''the'' on access: 0.5400 seconds.
Load time when searching for ''the'' on sql: 0.9510 seconds. 
(84 results)

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 .
Thanks for the tip Michael.

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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net