Hi all.
I'm currently investigating Jackrabbit and am very new to it so please
forgive me if these questions are obvious.
Logically I have a "Contract" that has a bit of meta data (e.g. id) and
maybe a pdf file associated with it.
I set up a TransientRepository and added a node for each "Contract" with a
unique path. I then set a property on this node called id with the
associated string value of the id:
node.setProperty("id", "123")
I have a lot of these (about 200000) and when I do a search on the id using:
"SELECT * FROM [nt:unstructured] WHERE id = '123'
it seems to take longer than I would expect.
1) So my first question is, is there an index on my id property by default?
If not, how do I add an index to it?
If the "Contract" has a pdf file associated with it, at the moment I'm just
adding a BinaryValue to the same node:
node.setProperty("pdfFile", new BinaryValue(pdfInputStream))
2) My next question is, does the pdf file get indexed such that I can search
for text inside it? If not how can I add it in such a way that it does? Once
it has been, what is the SQL2 to query for the string "test"?
Many thanks for help anyone can provide.
Nick.
--
View this message in context:
http://n4.nabble.com/A-couple-of-simple-questions-tp1559067p1559067.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
