Web Wiz Support and Community Forums : Access vs SQL Compare Performance & Size

Web Wiz Support and Community Forums : Access vs SQL Compare Performance & Size https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 09:45:02 +0000 Fri, 04 Mar 2005 17:52:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=14088 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access vs SQL Compare Performance & Size : These questions have been asked/answered...]]> https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post78039.html#78039 Author: xeerex
Subject: 14088
Posted: 04 March 2005 at 5:52pm

These questions have been asked/answered a zillion times. LOL

Like everyone has stated MS SQL Server is the way to go for the bestperformance. However, I'd like to share some stats (again) for one ofmy forums which is a credit to WWG. Please note that I have purged thisdatabase at least 3 times for old members and posts. It has peaked at180 users showing active and maintained 120 active users for over 5hours before.

Running Access at ~14MB

Forum Statistics
Launch Date of Site: February 4th, 2004 (393 days of operation) We have 4735 Posts in 828 Topics in 21 Forum(s) Avg Posts Per Day: 12.05 Last Post on 04 March 2005 at 2:33pm By MrDoh	We have 15526 Forum Members Avg New Members per day: 39.49 (excluding today) New Members today (so far): 8 \| Yesterday: 17 # of Members Visiting Site Today: 331 (excluding new members) The Newest Forum Member is Zagroseckt

This page was generated in 0.7031 seconds.

There are currently 29 Active Users online, 17 Guest(s) and 12 Member(s)
]]> Fri, 04 Mar 2005 17:52:10 +0000 https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post78039.html#78039 <![CDATA[Access vs SQL Compare Performance & Size : Hi Again; Why ask these questions...]]> https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post78002.html#78002 Author: superlative
Subject: 14088
Posted: 04 March 2005 at 8:14am

Hi Again;

Why ask these questions ?

Because my friend complaint our forum very slow. He member of 10-15 forums. And he like only this forum forum.donanimhaber.com web forum. This forum very fast and use SQL and I think this site located dedicated server. My friend said "Cause Of this, forum script. You use webwiz and donanimhaber use aspplayground". I said that to him "Cause Of this, SQL and hosting. Script effect %10 approx."

I examine aspplayground and I dont like. Because it has got PoorTextEditor (PTE) LOL

. And admin screen very bad. For this reasons I like WWF. I dont believe this cause script. SQL and hosting much than script.

But aspplayground have got auto-thumbnail attachements. But this and more features are payable. WWF is free. And I integrate our portal with forum (www.knowhow.gen.tr). When I leave WWF this is very big problem for me. I dont want to leave WWF. I suggest many thing for V8. Auto thumbnail big images very useful feature. And Borg said that (Performance Performance Performance...

for v8). I m waiting V8 and I talk my hosting sponsor for SQL. Then I try migrate to SQL. This is not effect my site integration isnt it?

@Borg : For V8, SQL and access versions improved performance isnt it ? not only one both versions improved versions isnt it (according to v7.x)? And I can migrate to v7.7 to v8 access or SQL version isnt it? I think modify DB.

Thanks.

]]> Fri, 04 Mar 2005 08:14:17 +0000 https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post78002.html#78002 <![CDATA[Access vs SQL Compare Performance & Size : The very very large company that...]]> https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77985.html#77985 Author: Paul Lush
Subject: 14088
Posted: 04 March 2005 at 5:20am

The very very large company that I work in uses Access to do its wage/overtime payments. Its got 8 databases about 120mb each and itsalways becoming corrupted. Theyre just too tight to upgrade it toSQL. Access, in the words of Microsoft, "should not be used in acorporate environment or where stability is paramount"

Dont forget that you can get a free copy of MS SQL in its MSDEversion. Its a cut down version of the full SQL2000 but doesntcome with the Enterprise Manager (but you can get free tools that dothe same) and has a concurrent connection limit. I run my forumdevelopment on MSDE on my XP laptop, works fantasic!
]]> Fri, 04 Mar 2005 05:20:24 +0000 https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77985.html#77985 <![CDATA[Access vs SQL Compare Performance & Size : 1. We did a test run and performance...]]> https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77983.html#77983 Author: sfd19
Subject: 14088
Posted: 04 March 2005 at 4:52am

1. We did a test run and performance was increased by approximately 70%. But it depends very much on your server.

2. AFAIK the max. size for Access DBs is 1GB, the optimal size is always the smallest. Wink

Also it depends very much on your server how big an Access database can grow without performance issues.

4. 140 MB, Access
]]> Fri, 04 Mar 2005 04:52:46 +0000 https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77983.html#77983 <![CDATA[Access vs SQL Compare Performance & Size : Access is a flat file database...]]> https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77981.html#77981 Author: WebWiz-Bruce
Subject: 14088
Posted: 04 March 2005 at 4:47am

Access is a flat file database system and as such is very poor atperformance as each time the database is accessed the entire databaseneeds to be loaded into the web servers memory.

SQL Server is a database server and as such you usually have SQL Serveron it's own dedicated server so it doesn't effect the web serversperformance. Also it doesn't use a flat file so doesn't require theentire database loaded into memory.

Access is fine for very small projects but as aflat file suffers from lots of draw backs, including, size limit,connection limits (usually a pool of 20 per server with all sitessharing this pool!!), often becomes corrupted, etc, etc.

SQL Server on the other hand, doesn't have any of these limitations,it's much more robust, doesn't have size or connection limits and is amuch better database system.

A bank may use a farm of MS SQL Servers to store all it's bank records on, but youwouldn't even dream of placing this data in an Access database, even ifit where possible.

Basically Access is a cheap desktop flat file database system for homeuse, and MS SQL Server is a $19,000 professional Relational DatabaseManagement System used by the big boys.
]]> Fri, 04 Mar 2005 04:47:08 +0000 https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77981.html#77981 <![CDATA[Access vs SQL Compare Performance & Size : Hii All; I am using WWF with...]]> https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77950.html#77950 Author: superlative
Subject: 14088
Posted: 03 March 2005 at 8:56pm

Hii All;

I am using WWF with Access DB. I think migrate to SQL. But I ask a question. Our forum created 1 years ago. And our DB 11MB.

How much increase performance Access to SQL ? (approximate percent %)
Max and optimal sizes for Access DB ?
Max and optimal sizes for SQL ?
How much your DB size ? (define DB type (SQL or Access))

Thanks

]]> Thu, 03 Mar 2005 20:56:54 +0000 https://forums.webwiz.net/access-vs-sql-compare-performance-size_topic14088_post77950.html#77950