Just a quick thought to help me along in my research. I am about to set up a web site for a commercial operation that will probably see 100-200 hits a day at best; perhaps in a year or two more than that.
I have programmed for the last 3 years in VB and used ASP.NET with Access ODBC connection to *.mdb databases.
I want to continue with ASP.NET for the commercial site but I need now to switch over to a back end such as SQL. What might be my best options? MySQL? SQL?
The site will have photo-galleries showing products, shopping cart pages, etc. I will be using php for internal discussion forums on the site so I suppose another option would be to do the entire site with php but would rather go with an SQL or Oracle back end (in case traffic does pick up). On the other hand the site will not be that "database intensive" since the discussion forum and shopping cart/photogallery will really be the only database records being queried.
Anyway, a thought or two just for a little guidance in my research. Thanks and I hope this is not much of an open question.
I have programmed for the last 3 years in VB and used ASP.NET with Access ODBC connection to *.mdb databases.
I want to continue with ASP.NET for the commercial site but I need now to switch over to a back end such as SQL. What might be my best options? MySQL? SQL?
The site will have photo-galleries showing products, shopping cart pages, etc. I will be using php for internal discussion forums on the site so I suppose another option would be to do the entire site with php but would rather go with an SQL or Oracle back end (in case traffic does pick up). On the other hand the site will not be that "database intensive" since the discussion forum and shopping cart/photogallery will really be the only database records being queried.
Anyway, a thought or two just for a little guidance in my research. Thanks and I hope this is not much of an open question.
