ASP.NET with Database

I have been using only ASP to process my templates.The site is very fast now. But i am not able to provide lots of facility to customers without a database.

will it increase the loading time if i use SQL server ? I have MySQL, MS access and SQL server.

Any suggestion on selecting a database ?

Thanks,
e-webtemplates

 

if your server speed is fast, it shouldn't increase that much.

I recommend that you use MySQL if possible.

 

The increase in load-time vs the advantages you will receive from being able to use a database makes using the database well worth it.

As far as which database to use depends on your hosting services. You may wish to use MS Access databases if you don't have MS SQL and MySQL in your hosting plan, but MS SQL and MySQL are more efficient when used correctly.

 

why MySQL

there is 100% support sql server in .net

 

Thanks all for your help. I have added reputation to kadesmith for his help.

 

Definitely go with SQL Server, and use the SqlClient namespace in ASP.NET to access your data. This will increase the load time for your pages, but if you set things up properly, it should be by a very hard to notice amount.

 

Now e-webtemplates is a data driven site using ASP.NET and SQLserver 2005. used SqlClient namespace . Pls let me know if you have any problem accesing my site.

 

MySQL with asp.net is a horrible solution, it will just give you headaches when you're trying to create datasets, do connectivity using visual studio or anyting of that nature. The ODBC drivers are really bad and haven't been kept up.

I would suggest you use SQL Server because it ties in very nicely, and the new NativeClient drivers are very good. Only problem with SQL Server is it costs a good chunk of change, but if you have the funds I would definately go with SQL Server.

The database is not going to put too much load on the site unless you get a massive amount of traffic in a short period of time. Just don't open and close too many connections because that's the most expensive part of database work on a site.

 

only one connection needed to get the data from the SQL server. I close it once i am done with that. And another connection for CMS.

It's working great. .NET with MS SQL is really a good option.

 

Did you try with MYSQL? I am wondering how MYSQL will perform again MSSQL, as MYSQL hosting comes cheaper compare to MSSQL.

Regards,
UrStop

 

I havnt tried MYSQL. There are lots of advandage with ASP.NET & MSSQL

eg. You can find lots of code sample for .NET with MSSQL than MYSQL.

 

Both are good, but in many web hosting company MS SQL will not provide. So better use My sql

 

Also, need to cosider the about of data to be handled, I think SQL Server can handle more data than mysql? Any comments?