AW: locking problem when selecting data

2007-06-11 Thread Kasper, Kay
Hi Stanley, over the weekend i produced a test case (see the attachement). During my tests I found out, that the not executed commit/rollback of the update statement seems to be a solution for my special situation. An other solution seems to be to change the lock level to read uncommitted for the

Unusual network utilisation

2007-06-11 Thread Daniel Noll
Hi all. Has anyone seen a situation where when trying to retrieve a blob, network usage jumps to >90% for a long period of time? The client is just doing a simple query and then copying the blob into a file (a chunk at a time) and it sounds like it's taking too long for copying a 10MB blob. I

Re: Unusual network utilisation

2007-06-11 Thread V . Narayanan
Daniel Noll wrote: Hi all. Has anyone seen a situation where when trying to retrieve a blob, network usage jumps to >90% for a long period of time? The client is just doing a simple query and then copying the blob into a file (a chunk at a time) and it sounds like it's taking too long for c

Re: Unusual network utilisation

2007-06-11 Thread Daniel Noll
On Tuesday 12 June 2007 11:59:11 [EMAIL PROTECTED] wrote: > Hi Daniel, > > Can you pls mention the Derby version you are using ? It appears to be 10.2.2.0. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/

Re: Unusual network utilisation

2007-06-11 Thread V . Narayanan
Daniel Noll wrote: On Tuesday 12 June 2007 11:59:11 [EMAIL PROTECTED] wrote: Hi Daniel, Can you pls mention the Derby version you are using ? It appears to be 10.2.2.0. Daniel Hi Daniel, There have been issues reported with CLOB performance on linux systems with 10.2.2.0. P