Print Page | Close Window

Page Generate Time - SQL vs Access

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=15247
Printed Date: 13 April 2026 at 1:47pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Page Generate Time - SQL vs Access
Posted By: superlative
Subject: Page Generate Time - SQL vs Access
Date Posted: 27 May 2005 at 12:25am
Hi Everyone
 
I am using v7.7a Access, and I planning to migrate to v7.9 SQL version. For this reason I follow these steps in my LOCAL server:
  1. I download v7.9 SQL and Access versions.
  2. First I migrate to v7.9 Access version
  3. Create blank DB in my SQL
  4. And setup my SQL forum
  5. Then delete all tables
  6. Then I am using import wizard and I import access to SQL (for tables)
  7. After I shrink my db. Reduce file size..

Result I have got 2 forums.

forum2 folder is SQL forum and forum3 folder is Access version.
 
Main page generate time is :
For SQL : This page was generated in 3,7188 seconds.
For Access : This page was generated in 0,9375 seconds.
 
Why SQL slower ? I want to migrate SQL because access forum sometimes down my mdb size 12 mb. Thanks.


-------------
http://www.knowhow.gen.tr" rel="nofollow">



Replies:
Posted By: dj air
Date Posted: 27 May 2005 at 6:40am
this will take time for the indexs to work etc. but overall SQL is much better with searchs and high volume.

mainly you need to wait for the indexs. what stats are on the forum (posts, topics etc).


Posted By: superlative
Date Posted: 27 May 2005 at 2:13pm
I compare same size forums, (SQL 7.9 vs Access 7.9). How to test these versions under stress. I will plan to replicate my sql server and my hosting sponsor's sql server. When i accomplish this, i can test sql version on my hostings server. My server is a pc hardware,
 
P4 1.6 ~1.9
512 DDRAM
Windows 2003 Enterprise Edt.
SQL 2000 Enterprise Edt.
 
My stats is here :
 
Forum Statistics
Number of Forums 31      
Number of Topics 1267  Last New Topic 19 Mayıs 2005 Perşembe, 20:25 
Number of Posts 6121  Last New Post 19 Mayıs 2005 Perşembe, 20:25 
Number of Members 1590  Last New Member 19 Mayıs 2005 Perşembe, 18:58 
Number of Private Messages 158  Last Private Message 17 Mayıs 2005 Salı, 20:02 
Number of Polls 16     
Number of User Groups 6     
 
Size Information
SQL Server DB Size: 14,13 MB     
Database File Size: 13,13 MB Log File Size 1 MB
Database File Location: D:\vhosts\knowhow.gen.tr\sql\knowhowgentr-db1_Data.MDF 
Log File Location D:\vhosts\knowhow.gen.tr\sql\knowhowgentr-db1_Log.LDF 
Maximum DB Size Unrestricted 
Maximum Log Size Unrestricted
 
Server Information
SQL Server Edition: Enterprise Edition 
Service Pack: SP4 
Server is Clustered? No Cluster/Unknown 
Server Licensing: Licensing Disabled / Unknown 


-------------
http://www.knowhow.gen.tr" rel="nofollow">


Posted By: ljamal
Date Posted: 27 May 2005 at 9:45pm
If the SQL ídn't on the same local network as the web server then you will see an increase in time because of the multple calls to the SQL database on each page. Even if it take a split second to make those calls those split seconds add up when you have 20-30 calls on a pages (like default.asp)

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming


Posted By: WebWiz-Bruce
Date Posted: 28 May 2005 at 3:08am
Some pages you may see a drop in performance because of the way the different databases work, but overall you should see a small improvement, especially as your database gets larger.

However, if the SQL Server is located across a slow network, or an overloaded server, you may not see an increase in performance over Access.

However, you do get many other benefits from using SQL Server, as it can cope with larger databases, more connections to the database (access only has a pool of 20 connections).

Also I find that Access, being a flat file desktop database, can not cope with the amount of abuse a forum gives it and often becomes corrupted and not recoverable (I get emails about this almost daily). With MS SQL Server, you won't get this.


-------------
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


Posted By: superlative
Date Posted: 28 May 2005 at 11:12am
Thanks for answers, in my test, web server and sql server same machine (my pc). I think this results dramaticly change when i will sent my sql data to hosting sql server.
 
Currently I add my hosting firms SQL server as instance to my sql enterprise manager. I can manage only my database :) Because my hosting firms give permission for only my database. I am using import export wizard. And i easyly sent my db to hosting server (my db).
 
But now, web server is my PC, SQL server is hosting sql. Forum main page generating 72 seconds :) Above informations is true. Absolutely..


-------------
http://www.knowhow.gen.tr" rel="nofollow">


Posted By: superlative
Date Posted: 28 May 2005 at 2:21pm
I see very interesting results. I test my forums with this tool http://www.numion.com/Stopwatch/index.html - http://www.numion.com/Stopwatch/index.html
 
My test enverionment :
 
http://www.knowhow.gen.tr/forum - www.knowhow.gen.tr/forum this is v7.7 Access version (actual forum)
http://www.knowhow.gen.tr/forum2 - www.knowhow.gen.tr/forum2 this is v7.9 SQL version (testin purpose and db older than Access)
 
Web server and SQL server difference and in same network (both in my hosting company).
 
Generate times : (main forum page)
7.7 Access : Bu Sayfa 1,0313 Saniyede Yüklendi.
7.9 SQL : This page was generated in 1,1875 seconds.
 
Stopwatch page loading times :
 
7.7 Access : 4.547 second
7.9 SQL version : 3.766 second
 
My connection speed 256/64 Kbit ADSL
 
But 7.9 sql is default settings no header footer configuration. 7.7 is more images..
 
I think my hosting firms upgrade their internet connection speed or change server. Because my acccess forum very lover. And sometimes occur ldb problem (my access compressed and repairied via MS access)
 
Thats all guys, what you think ? I think prepare my portal for sql, currently integrate portal and access forum, but may be i must change some codes when i migrate sql. I think change db structure when release v8. For this reason i will wait v8 SQL version. But i will integrate portal and SQL 7.9 forum only in my Server.


-------------
http://www.knowhow.gen.tr" rel="nofollow">


Posted By: dpyers
Date Posted: 28 May 2005 at 3:52pm
I've found that testing from my pc with a remotely located sql server to be extremely slow if Norton system suite is running. Check firewalls, av, anti-spam, and trojan settings on stuff that runs between you and the network. Your traffic is likely being scanned 1 or more times going in and out.

-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: JJLatWebWiz
Date Posted: 28 July 2005 at 7:00pm
My guess is that the indexes that are created when you install the SQL version are much more optimal than the indexes created by the Access upsize wizard.  But running the SQL and Web server on geographically and subnetly diverse machines is always going to be a problem.  Sub half-second response time is more appropriate with a SQL server.  But I would not suggest running both on the same computer.
 
My $.02



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