Hi,
Which version of Sequoia are you using exactly?
3.0-beta2
2007-05-02 15:32:53,160 DEBUG
virtualdatabase.VirtualDatabaseWorkerThread.mydb statementExecute command
2007-05-02 15:32:53,163 DEBUG sequoia.controller.RequestManager
Processing macros in request 57 (select count(*) from
POOL_COLLECTION_DATA_21/)
2007-05-02 15:32:53,163 DEBUG sequoia.controller.RequestManager Macros
processed in request 57, new request is: select count(*) from
POOL_COLLECTION_DATA_21/
2007-05-02 15:32:53,164 DEBUG controller.RequestManager.mydb
Broadcasting request select count(*) from POOL_COLLECTION_DAT... to
all controllers (Member(address=/128.141.128.146:44997,
uid=128.141.128.146:44997)->[Member(address=/128.141.128.146:44997,
uid=128.141.128.146:44997)])
Your application uses Statement.execute("select ...") instead of
Statement.executeQuery("select ...").
The controller tries to check the content of the SQL statement to see if
it is a plain SELECT and then tries to optimize it to execute it on a
single backend. For some reason (that I don't explain yet), the
statement is not detected as a plain SELECT statement and thus it is
broadcast (because of Statement.execute()).
And it doesn't use cache for the same reason ?
One solution is to use executeQuery() instead execute().
I have no control over executeQuery()/execute() choice (it's not
my code). Is there anything else I could do (maybe ob the Sequoia side) ?
Julius
--
########################################################################
# E-mail: [EMAIL PROTECTED] #
# WWW: http://cern.ch/hrivnac #
# My Space: http://www.myspace.com/juliushrivnac #
# Lide.cz: http://www.lide.cz/Julius.Hrivnac #
# S-mail: LAL, BP 34, F - 91898 Orsay cedex, France #
# phone: (F)-(0)1-64-46-82-51; private: (F)-(0)8-71-19-31-70 #
# mobil: (F)-622-741-151; (CZ)-607-918-415 #
# ICQ: 10804323 #
# AIM: jhrivnac #
# Skype: jhrivnac #
# Jabber: JuliusHrivnac #
########################################################################
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
