Web Wiz Support and Community Forums : Page Generate Time - SQL vs Access https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 15:20:41 +0000 Thu, 28 Jul 2005 19:00:46 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15247 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Page Generate Time - SQL vs Access : My guess is that the indexes that...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post87840.html#87840 Author: JJLatWebWiz
Subject: 15247
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
]]> Thu, 28 Jul 2005 19:00:46 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post87840.html#87840 <![CDATA[Page Generate Time - SQL vs Access : I&#039;ve found that testing from...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84133.html#84133 Author: dpyers
Subject: 15247
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.]]> Sat, 28 May 2005 15:52:36 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84133.html#84133 <![CDATA[Page Generate Time - SQL vs Access : I see very interesting results....]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84124.html#84124 Author: superlative
Subject: 15247
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
 
My test enverionment :
 
www.knowhow.gen.tr/forum this is v7.7 Access version (actual forum)
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.
]]> Sat, 28 May 2005 14:21:48 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84124.html#84124 <![CDATA[Page Generate Time - SQL vs Access : Thanks for answers, in my test,...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84112.html#84112 Author: superlative
Subject: 15247
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..
]]> Sat, 28 May 2005 11:12:22 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84112.html#84112 <![CDATA[Page Generate Time - SQL vs Access : Some pages you may see a drop...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84093.html#84093 Author: WebWiz-Bruce
Subject: 15247
Posted: 28 May 2005 at 3:08am

Some pages you may see a drop in performance because of the way thedifferent databases work, but overall you should see a smallimprovement, especially as your database gets larger.

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

However, you do get many other benefits from using SQL Server, as itcan 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 notcope with the amount of abuse a forum gives it and often becomescorrupted and not recoverable (I get emails about this almost daily).With MS SQL Server, you won't get this.
]]> Sat, 28 May 2005 03:08:10 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84093.html#84093 <![CDATA[Page Generate Time - SQL vs Access : If the SQL ídn&#039;t on the same...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84088.html#84088 Author: ljamal
Subject: 15247
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)]]> Fri, 27 May 2005 21:45:26 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84088.html#84088 <![CDATA[Page Generate Time - SQL vs Access : I compare same size forums, (SQL...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84068.html#84068 Author: superlative
Subject: 15247
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 
]]> Fri, 27 May 2005 14:13:49 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84068.html#84068 <![CDATA[Page Generate Time - SQL vs Access : this will take time for the indexs...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84020.html#84020 Author: dj air
Subject: 15247
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).
]]> Fri, 27 May 2005 06:40:28 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84020.html#84020 <![CDATA[Page Generate Time - SQL vs Access : Hi Everyone I am using v7.7a...]]> https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84006.html#84006 Author: superlative
Subject: 15247
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.
]]> Fri, 27 May 2005 00:25:34 +0000 https://forums.webwiz.net/page-generate-time-sql-vs-access_topic15247_post84006.html#84006