Re: Derby Performance Problem

2006-04-11 Thread Prasenjit Sarkar
rtha <[EMAIL PROTECTED] om> To Derby Discussion 04/10/2006 06:41 PM cc Subject Please respond to Re: Derby Performance P

Re: Derby Performance Problem

2006-04-11 Thread Satheesh Bandaram
cc Subject Please respond to Re: Derby Performance Problem "Derby

Re: Derby Performance Problem

2006-04-11 Thread Sunitha Kambhampati
Prasenjit Sarkar wrote: The statistics obtained do not shed much light on this issue. I'm fairly new to Derby and would like some direction on how to proceed. In case you have not tried, it might be useful to see what query plan Derby is choosing by setting the debug property derby.lang

Re: Derby Performance Problem

2006-04-11 Thread Prasenjit Sarkar
cc Subject Please respond to Re: Derby Performance Problem "Derby Discussion"

Re: Derby Performance Problem

2006-04-11 Thread Prasenjit Sarkar
PM cc Subject Please respond to Re: Derby Performa

Re: Derby Performance Problem

2006-04-10 Thread Rajesh Kartha
Hi, I am wondering if it is related to the issue - http://issues.apache.org/jira/browse/DERBY-649 If you have an older version (than 10.1.2.3), is it possible to re-run you scenario using the newer snapshot jars posted at: http://db.apache.org/derby/derby_downloads.html#Snapshot+Jars Pleas

Derby Performance Problem

2006-04-10 Thread Prasenjit Sarkar
Hi, We are porting a commercial application from DB2 to Derby and have run into a performance issue. Our application has a very complex data model and uses four levels of views for some reports. We are facing a performance problem in joining views at the second level. To illustrate an example, VI