cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From KathyS <scarletka...@yahoo.com>
Subject Re: query_governor_cost_limit setting not working with cayenne?
Date Sat, 20 Dec 2008 15:00:04 GMT

Prepared vs plain statement may change execution plan for the governor query
itself, but as long as it runs, and I verified it runs by watching sql
server trace, it should "work". I was more concerned seeing sp_prepare /
sp_unprepare surrounding each query, even inside of the chain.


Andrus Adamchik wrote:
> 
> 
> On Dec 20, 2008, at 4:48 PM, KathyS wrote:
> 
>> JDBC code is straightforward:
>> Statement   stmnt = con.createStatement();
>> stmnt.execute("SET query_governor_cost_limit 2");
> 
> The only difference with Cayenne internal execution path would be that  
> Cayenne will use PreparedStatement here. Anyways, I need to try it I  
> guess...
> 
> Andrus
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/query_governor_cost_limit-setting-not-working-with-cayenne--tp21099002p21105729.html
Sent from the Cayenne - User mailing list archive at Nabble.com.


Mime
View raw message