Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - converting from access to SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

converting from access to SQL

 Post Reply Post Reply Page  <12
Author
benzeer View Drop Down
Newbie
Newbie


Joined: 08 July 2002
Location: United Kingdom
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote benzeer Quote  Post ReplyReply Direct Link To This Post 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,

Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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).
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.