I am planning to work on new website. It has more than 5000 records. And that will goes on increasing.
I am using .NET framework (Asp.net).
What will be better option regarding choosing database server?
Will MYSQL better or oracle?

It depends!

Oracle, absolutely, because it's a much higher quality software. That's like asking if a space ship is faster than a snail.

But 5,000 or even 50,000 rows is nothing. Even something like MS Access or MySQL can handle that without breaking a sweat.

Like John said, oracle and mysql are not on the same level here.
If you can go with Oracle, go with it.

But just a quick question...
If you go Asp, it means you have a windows hosting solution.
Don't they provide MS sql server (even the express version) in that case ?
You can be confident it will be more than enough, and even me as a free software advocate, I would recommend you MS sql server rather than mysql.

For having worked on many DB engines, mysql is the last one I want to work with in a production environment.
Almost anything but that...

paid!!
-ms sql server
-oracle

free.. open source
-mysql

i have a question here, is it possible if we use asp.net using visual basic to develop web BUT using MySQL database?

thanks..

It should be. Probably, you will need to create an ODBC connection to the db, and then you should be able to use it.
Talking from a logical deduction though, as I'm a linux guy.

But honestly, mysql don't even come close to ms sql server (mark that, a Linux enthusiast that recommends ms sql server!) nor oracle.
Postgresql [http://www.postgresql.org/] is far more on the par level than mysql, and is an open source DB engine too, if "free as in beer" is your main criteria.
And, from the "about" page of their site:

It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

With .NET code, you can connect to any database that's been exposed through ODBC. You'll have to put MyODBC on whatever machine will run your code, tho.

thanks man for the idea..

i'll check out the Postgresql ...

MyODBC - is it a software or line of coding that we usually used in asp

how do we get it and any tutorial there... thanks John

MyODBC - is it a software or line of coding that we usually used in asp

It is the ODBC Driver needed to interface ASP/.NET with MySQL

download it from MySql and use in exactly the same way as all the other ODBC drivers

Originally Posted by Learning Newbie

Oracle, absolutely, because it's a much higher quality software. That's like asking if a space ship is faster than a snail.

But 5,000 or even 50,000 rows is nothing. Even something like MS Access or MySQL can handle that without breaking a sweat.

I'd say if your computer can handle it, it doesn't matter what you choose...I never used access for much, but I would imagine both are good, but if your computer is descent, I'm sure either or would suffice.

On a side note: If you choose mySQL, you are going to say I should of went with MS Access. So what REALLY is the difference is YOU.

I think MySQL is the best. I use only it.

I think MySQL is the best.

I beg to differ.
There are many other DB that are way more easy to use, have better support for many useful functions.

And I don't speak about DB2 or Oracle nor ms sql server, although any of those 3 is better than mysql in my opinion.

The only reason mysql is so widely used today is because it's development have been tied to PHP.
Without PHP, we would have way less mysql instances.
It's fine if you just do simple select/update/insert statements, but when it comes for further functions (SP, updatable views, replication, clustering, native XML support), it is simply not adapted.

But when I read on the blog of one of the mysql founder:
http://monty-says.blogspot.com/2008/...-released.html

It may even be the best to wait for a couple of minor/patch releases before putting the MySQL 5.1 server into production.

Don't expect that all critical bugs that you may have encountered in 5.0 to be fixed in 5.1. Even if we have fixed a big majority of the bugs from 5.0 some really critical ones still haven't been addressed.

It don't make me more confident over the product.
Sure, mysql 5.1 is beta, and every half decent sysadmin should be really careful about them.

I personally work now as a dba on ms sql server, worked previously on Oracle, and is a linux enthusiast that adopted Postgresql for years.
And the truth is that each time I have to work with mysql, I miss many usefull functions I have at disposal elsewhere.

Originally Posted by Brian07002

I'd say if your computer can handle it, it doesn't matter what you choose...I never used access for much, but I would imagine both are good, but if your computer is descent, I'm sure either or would suffice.

For a single user application, you're right - any commercial workstation should be able to handle a small, decently written database application. For a web site, without knowing how many concurrent users there might be, that's not a safe thing to bank on.

Also, it's not just the speed of MySQL that's problematic. A database is supposed to be the bible, a source of knowledge and absolute truth. MySQL fails silently in all sorts of ways, and isn't reliable enough to be the knowledge store.