Can anyone share their experience with MySQL and .NET dealing with millions of records?
I would have to deal with 50-100 million records and would love to hear about how you handle this in your particular context so I can inspire it.
This question is pretty open ...
If configured correctly, mysql can handle over 100 million records. It all depends on your indexing and table design, as well as the correct server and hardware setup.