RE: better performance with optimize!?? (jboss)

2004-08-02 Thread Victor Pendleton
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

Re: better performance with optimize!?? (jboss)

2004-08-01 Thread Jeremy Zawodny
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

better performance with optimize!?? (jboss)

2004-08-01 Thread Marc
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