cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: query_governor_cost_limit setting not working with cayenne?
Date Sat, 20 Dec 2008 08:32:33 GMT
Actually I think I already have sufficient information to try it out.  
Still information about Cayenne version may be important.

Andrus

On Dec 20, 2008, at 10:22 AM, Andrus Adamchik wrote:

> Hi Kathy,
>
> Which version of Cayenne is that? Also do you have a working JDBC  
> example - maybe I can try to reproduce it and compare to Cayenne.
>
> Andrus
>
>
> On Dec 20, 2008, at 1:08 AM, KathyS wrote:
>
>>
>> Hello,
>>
>> I'm retrofitting an existing project to use Cayenne back end. We  
>> use SQL
>> Server, and we need to be able in certain cases to prevent long  
>> running
>> queries from starting. SQL Server does that by using
>> query_governor_cost_limit setting and comparing it with time  
>> estimation
>> prior to running the query. And it works with plain JDBC -  
>> executing in the
>> same connection "SET query_governor_cost_limit x" and the long  
>> running
>> select query results in the query being canceled. But it doesn't  
>> work with
>> Cayenne for some reason. I made a query chain, and added the  
>> governor as the
>> first query, then long running select. It all gets executed, which  
>> - in this
>> case - is a big problem! Log is shown below. I'd appreciate advice.  
>> Is
>> cayenne re-setting connection between queries in a chain? Is there  
>> any funky
>> stuff going with PreparedStatement?
>>
>> INFO  QueryLogger: SET query_governor_cost_limit 2
>> INFO  QueryLogger: SELECT ...
>> INFO  QueryLogger: === returned 2700 rows. - took 15594 ms.
>>
>> Thanks!!
>> Kathy
>> -- 
>> View this message in context: http://www.nabble.com/query_governor_cost_limit-setting-not-working-with-cayenne--tp21099002p21099002.html
>> Sent from the Cayenne - User mailing list archive at Nabble.com.
>>
>>
>
>


Mime
View raw message