MySQL Forums
Forum List  »  MyISAM

Re: Large BLOBs
Posted by: Frank Natoli
Date: June 26, 2006 06:39AM

After posting the full source of the test program, I noticed that method createRow was not explicitly closing two of the prepared statements and one of the result sets. I've modified the source to explicitly close the statements and result set, and am rerunning the test. At row 720 / 1000, it is now taking twenty seconds to insert one row. I don't believe the failure to explicitly close the statements and result set was causing the slowdown.

Options: ReplyQuote


Subject
Views
Written By
Posted
3213
June 25, 2006 09:53AM
1517
June 26, 2006 03:01AM
1923
June 26, 2006 05:42AM
Re: Large BLOBs
1672
June 26, 2006 06:39AM
1614
June 26, 2006 09:17AM
1682
June 27, 2006 08:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.