Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Access to SQL?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

arboleas
Starting Member

24 Posts
Posted - 23 January 2008 :  06:46:04  Show Profile
My forum has been running slowly lately as it has grown in size.

Someone has mentioned that this could be down to the fact we are using an Access database instead of an SQL database.

So my question is can we migrate from Access to SQL and if so is this a big job?

Thanks

phy1729
Average Member

USA
589 Posts
Posted - 23 January 2008 :  08:03:50  Show Profile
FAQ I believe there is another more detailed post but I can't find it.
Edit:found it
Edited by - phy1729 on 23 January 2008 08:11:32
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts
Posted - 23 January 2008 :  08:36:09  Show Profile  Send pdrg a Yahoo! Message
If your db is HUGE then maybe - but Access/Jet isn't the evil thing some people say it is. I do prefer MSSQL, but for most web apps and most forums, Access/JET itself won't be the weak link.

How many *concurrent* users have you got?
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 24 January 2008 :  13:04:43  Show Profile  Visit AnonJr's Homepage
Another question worth considering is: how long has it been since you archived some of your old topics? If you haven't done it before or in an appropriate time frame for your forum, archiving old topics can potentially give you a bit of a performance increase.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.65 seconds. Powered By: Snitz Forums 2000 Version 3.4.07