You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Manjula Kutty <ma...@gmail.com> on 2007/07/09 22:17:37 UTC

Optimization test result

Hi,

I had run the optimization test and am attaching the report with 10.3 beta.
Looks like 10.3 performs better than 10.2 in query optimization. Please have
a look

-- 
Thanks,
Manjula.

Re: Optimization test result

Posted by Francois Orsini <fr...@gmail.com>.

Great. Seems to be in line with performance improvements reported by Olav
previously (especially on read-only operations):
http://www.nabble.com/10.3.1.0-beta-performance-tf4016873.html#a11410816

On 7/9/07, Manjula Kutty <ma...@gmail.com> wrote:
>
> Hi,
>
> I had run the optimization test and am attaching the report with 10.3beta. Looks like
> 10.3 performs better than 10.2 in query optimization. Please have a look
>
> --
> Thanks,
> Manjula.
>
>

Re: Optimization test result

Posted by Julius Stroffek <Ju...@Sun.COM>.

Thanks Manjula. I'll look at that.

Julo

Manjula Kutty wrote:
> Hi Julius,
>  
> yes, the code is already in the derby codeline. It is under 
> derbyTesting/system/optimizer. There is a reaadme file in that 
> directory which will help you on how to run the test and details of 
> the test. Please let me know if you have any questions
>  
> Thanks
> Manjula
>
>  
> On 7/10/07, *Julius Stroffek* <Julius.Stroffek@sun.com 
> <ma...@sun.com>> wrote:
>
>     Hi Manjula,
>
>     looks interesting. How have you produced those results? Is that
>     optimizer test already part of derby or attached somewhere in
>     JIRA? If not, can you share that code? I would like to do some
>     experiments with optimizer and this might help me a lot.
>
>     Thanks
>     optimizer
>     Julo
>
>     Manjula Kutty wrote:
>>     Hi,
>>      
>>     I had run the optimization test and am attaching the report with
>>     10.3 beta. Looks like 10.3 performs better than 10.2 in query
>>     optimization. Please have a look
>>
>>     -- 
>>     Thanks,
>>     Manjula.
>
>
>
>
> -- 
> Thanks,
> Manjula.

Re: Optimization test result

Posted by Manjula Kutty <ma...@gmail.com>.

Hi Julius,

yes, the code is already in the derby codeline. It is under
derbyTesting/system/optimizer. There is a reaadme file in that directory
which will help you on how to run the test and details of the test. Please
let me know if you have any questions

Thanks
Manjula


On 7/10/07, Julius Stroffek <Ju...@sun.com> wrote:
>
> Hi Manjula,
>
> looks interesting. How have you produced those results? Is that optimizer
> test already part of derby or attached somewhere in JIRA? If not, can you
> share that code? I would like to do some experiments with optimizer and this
> might help me a lot.
>
> Thanks
> optimizer
> Julo
>
> Manjula Kutty wrote:
>
> Hi,
>
> I had run the optimization test and am attaching the report with 10.3beta. Looks like
> 10.3 performs better than 10.2 in query optimization. Please have a look
>
> --
> Thanks,
> Manjula.
>
>


-- 
Thanks,
Manjula.

Re: Optimization test result

Posted by Julius Stroffek <Ju...@Sun.COM>.

Hi Manjula,

looks interesting. How have you produced those results? Is that 
optimizer test already part of derby or attached somewhere in JIRA? If 
not, can you share that code? I would like to do some experiments with 
optimizer and this might help me a lot.

Thanks

Julo

Manjula Kutty wrote:
> Hi,
>  
> I had run the optimization test and am attaching the report with 10.3 
> beta. Looks like 10.3 performs better than 10.2 in query optimization. 
> Please have a look
>
> -- 
> Thanks,
> Manjula.