What should I use: SQL Express or MySQL

[dr_aybyd]

Hi, I have a current project which is storing some information of clients.
What is ideal backend should I use among the two?
This is some sort of clients inventory and target client could be almost 100,000 or less.
Ii it ok if I use SQL Express? If not, maybe I should go for MySQL. I don't wanna use MS Access for this project. Thanks.

[GaryMazzone]

Personally I prefer SQL Express over MySQL, but that is just my opinion

[danasegarane]

Go for SQL Express

Why Should I move from MYSQL to SQL

[dr_aybyd]

In your estimate, how much disk space will consume when such kind of big numbers of clients information.

[jmcilhinney]

Go for SQL Express

Why Should I move from MYSQL to SQL

Um, doesn't that article argue the opposite?

Anyway, as a .NET developer, SQL Server Express is the easy option. It's free, support is built into VS and the .NET Framework, Management Studio is a very good admin tool and 2008 R2 supports databases up to 10GB. If the decision is yours and it will be on Windows, there doesn't seem to be a reason not to use it.

[GaryMazzone]

That depends on you database, what does each row look like? What is the database design? If using VARCHAR or NVARCHAR, CHAR or NCHAR. Are you storing Binary data in the database (pictures, zips, pdfs, docs, spreadsheets,....).

This all makes a difference on how big a database gets. What about indexing, what columns what type of columns, if you use SQL Server (even Express) are you using covering indexes (INCLUED columns).

[danasegarane]

Um, doesn't that article argue the opposite?

Anyway, as a .NET developer, SQL Server Express is the easy option.

[dr_aybyd]

@Gary
Most of it are using VARCHAR.
It also save some pics. But pics are save only the path and filename. I thinks it has 30 columns or more.But no binary included in storing.

@jm
maybe I should go for SQL Server coz its on Windows. Or else maybe I need to read more about the two.
Btw, 100k of records does how much disk should occupy in your estimate.
Thanks.

[si_the_geek]

Thread moved to 'Database Development' forum

100k of records can take anywhere from 100 KB to many terabytes. It all depends on the data you are storing - including the data types of the fields (eg: integers generally take 2 or 4 bytes, and varchar about 10 bytes plus 1 per character), and how much data is stored for each row in variable-length fields (such as varchar).

[dr_aybyd]

Thanks for your all inputs.