It's probably not odd. Does every query take 10 seconds to execute, or is that how long it takes to return data?
Why don't you run tkprof on the Oracle queries to see how long they actually take to complete? --Walt > -----Original Message----- > From: Jaime [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 16, 2004 8:12 AM > To: [EMAIL PROTECTED] > Subject: Re: MySQL vs Oracle > > > 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/mysql?> [EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
