Thanks for the quick answer!
I am not quite sure whether or not that will help me though. The relation
between the files and the db entries is 1:1, so I am only expecting one
result set for each call, that cannot be cached as the key (the filename)
differs.. I will try to implement it anyway
What I don't quite understand is, why the count of db-calls increases with
the number of docs Solr indexed. I added the verbose output from the 4th doc
below. Not only the db-calls sum to 4, but also the XPathEntity-calls..
thanks again!
arne
--
"document#4",
[
null,
"----------- row #1-------------",
"fileSize",
3341,
"fileLastModified",
"2013-02-13T10:29:04Z",
"fileAbsolutePath",
"c:\\Reports\\report-1358168401817.xml",
"fileDir",
"c:\\Reports",
"file",
"report-1358168401817.xml",
null,
"---------------------------------------------",
"entity:xml-data",
[
"query",
"c:\\Reports\\report-1358168401817.xml",
"query",
"c:\\Reports\\report-1358168401817.xml",
"query",
"c:\\Reports\\report-1358168401817.xml",
"query",
"c:\\Reports\\report-1358168401817.xml",
"time-taken",
"0:0:0.0",
"time-taken",
"0:0:0.0",
"time-taken",
"0:0:0.0",
"time-taken",
"0:0:0.0",
null,
"----------- row #1-------------",
"paniclog",
"",
"$forEach",
"/Feedback",
"crashlog",
"\ntext\n",
null,
"---------------------------------------------"
],
"entity:db-data",
[
"query",
" SELECT id, b FROM a_table WHERE id = 'report-1358168401817.xml'",
"query",
" SELECT id, b FROM a_table WHERE id = 'report-1358168401817.xml'",
"query",
" SELECT id, b FROM a_table WHERE id = 'report-1358168401817.xml'",
"query",
" SELECT id, b FROM a_table WHERE id = 'report-1358168401817.xml'",
"time-taken",
"0:0:0.297",
"time-taken",
"0:0:0.297",
"time-taken",
"0:0:0.297",
"time-taken",
"0:0:0.297",
null,
"----------- row #1-------------",
"ID",
"report-1358168401817.xml",
"B",
"some data",
"---------------------------------------------",
null,
]
],
--
View this message in context:
http://lucene.472066.n3.nabble.com/solr-dih-does-multiple-queries-for-sub-entities-tp4044522p4044552.html
Sent from the Solr - User mailing list archive at Nabble.com.
