can you post a sample configuration? I'd like to add this to the dasl wiki page.
Here is my store config:
<store name="mysql">
<parameter name="cache-mode">full</parameter>
<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
<parameter name="driver">com.mysql.jdbc.Driver</parameter>
<parameter name="url">jdbc:mysql://@DB_HOST@:@DB_PORT@/@DB_DB@</parameter>
<parameter name="user">@DB_USER@</parameter>
<parameter name="password">@DB_PW@</parameter>
<parameter name="dbcpPooling">true</parameter>
<parameter name="maxPooledConnections">100</parameter>
<parameter name="isolation">READ_COMMITTED</parameter>
<parameter name="SendStringParametersAsUnicode">false</parameter>
<parameter name="use-rdbms-expression-factory">true</parameter>
</nodestore>
<securitystore><reference store="nodestore"/></securitystore>
<lockstore><reference store="nodestore"/></lockstore>
<revisiondescriptorsstore><reference store="nodestore"/></revisiondescriptorsstore>
<revisiondescriptorstore><reference store="nodestore"/></revisiondescriptorstore>
<contentstore><reference store="nodestore"/></contentstore>
<contentindexer classname="org.apache.slide.index.TextContentIndexer">
<parameter name="indexpath">./index</parameter>
<parameter name="includes">/files/repo/staging</parameter>
<parameter name="analyzer">org.apache.lucene.analysis.de.GermanAnalyzer</parameter>
</contentindexer>
</store>
<scope match="/" store="mysql"/>
BTW, thanks for your great work on Lucene integration. I'll try it out, soon.
Guido
Thanks, Stefan
Guido Casper wrote:
Pontus Strand wrote:
Doing the same search as before on 10000 files yielded a log file of 55 MB.
Each one of the 10000 files generated 18 different select-queries!! 18!!!
There simply must be a better way to do this!
<snip/>
Have you modified the
search queries or search methods? Are there any parameters in Domain.xml or
similar files that can be added and/or modified to increase performance? Any
help at all would be welcome, even if it is just asking "obvious" questions!
Did you put
<parameter name="use-rdbms-expression-factory">true</parameter>
into your nodestore configuration?
Guido
-- Freundliche Grüße / With kind regards Guido Casper
S&N AG Competence Center Open Source Klingenderstr. 5 D 33100 Paderborn
voice +49 5251/1581-87 fax +49 5251/1581-71 eMail [EMAIL PROTECTED] Web http://www.s-und-n.de
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
