RE: Blobs & Delete speed

2009-04-20 Thread Andrew Lawrenson
the table reduced all the delete times to around 15ms. Many thanks! Andy From: Geoff hendrey [mailto:geoff_hend...@yahoo.com] Sent: 20 April 2009 15:38 To: Derby Discussion Subject: Re: Blobs & Delete speed what indexes do you have? I would definitely put an index on id. I

Re: Blobs & Delete speed

2009-04-20 Thread Geoff hendrey
-anonymous From: Andrew Lawrenson To: "derby-user@db.apache.org" Sent: Monday, April 20, 2009 2:53:14 AM Subject: Blobs & Delete speed Hi, I’ve been experiencing a performance problem with deleting blobs in derby, and was wondering if anyone could

Blobs & Delete speed

2009-04-20 Thread Andrew Lawrenson
Hi, I've been experiencing a performance problem with deleting blobs in derby, and was wondering if anyone could offer any advice. This is primarily with 10.4.2.0 under windows and solaris, although I've also tested with the new 10.5.1.1 release candidate (as it has many lob changes), but this