10 messages in com.mysql.lists.javaRe: mysql strange performance
FromSent OnAttachments
Pierre-Etienne Melet28 Jul 2004 14:59 
Przemysław Klein29 Jul 2004 02:15 
Przemysław Klein29 Jul 2004 02:25 
Christian Hammers29 Jul 2004 03:16 
Przemysław Klein29 Jul 2004 03:21 
Przemysław Klein29 Jul 2004 04:03 
Cesar Vega29 Jul 2004 05:54 
Mark Matthews29 Jul 2004 05:57 
Przemysław Klein30 Jul 2004 00:04 
Przemysław Klein30 Jul 2004 01:33 
Subject:Re: mysql strange performance
From:Przemysław Klein (p.kl@ziaja.com)
Date:07/29/2004 03:21:35 AM
List:com.mysql.lists.java

Hi,

The order in which I run the methods doesn't matter. Method with
Double.parseDouble(rs.getString(...)) is always incredibly faster. I tried this code on 2 server versions: 3.23 & 4.0.14 with comparable results.

If this is uncommon problem, I can prepare exact code I run on my machine.

Przemek.

On Thu, 29 Jul 2004 12:16:22 +0200 Christian Hammers <ch@lathspell.de> wrote:

Hi

On 2004-07-29 Przemys_aw Klein wrote: ...

Retrieving data with method1 is 200 times slower that method2. I tried >
executing code on versions 3.0.8 & 3.0.14.

But you are sure that you don't see a caching effect, especially the MySQL Query
Cache (MySQL-4.x)?

-christian-

-- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/java?unsub=p.kl@ziaja.com.pl