RE: T5 and hibernate slowing with more records

2009-01-16 Thread James Sherwood
Jonathan Barker [mailto:jonathan.theit...@gmail.com] Sent: January-16-09 12:31 AM To: 'Tapestry users' Subject: RE: T5 and hibernate slowing with more records Been there, hit that. You need to clear() the session. Or, you can also evict() as you go. Basically, every time Hibernate need

RE: T5 and hibernate slowing with more records

2009-01-15 Thread Jonathan Barker
: Thursday, January 15, 2009 13:16 > To: 'Tapestry users' > Subject: T5 and hibernate slowing with more records > > Hello, > > > > I am using POI to take an excel file and put it into a Mysql database > using > hibernate. > > > > I put a coun

RE: Re: T5 and hibernate slowing with more records

2009-01-15 Thread Angelo Chen
once using the session that > might be faster as well. > > --James > > -Original Message- > From: Angelo Chen [mailto:angelochen...@yahoo.com.hk] > Sent: January-15-09 9:33 PM > To: users@tapestry.apache.org > Subject: [Spam Rating:3.18] Re: T5 and hibernate

Re: T5 and hibernate slowing with more records

2009-01-15 Thread Christian Edward Gruber
er as well. --James -Original Message- From: Angelo Chen [mailto:angelochen...@yahoo.com.hk] Sent: January-15-09 9:33 PM To: users@tapestry.apache.org Subject: [Spam Rating:3.18] Re: T5 and hibernate slowing with more records Hi James, I do not see any reason why it is slow, but would sug

RE: Re: T5 and hibernate slowing with more records

2009-01-15 Thread James Sherwood
ht be faster as well. --James -Original Message- From: Angelo Chen [mailto:angelochen...@yahoo.com.hk] Sent: January-15-09 9:33 PM To: users@tapestry.apache.org Subject: [Spam Rating:3.18] Re: T5 and hibernate slowing with more records Hi James, I do not see any reason why it is slow

Re: T5 and hibernate slowing with more records

2009-01-15 Thread Angelo Chen
e as in the database gets filled for the rows it has > completed but gradually slows to a crawl and at around 2700 records of > 10500 > records it's a record every 15 seconds. > > > > I run the project under eclipse using Tomcat. The memory starts at around > 80mb a

RE: T5 and hibernate slowing with more records

2009-01-15 Thread James Sherwood
. --James -Original Message- From: Szemere Szemere [mailto:szemereszem...@googlemail.com] Sent: January-15-09 6:30 PM To: Tapestry users Subject: Re: T5 and hibernate slowing with more records Feels like a Hibernate question, not Tapestry. Does your table have the right index, do you ne

RE: T5 and hibernate slowing with more records

2009-01-15 Thread James Sherwood
: January-15-09 6:30 PM To: Tapestry users Subject: Re: T5 and hibernate slowing with more records Feels like a Hibernate question, not Tapestry. Does your table have the right index, do you need to have 10k transactions in a single web-request? Szemere

Re: T5 and hibernate slowing with more records

2009-01-15 Thread Szemere Szemere
Feels like a Hibernate question, not Tapestry. Does your table have the right index, do you need to have 10k transactions in a single web-request? Szemere

T5 and hibernate slowing with more records

2009-01-15 Thread James Sherwood
Hello, I am using POI to take an excel file and put it into a Mysql database using hibernate. I put a counter on the records going into the database and it starts off fast but then slows to over 15 seconds a record and I cannot figure out why. My code is basically this: Public class