Please support our Database Design advertiser: Programming Forums
Views: 2400 | Replies: 4
 |
•
•
•
•
| |
•
•
Join Date: Jun 2004
Location: H4x0rville
Posts: 2,105
Reputation: 
Rep Power: 9
Solved Threads: 18
Take this situation: A Hospital Database containing information on over 800 employees. Which database software would you use? Is Access just as good as mysql?
•
•
Join Date: Jun 2005
Posts: 71
Reputation:
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
server_crash,
It depends on more than just the number of rows you are going to store, like the complexity of the querys, the number of concurrent users the DB must service, performance metrics etc .........
Having said that, I would say that a small DB with < a few thousand rows, and with a small number of concurrent users, that Access would be just fine in this case.
Kate
It depends on more than just the number of rows you are going to store, like the complexity of the querys, the number of concurrent users the DB must service, performance metrics etc .........
Having said that, I would say that a small DB with < a few thousand rows, and with a small number of concurrent users, that Access would be just fine in this case.
Kate
•
•
Join Date: Jun 2004
Posts: 604
Reputation:
Rep Power: 6
Solved Threads: 6
Practically a Master Poster
Hi everyone,
I would use my own implementation - - If you know what i mean - wink
But on the serious side i yhink that access would better suit your needs
Richard West
I would use my own implementation - - If you know what i mean - wink
But on the serious side i yhink that access would better suit your needs
Richard West
Microsoft uses "One World, One Web, One Program" as a slogan.
Doesn’t that sound like "Ein Volk, Ein Reich, Ein Führer" to you, too?
— Eric S. Raymond
Tell me what type of software do you like and what would you pay for it
http://www.daniweb.com/techtalkforums/thread19660.html
Doesn’t that sound like "Ein Volk, Ein Reich, Ein Führer" to you, too?
— Eric S. Raymond
Tell me what type of software do you like and what would you pay for it
http://www.daniweb.com/techtalkforums/thread19660.html
•
•
Join Date: Jun 2004
Location: H4x0rville
Posts: 2,105
Reputation:
Rep Power: 9
Solved Threads: 18
Well, this isn't my DB. It's the hospitals that I work at. I'm wondering since access is limited to only 5 connections if that could be the cause to some of the problems it's having, or if it could be the access "programmer"(as they call him). The database is not registering changes untill the second time, but I'm not sure how many people other than me have access to it. It is on a novell workspace, so that is questionable. I wish there was a way I could find out how many connections are actually made to it.
•
•
Join Date: Jun 2004
Posts: 604
Reputation:
Rep Power: 6
Solved Threads: 6
Practically a Master Poster
Re: access vs mysql in this situation Hi everyone,
I am not sure about this but i think it would equire you using some winapi classes.
Sorry i could not be of much help
Richard West
•
•
•
•
Originally Posted by server_crash
I wish there was a way I could find out how many connections are actually made to it.
I am not sure about this but i think it would equire you using some winapi classes.
Sorry i could not be of much help
Richard West
Microsoft uses "One World, One Web, One Program" as a slogan.
Doesn’t that sound like "Ein Volk, Ein Reich, Ein Führer" to you, too?
— Eric S. Raymond
Tell me what type of software do you like and what would you pay for it
http://www.daniweb.com/techtalkforums/thread19660.html
Doesn’t that sound like "Ein Volk, Ein Reich, Ein Führer" to you, too?
— Eric S. Raymond
Tell me what type of software do you like and what would you pay for it
http://www.daniweb.com/techtalkforums/thread19660.html
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode