cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torsten Curdt <tcu...@dff.st>
Subject Re: big ESQL performance problem - this one's weird
Date Wed, 05 Mar 2003 11:45:53 GMT
Leszek Gawron wrote:
> On śro, mar 05, 2003 at 11:52:42 +0100, Torsten Curdt wrote:
> 
>>>got tired of waiting to finish so it will take at least 5 minutes (last 
>>>time it took 9.9 minutes)
> 
> cannot really tell how much it took - poor wget timed out
> 
>>Could you try the PreparedStatment testcase without 
>>TYPE_SCROLL_INSENSITIVE, CONCUR_READ_ONLY and the Statement testcase 
> 
> PreparedStatement WITHOUT flags works just as fast as the Statement (results
> are similar : 4.7 - 5 seconds in each case)

Hurray :)

...then we can just easily add support for pervasive and you should be 
fine. So we need to create the PervasiveEsqlQuery class and register it 
in the EsqlConnection class. Does pervasive support any kind of 
ResultSet limiting (like LIMIT or TOP)?

> Statement WITH flags works slow as hell.
> 
> So it's strictly connected with ResultSet flags

yepp
--
Torsten


Mime
View raw message