Re: DATABASE QUESTION
Date: Sat, 07 Jun 2003 00:55:34 GMT
Message-ID: <3EE13806.80708_at_example.net>
From personal experience, I know MySQL [no, this is not a rant for the opensource] is more than adequate for any small to mid-size company needs. I personally know 3 businesses of 50, 100 and 500 approx. with MySQL as their RDMS due to financial reasons [support and learning curve costing only a fraction of the others] and to escape Access. To give you a quick idea of what it can handle, the largest of the above handles transactions on various customer/service requests [customer info, order processing, lookups, and scheduling], inventory [current stock, utilization, expiration, incoming], and the employee records [daily/weekly in/out, status, pay rates, and personal info]. The smallest has moved it's record's to two machines relatively painlessly [the second time with a quick look at the documentation and a half hour, the first requiring two hours and some stumbling =].
Though more robust than MSSQL or Access [personal opinion], I wouldn't recommend it for "more-than-critical" or beyond `typical` mid-size business data needs [though you say around 300 that may be 300 government programmers for all I know] and would have to say Oracle or Sybase, with the latter for preference.
Just my two-cents
Newbie ^_^
Michael Gast wrote:
> Hi Puppy,
>
> Pupppy Wizzard schrieb:
>
>>Hi. We are setting up a new database. We previously used MS Access, >>but we want something better. >> >>What would be a good choice for a company with 300 employees from: >> >>MS SQL SERVER >>Oracle >>Sybase >>MySQL >>Paradox
>
>
> That depends not only on the number of employees in your company but
> also in what you want to do.
>
> Some questions:
> * Do you have any ideas about the volume and structure of the
> data you want to store in your database(s)?
> * What is the transaction load?
> * What is the transaction profile?
> * What level of concurrency in accessing your data do you need?
> * Any idea for the server operating system(s)?
> * Any idea for the client operating system(s)?
> * What applications do you want to use to access the db?
> * What architecture do you want to realize? 2-tier? 3-tier?
> * Do you need a redo log facility?
> * What about data security, encryption, acces control?
> * .......
>
Received on Sat Jun 07 2003 - 02:55:34 CEST