Have you run an explain before each scenario to see if the access path is
different?
-Original Message-
From: Jeremy Zawodny
To: Marc
Cc: [EMAIL PROTECTED]
Sent: 8/1/04 8:28 PM
Subject: Re: better performance with optimize!?? (jboss)
On Sun, Aug 01, 2004 at 01:42:24PM +0200, Marc wrote
On Sun, Aug 01, 2004 at 01:42:24PM +0200, Marc wrote:
> I use Mysql with JBOSS as applicationserver.
>
> i have strange response-time differences, which i can't explain.
>
> 1) after reboot the computer, it takes about 300ms to read 12 entities (cmp,
> read ahead, 2 rows each entity) One entity i
I use Mysql with JBOSS as applicationserver.
i have strange response-time differences, which i can't explain.
1) after reboot the computer, it takes about 300ms to read 12 entities (cmp,
read ahead, 2 rows each entity) One entity is accessed by primary key, the
others by
foreign key.
2) when i r
