On Mon, 26 Nov 2001, Ken Kinder wrote:
> Oracle is certainly more full-featured, but if you know very little about > databases, Oracle is not the right choice. I agree. First of all the system requirements are high. For instance the Oracle Universal Installer took something like three hours on a fairly high end PIII with 133MHz FSB! I have heared it takes for ages (up to a whole day) on other machines. This is not the worse part either. Have you ever used the sqlplus command line utility (which is the equivalent of the mysql command line tool or PostgreSQL's psql command line client). Well, sqlplus assumes your terminal is 24x80 even after you resize it. At least this is so with Oracle8i. I can tell you this: you won't learn much with a crappy tool like that cause as soon as you have more than two columns you won't be able to see the output in human readable form. Now my other point: Oracle8i is highly non-SQL compliant (although Oracle9i seems to be a little bit better). My last point about Oracle is that it is based on Java (see that JServer stuff when you start sqlplus?) and that is perhaps one of the reason it needs so much RAM. With a bit of bias we could conclude that if it were not for its disk and address space requirements then Oracle would be a fairly sluggish beast. > Only use Oracle if you have a > full-time fix-figure-salary Oracle expert AND you actually need Oracle's > features. > > If you don't specifically know you need Oracle, you don't. Exactly. If I had the choice I would stay away from Oracle. Plus Oracle does not have good enough documentation either compared to most Open source products. Now there is one thing that we must be aware of. There are things that mysql does not support (yet). These include foreign keys, views, subselects, triggers, and procedural SQL, and I can't remember if mySQL supports transaction processing either, perhaps someone can confirm. However, mysql is much faster than other database system so you may still want to use it depending on the complexity of your database. If your database is not complex or if you do not need subselects then go with mysql. Most of the time you can get around all of this by recoding some things here and there. But if you are just learning go with postgresql, which will be slower, but will support all this stuff you need to know about databases. Once you have tested your application under postgresql and are certain that your code does not violate the database's foreign key constraint, simply run it under mysql after the testing phase. Then your code will run faster and at the same time free of errors. This is just my own personal recommendation for relatively small applications. Bye, Neil > On Wednesday 21 November 2001 09:45 pm, Mamun Murtaza Sheriff wrote: > > Dear All > > > > You all are working on Database for Long time. In your opinion Which one is > > best 1. MySql or 2. Oracle > > > > > > Mamun > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> Trouble > > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
