Last post Aug 12, 2010 04:03 AM by ufazal
Aug 12, 2010 02:33 AM|ufazal|LINK
Hi all, This is my 1st post at asp.net forum.
I am developing a large e-commerce system.
I am using asp.net 2010 with mysql database. Is it practical for large amounts of data ? say 10 million records ? cuz some people said to me that using this combination, i'll be having performance issues as database grows.
I am a bit confused :p
large amounts of data
asp.net and mysql
Aug 12, 2010 03:14 AM|XIII|LINK
I don't know about MySql but one of my colleagues works on a big tool with ASP.NET in combination with Sql Server and one of his tables contains 425 million records. With the right indexes placed and optimized stored procedure queries it's still working
Sql Server isn't MySql however but you can also create indexes on columns:
http://dev.mysql.com/doc/refman/5.0/en/create-index.html which already can give your database quite some boost.
Aug 12, 2010 03:37 AM|ufazal|LINK
Thanx for the reply Grz, Kris.
Thats exactly what other people say to me that use it with MS SQL server. And thats where i am confused and cant decide. Should i go for MS SQL SERVER ?
Aug 12, 2010 03:50 AM|XIII|LINK
MS SQL server
I think that mostly depends on which people you ask. There will be others that only want to use Oracle or Postgressql for example.
i am confused and cant decide
Mysql is free. I suggest you simply set it up, put in the records, lay the best possible indexes (I don't know if there are tools to measure the effect like you have with SQL Server). Try to run performance tests on your application and measure whatever
you did to try to upgrade your performance when possible.
Use Caching in your ASP.NET application whenever possible to increase performance.
Aug 12, 2010 04:03 AM|ufazal|LINK
I think i should setup mysql. :)
That was really helpful Kris. Thanks a bunch.