Our company developing a new software for our devices.
One of the importent issues is choosing the right DB.
The requirements: simple, easy to maintanance, quick to develop.
support multiuser enviroment, and remote stations.
Thousands of records to be stored.
Will be accessed by dozens of threads simultaneously, writing and reading data.
Access doesn't fit because he doesn't treat multiple read-write very well.
SQLite and compact SQL won't fit as well.
I can't decide between SQL Express 2005 and MySQL...
Because from one hand it's important that the installation will be fast and simple (which is the case with MySQL), from the other hand it's important to be able to program and maintain it easily and fast (which is the case with SQL Express 2005).
maybe you have a tip for me?
Or maybe I'm missing something and there is anothere DB I haven't thought about?
Don't ignore PostgreSQL either. As concurrency goes up, it outperforms MySQL, and is very extendable...
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert