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]