newbie wants to change from Access to MySQL

[gavray]

hi,

I'm using Access 2000 but as my website traffic is increasing to about 300 unique visitors a day I think or am aware that Access can only handle 10 concurrent users or something.

Can I ask you more experienced users:

* Is mySQL a lot better at handling more traffic, how much can it handle before performance drops?

* Can I use asp and what are the connection strings like in comparison?

* Is it easy to change over?

* Can you recommend any good sites?

Thanks

Gavin

the boho from soho

 

[piti]

hi

as access 2000 is not a db server you should definitely change to some server (mysql, posgresql, ...)

now to your questions:

mysql is surely better at handling traffic than an access file - by default it's set to max 100 connections
as you have only 300 users a day - you don't need to worry about performance dropping

yes u can use asp - i do not use it, so can't provide you with the connection strings

depends on your skills ;-), but there are some apps that would help you to switch over

to get you started read the manual -

http://www.mysql.com/documentation/index.html

hope that helps