I'm using Oracle 8.0.5 and MySQL 4.1.1a I'm not optimizing Oracle nor MySQL, because I don't want future users messing with optimizations. I access through JDBC drivers. Oracle usually needs 10 seconds in every query I execute. It is very odd.
Thank you again. ----- Original Message ----- From: "Weaver, Walt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 16, 2004 4:00 PM Subject: RE: MySQL vs Oracle You didn't provide much information about your system. What version of MySQL? Oracle? With Oracle, which optimizer are you using? Oracle, compared to MySQl, is very tunable and it's easy to make it run badly. We run customer databases on both MySQL and Oracle, using a product developed on MySQL and then "ported" to Oracle. With our system we found that using the cost based optimizer, computing histograms, forcing cursor sharing and dozens of other things enable our Oracle sites to run as "fast" as MySQL. We're running MySQL 4.0.18 and Oracle 8i and 9i at the latest patch levels. Applying the appropriate patches on Oracle can make a big difference too. --Walt > -----Original Message----- > From: Jaime [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 16, 2004 4:59 AM > To: [EMAIL PROTECTED] > Subject: MySQL vs Oracle > > > Hi all! > > I'm developing a system using both MySQL and Oracle for > document processing. I issue a series of queries to the > database, depending on the document size. For big documents, > both databases behave in the same way but, when using small > documents, MySQL finishes quickly while Oracle consumes a > considerable amount of time. > > What could be the reason? I think it is due to Oracle > checking of restrictions and/or sequences management but I am > not sure. > > Thank you very much! > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]