[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsqldb-user
Subject:    Re: [Hsqldb-user] HSQLDB-Slow queries
From:       iceDice <nmilasinovic () gmail ! com>
Date:       2011-05-17 8:04:34
Message-ID: 31635686.post () talk ! nabble ! com
[Download RAW message or body]


Hello,

I checked and new hsqldb version 2.2.1 fixes this issue.

Best regards.


iceDice wrote:
> 
> Hello Fred,
> 
> I tried to submit query and database file via bug trucker on SourceForge
> but 
> my database file are about 8Mb zipped.
> 
> This query is much slower with version 2.2 in contrast to 2.0:
> 
> SELECT DISTINCT DocumentScope.ID Scope, DocumentScope.Title ScopeLabel,
> ActType.ID , ActType.Title IDLabel, DocumentScope.Sort, ActType.Sort FROM
> Document  JOIN ActVersion ON (ActVersion.DocumentID=Document.ID) LEFT JOIN
> Act ON (Act.ID=ActVersion.ActID) LEFT JOIN ActType ON
> (Act.ActTypeID=ActType.ID) LEFT JOIN DocumentScope ON
> (Document.DocumentScopeID=DocumentScope.ID) WHERE Document.ColumnID=3 AND
> (ActVersion.VersionEndDate > CURDATE( ) OR ActVersion.VersionEndDate IS
> NULL OR ActVersion.VersionEndDate=\'0001-01-01\') ORDER BY
> DocumentScope.Sort, ActType.Sort;
> 
> Problem is in clause ActVersion.VersionEndDate IS NULL.
> 
> Database files are in attachment.
> 
> iceDice wrote:
>> 
>> Hello,
>> 
>> I am trying to move from hsql 2.0 to hsql 2.2 but i have noticed that 
>> many queries in my application are significantly slower now when i use
>> version 2.2.
>> 
>> For example when i have clause some_column IS NULL (in WHERE), query is
>> much slower then in version 
>> 2.0.
>> 
>> Any ideas how to reconstruct queries and why this happens.
>> 
>> Best regards.
>> 
>> 
> 
> 

-- 
View this message in context: http://old.nabble.com/HSQLDB-Slow-queries-tp31627631p31635686.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]