What type of database?

[duniyadnd]

Hi there, what type of database do you guys use with Asp frequently? I know you can use MS Access, but I don't think that's really a viable program, considering its speed, but then again, I don't know much about how ASP works with databases.

[raf]

I use MsAccess and MySQL (<-- mostly with PHP)
The pro's and contra's are discused here
http://www.codingforums.com/showthread.php?s=&threadid=21139

Why these? MySQL is free and fast + widely supported. MsAccess is also (almost) free and is supported by most free ASP hosts + it's verry easy to use. MsAccess and MsServer have some nice things MySQL doesn't have (see thread) but they can't compete in terms of performance (page throughput) if you have a high number of simultanious users (Access should only be used for 'almost single' user application, MsServer will be significantly outperformed by MySQL before you have 100 simultanious users).

Access --> smaller apps or app with maximum 10-20? simultanious users
MsServer --> app's with more simultanious users, if you need a db that is easy to manage and has some extra features and doesn't cost to much
MySQL --> if you use PHP or host your own server or have a host that supports both ASP and PHP. I hope i ever have an app running where MySL can't deliver. I think its super and use it for all new apps i'm working on or gonna start working on
Oracle, DB2 --> I fmoney is no object and you need industrial strength.
But if money is not

[fractalvibes]

MySql is an excellent database. Lacks a few features such as stored procedures, triggers, subqueries, but a real workhorse.

DB2 is industrial strength, but is $$$$. Thinking there is a DB2
personal edition, but you'd have to check the licensing restrictions, if any.

Use MySql - works fine with both ASP and PHP. The price is right also!

Phil J.

[raf]

I almost totally agree with fractalvibes. But just to be complete:
Lacks a few features such as stored procedures, triggers, subqueries, but a real workhorse
--> subquerys were implemented in MySQL version 4.1 (called subselects there
--> stored procedures and trigers will be implemented in MySQL 5

It's great there is a free db like that out there...