How many millions records can Mysql reasonably deal with with .NET ?

tags:

.net
mysql

views:

answers:

+1 Q:

How many millions records can Mysql reasonably deal with with .NET ?

Anybody can tell his experience with MySQL and .NET dealing with millions of records ?

Would myself need to be able to cope with 50 to 100 Millions records and would like to hear about how you cope with this in your precise context so that I may inspire from it.

+3 A:

This question is fairly open ended...

If tuned right, mysql could deal with more than 100M records. It all depends on your indexing and table design, as well as proper server tuning and hardware.

webdestroya 2010-04-29 19:54:40

The question is open ended because I have no idea yet :)But for example you could give your own example about how you tuned it in your precise case.

2010-04-29 19:58:25

You have to make sure you have the smallest possible datatype for each column, and index every column you plan to search on. Keep search results small, using the `LIMIT` and page through them. You should look on some mysql performance sites to see how to customize the config, it is different based on your hardware.

webdestroya 2010-04-29 20:01:47

ansaurus

tags:

views:

answers:

How many millions records can Mysql reasonably deal with with .NET ?

related questions