|
| |
|
|
jbuss
Posts: 7
From: Vancouver
Status: offline
 |
Which database should I use? - 4/11/2001 20:29:00
I've got my front end under control and ready to deal with the back end of my site. I want hundreds of users to login to my site, then access (add and subtract) to a database containing a few fields of very basic info. This database can be viewed by selected other users. The task of the database is simple but will have many unique users. What Database program would you recommend? I hear Access will not do the job with lots of hits. MySQL has been recommended. Any thoughts?
|
|
|
|
Vince from Spain
Posts: 658
From: Madrid Spain
Status: offline
|
RE: Which database should I use? - 4/11/2001 20:31:00
Hi there,
can you give us some idea of how many people you expect per hour / day?
Although people are often put off by the fact that Access can only support 20 odd simultaneous connections, this does work out to a lot of people on your site per day. It is by far the easiest option for implementation, especially if it is your first DB project.
MySQL is a superb system and will cut it if you really are expecting several thousand hits per day. It is available on Windows, but will normally be found living on Linux / Unix servers where you might be able to use Chilisoft ASP, but often have to use PHP. Not bad systems at all, but there is just a bit less Spooky style advice and help out there.
So, my view is if you really need it go for mySQL, it's great, just a bit harder. Otherwise go Access.Vince
------------------
Internet Business Solutions S.L.(Spain)
| |
|
|
|
jbuss
Posts: 7
From: Vancouver
Status: offline
|
RE: Which database should I use? - 4/11/2001 23:28:00
Yes Vince, this is my first DB and I'm an html dummy, but know a fair bit about computers. I'm doing alot of learning with Frontpage.
My site will likely be hit by possibly hundreds of people at the same time. Sounds like Access won't cut it right? Well could I do this, launch the web page using Access as my back end, then once the number of users increases, switch (maybe hire someone who can do the job) to MySQL? The bottom line is I need my site to perform well while the user base increases daily (expected). Any idea on where I could get a crash course on implimenting databases to a MS Frontpage built front end?
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Which database should I use? - 4/11/2001 19:03:00
Just remember that although the databases may be similar, the coding is not.You may write something with say, FP2000 that is only compatible with an asp enabled server.
This is no good if you are on Unix ![]("http://www.frontpagewebmaster.com/ubb/smile.gif") SQL2000 is MS's web version of access and will perform as well as if not better than mySQL.
Your host may be able to give you a cost on that too. ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
jbuss
Posts: 7
From: Vancouver
Status: offline
|
RE: Which database should I use? - 4/17/2001 20:01:00
Vince and Spooky, thanks very much for your helpful comments.
I bought the SQL for dummies book and am trying to get a grasp of the overall concept of implimenting mySQL and PHP with my FP2000 web project. I just don't get it (because I'm new to this stuff). My concern with Access is the number of simultanious requests my page is expected to get and the max number Access can handle (20?). Could I do this: use Access to get my site live, and once I notice the hits per day increase could I EASILY change over to MS SQL Server 2000?? Or would the change create a difficult situation for someone as novice as me? Thanks again.
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Which database should I use? - 4/18/2001 20:31:00
I think if you can master step 1, using the access database pages, and you dont get too complicated, you will find the next step easy.
You do need the tools, such as Access 2000 in order to upsize, but most of the wizards arent too hard to come to grips with (says me!:)------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
