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