Re: BLOB performence
What version of Derby are you using? There was a recent fix in the area of clob's but I am not aware of a problem with blob's. What does your insert look like, ie. does it use streams to insert the blob value and does it use prepared statements. Seems like a simple example, can you post your test program? What size are your rows without the blob vs. with the blob? Rajes Akkineni wrote: > Hi, > Have any one tried using BLOBs with derby? > I tried it...tried to insert 1000 64kb blobs...unfortunaly it took all > my memory and gave OutofMemoryException. > It used all the heep. > > When i tried to place 1000 64kb blobs it took more then 120 sec. > But when i removed the blob i can execute 9,00,00,000 inserts in just 3 > sec. > > Why BLOB is so slow??? > Am i used it incorrectly? > Have any one gort similar experiance? > > Thanks > Rajesh > >
Re: BLOB performence
Hi, Actually i didn't perform these tests outside my main development code(Eclipse Plugin). Just now i am trying to do that tests again in a standalone program. My system is just AMD1700+,512 MB RAM,jdk1.5. there is much difference in 4gb RAM and 512MB. Anyway I will let u know about my test results again. Thanks Rajesh On Thu, 25 Aug 2005 12:20:40 +0530, Sunitha Kambhampati <[EMAIL PROTECTED]> wrote: Rajes Akkineni wrote: When i tried to place 1000 64kb blobs it took more then 120 sec. But when i removed the blob i can execute 9,00,00,000 inserts in just 3 sec. The 90 million number seems really high to me, could it be possible that your test may not be actually performing inserts ..? what row size are you inserting here.. It is always a good idea to include machine configuration, jvm used when giving out numbers. On one of my test machines ( win2k, 2cpu -intel xeon, 2.4ghz, 4gb ram, with disk cache) , jdk1.5 - similar test as you describe for blob inserts is approximately five times faster than what you report. Sunitha. -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Re: BLOB performence
Rajes Akkineni wrote: When i tried to place 1000 64kb blobs it took more then 120 sec. But when i removed the blob i can execute 9,00,00,000 inserts in just 3 sec. The 90 million number seems really high to me, could it be possible that your test may not be actually performing inserts ..? what row size are you inserting here.. It is always a good idea to include machine configuration, jvm used when giving out numbers. On one of my test machines ( win2k, 2cpu -intel xeon, 2.4ghz, 4gb ram, with disk cache) , jdk1.5 - similar test as you describe for blob inserts is approximately five times faster than what you report. Sunitha.
Re: BLOB performence
Rajes Akkineni wrote: Hi, Have any one tried using BLOBs with derby? I tried it...tried to insert 1000 64kb blobs...unfortunaly it took all my memory and gave OutofMemoryException. It used all the heep. I could successfully insert 1000 rows of 64kb blobs, with jdk1.5 with default jvm heap size.what jvm heap size settings are you using ? If possible, can you post your program that reproduces the error. Thanks, Sunitha.
