Page Generate Time - SQL vs Access

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
superlative Members Profile Find Members Posts Groupie Not Comparative, I m Superlative :) Joined: 26 November 2004 Location: Turkey Status: Offline Points: 125	Post Options Post Reply Quote superlative Report Post Thanks(0) Quote Reply Topic: Page Generate Time - SQL vs Access 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: I download v7.9 SQL and Access versions. First I migrate to v7.9 Access version Create blank DB in my SQL And setup my SQL forum Then delete all tables Then I am using import wizard and I import access to SQL (for tables) 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.


dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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).

superlative Members Profile Find Members Posts Groupie Not Comparative, I m Superlative :) Joined: 26 November 2004 Location: Turkey Status: Offline Points: 125	Post Options Post Reply Quote superlative Report Post Thanks(0) Quote Reply 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


ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply 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 L. Jamal Inc : Web/ Print Design and ASP Programming

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

superlative Members Profile Find Members Posts Groupie Not Comparative, I m Superlative :) Joined: 26 November 2004 Location: Turkey Status: Offline Points: 125	Post Options Post Reply Quote superlative Report Post Thanks(0) Quote Reply 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..


superlative Members Profile Find Members Posts Groupie Not Comparative, I m Superlative :) Joined: 26 November 2004 Location: Turkey Status: Offline Points: 125	Post Options Post Reply Quote superlative Report Post Thanks(0) Quote Reply 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.


dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply 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.

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum