Print Page | Close Window

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
Originally posted by Rob C Rob C wrote:

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!

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


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
Originally posted by Rob C Rob C wrote:

would it make it faster though? like php boards etc?


thanks



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



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