Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: phranque
I need some advice and where better than this excellent forum.
I am in the very early stages of a new project. This is a dating site in a niche market. I have been looking into the basic infrastructure of the site and have come across someone who will sell me the basic site which I can then modify.
The system runs on an ASP server that can interpret MS Access dbases. So my question is, is MS Access a good database for this purpose? or does it have any faults such as being too lightweight or such like?
I have little knowledge of how databases so any input would be appreciated.
Personally, when I design a database-driven site, I almost always use MySQL and have it run over PHP or JSP.
Unless a client specifically requests a MS product such as Access, I go the MySQL route. I even go so far as sometimes discouraging them to use Access.
Access is also very limited in the amount of data it can hold. If your site grows fast, as it should, you may run out of space with access.
"The dbase is efficient to about 2-300,000 members, whereafter a conversion to MySQL would be a good idea. This conversion is very simple - a programmer
could write a script for it in a matter of hours. I am not aware of any MySQL dbases for this kind of site."
Is he correct?
One I overcame my own fear of the onknown, it turned out to be much simpler then my previous solution. If you spend some time to get into ti you will find that not only is MySQL technically suitable, but also quite easy to mantain, run and program for.