Last post Jun 27, 2012 02:45 AM by Mikesdotnetting
Jun 26, 2012 06:06 PM|vabatta|LINK
my title says all. I discovered few days ago the big and beatiful world of Asp.NET and I have lots of questions regarding it. First of all, if I have my database and I upload it to my website and in asp.net I query to it or I use the provided database from
host I have any perform change?
Thanks for help :)
P.s.: I'm not english as you can see :D
Jun 27, 2012 02:45 AM|Mikesdotnetting|LINK
Access can be quite good for smaller web sites that don't get too much traffic, but it was never intended to be used in web sites. Having said that, I had sites running on Access that had 20,000 to 30,000 queries a day and they worked fine.
In my opinion, if you prefer a file-based database, you should look at SQL Compact 4.0 instead. That has been designed to work on the web, and is just as simple to deploy - just FTP the .sdf file to your App_Data folder. SQL Compact 4.0 supports a much wider
range of funcntions than Access, too. And with Visual Web Developer 2010 SP1, you get tools for working with a SQL Compact database.