|
06-08-2004, 12:37 PM
|
#1 |
|
Junior Member
Join Date: Jun 2004
Posts: 3
|
What database are the best to use for different purposes
How do the different database compare? In which case would you prefer to use Mysql vs. Oracle or Microsoft SQL?
|
|
|
|
06-25-2004, 12:54 PM
|
#2 |
|
Administrator
Join Date: Jun 2004
Posts: 383
|
Re: What database are the best to use for different purposes
MySQL is free which is one good reason to use it. I don't know much about Oracle or Microsoft's offering. I've used Sybase before. What I'd like to see in MySQL is row locking. I believe row locking is available for a paid version of MySQL, but hopefully this will be coming soon on the free version.
|
|
|
|
|
12-01-2004, 05:08 AM
|
#3 |
|
Junior Member
Join Date: Dec 2004
Posts: 11
|
Re: What database are the best to use for different purposes
There should be no question - ORACLE [b]is]/B] the Porsche of databases. However, yes, it costs
For little web site projects... .MySQL works great, and it really does scream. Vmusic |
|
|
|
|
12-01-2004, 06:34 AM
|
#4 | |
|
Administrator
Join Date: Jun 2004
Posts: 383
|
Re: What database are the best to use for different purposes
Quote:
There are certain cases where you should use other databases than Oracle for the best performance. Batch data will do better with some other databases. The overhead of transactions/rollbacks is costly in these cases. Supposedly a new breed of databases are very fast for the right kind of machine. I've used Objectstore before, but it was a nightmare. Maybe they worked out the yayas by now. Google probably has a mean custom database system  But if you need to update/select live data and ensure you won't lose anything Oracle is definitely the way to go. |
|
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Command to return summary info about database | Bex | SQL syntax | 0 | 02-01-2005 04:15 AM |
| Needt to design rental database - How do I begin | Tsynergy | Database Design | 4 | 12-16-2004 03:09 AM |
| Where can I get a database of UK Post Codes? | Amato | General | 0 | 06-30-2004 12:10 PM |
| 3.3 Creating and Using a Database | Administrator | Documentation | 13 | 06-09-2004 04:56 PM |
| 1.2 Overview of the MySQL Database Management System | Administrator | Documentation | 0 | 06-07-2004 10:11 PM |
