converting from access to SQL
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=2454
Printed Date: 01 April 2026 at 7:55pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: converting from access to SQL
Posted By: Rob C
Subject: converting from access to SQL
Date Posted: 06 May 2003 at 1:39am
|
Hi, I have a forum which is in access 2000. However when there are a few members online and on a 56k connection it is terribly slow. Would converting it to SQL speed it up and how hard is this to do? thanks in advance! |
Replies:
Posted By: Trevni
Date Posted: 06 May 2003 at 2:35am
|
Not very, Access has an upgrade tool called the Upsize Wizard. You can find it on the Microsoft Access Menu
Go to: TOOLS |_ DATABASE UTILITIES |_ UPSIZE WIZARD ------------- Resident immature brat... |
Posted By: Rob C
Date Posted: 06 May 2003 at 3:59am
|
would it make it faster though? like php boards etc? thanks |
Posted By: Rob C
Date Posted: 07 May 2003 at 1:44am
| anyone!? |
Posted By: WebWiz-Bruce
Date Posted: 07 May 2003 at 3:48am
|
SQL srever is much faster than Access. ------------- 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: eksimba
Date Posted: 07 May 2003 at 3:13pm
It seems that there may be two conditions slowing the board down: database and bandwidth. If the slowdown problem is caused by or increased by a greater number of simultaneous visitors, then switching from Access to SQL Server will most likely speed things up. But, if the slowdown is because the users are on a relatively slow dial-up connection, then switching to SQL Server will have only a minimal impact, if any. ------------- - eric |
Rob C wrote:Posted By: Rob C
Date Posted: 13 May 2003 at 10:32am
|
thank you for your help and input. Is it difficult to convert to sql from access? What is the best server to host the boards on where they will run quickly!!?
thanks |
Posted By: Rob C
Date Posted: 16 May 2003 at 2:12am
| anyone? |
Posted By: benzeer
Date Posted: 22 June 2003 at 3:34pm
|
Hi Rob, I would not recommend you to upgrade from MS Access to SQL server if your database were less than 10MB because MS Access is better than SQL with dealing with small size of database. I hope my participation was helpful, Good luck, |
Posted By: ljamal
Date Posted: 22 June 2003 at 4:04pm
It depends.... If your DB and Web server on the same network, then it will be faster. If not then it will be much slower. WWF speed depends on the proximity of your SQL and your web server as it makes multiple connections to your database on each page. If your SQL and web server are on the same network, then the connection time is minimal, but if they are not then the connection time starts to add up. Through optimizing the code for SQL Server you can overcome this, but you will have to modify the code with every release and would be better off with a forum that makes better use of SQL Server's ability to return multiple recordsets with a query (ie one that does not also have a Access version). ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |