| Author |
 Topic Search  Topic Options
|
cmeurer 
Groupie
Joined: 23 February 2006
Status: Offline
Points: 58
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: MySQL vs Access vs SQL Server
Posted: 23 February 2006 at 3:11am |
How will MySQL perform in comparison to the other two?
I am hoping that it can handle 100+ concurrent users, and 10,000+ posts. Thoughts???
I read on the board that Access can only handle 20 concurrent. This board ROX by the way!!!!
Thanks ! cm
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2006 at 11:09am |
|
Access is just a simple flat file desktop database system and not really capable of running a forum system with more than a handful of users and is only support because it is cheap and simple to setup for novices.
If I had my way I would like to drop support for Access altogether as it courses to many issues.
SQL Server and mySQL are proper database systems and can both handle very large forums with ease.
Even the cut down lite version of SQL Server (MSDE 2000) is able to handle large Web Wiz Forums as this site currently uses MSDE as it's backend for the entire site, with almost 100,000 forums posts, 8,000 members, and often over 600+ sessions on the site being handled by the on MSDE database. Access simply would be able to cope with this at all.
|
|
|
|
VBScript
Senior Member
Joined: 14 July 2004
Location: United Kingdom
Status: Offline
Points: 219
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2006 at 4:18pm |
|
cmeurer, I am currently developing an application that will convert MS Access Databases to mySQL so if you already have a forum DB on access you can convert it when I release this tool
|
|
|
|
cmeurer
Groupie
Joined: 23 February 2006
Status: Offline
Points: 58
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 February 2006 at 5:26am |
|
COOL. Will it convert from 7.97 Access to final 8 release MySQL? That means I can start my board NOW!! Woohooo....... ;-)
|
|
wistex
Mod Builder Group
Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 February 2006 at 4:25pm |
|
I'd like to have something that allowed me to convert from MS SQL to MySQL.
|
|
|
|
VBScript
Senior Member
Joined: 14 July 2004
Location: United Kingdom
Status: Offline
Points: 219
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 February 2006 at 8:15am |
|
At the moment the program will convert MS Access databases to MySQL. You can choose the table type and if you want to send the table dirrectly to the server/host or if you want it dumped to a *.sql.
I will propably start re-coding and try and get MS SQL to MySQL
|
|
|
|
VBScript
Senior Member
Joined: 14 July 2004
Location: United Kingdom
Status: Offline
Points: 219
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 February 2006 at 8:48am |
 VBScript wrote:
I will propably start re-coding and try and get MS SQL to MySQL
|
This is proving to be very difficult. For a tool like this to be developed it would be very costly. I will try and continue looking into MS SQL conversion but it isn't looking too good at the moment.  I might release the software that only does MS Access -> mySQL and if i receive donations continue onto making MS Access/mySQL/MS SQL to MS Access/mySQL/MS SQL
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 February 2006 at 11:28am |
|
The way I would look at doing it is first create the new MySQL database using the database setup file.
Once the database is created write an ASP application that first disables Auto Number fields, then simply copies across the data from either Access or SQL Server, once complete alter the auto number fields back again.
I've not actually tried this yet in practice, but I would guess this is the most practical way to do it.
|
|
|
|
