Thanks your reply, it clears some points in my mind. Please give me an advice or guideline:
What should I do if I want to store up to 150000 documents?
I have many different search queries, with some pre-defined nodes in the search filter. Later, the user can modify the search filter (adding searchable nodes or removing searchable nodes), and I must correct the schema to improve the search (adding index, or mapping), and in the future the schema will be changed (some new nodes will appear).
A, I define the schema according to my best knowledge using open-content, but, later I can’t update my schema (unload/undefine/define/load).
B, I define the schema using closed-content, I can update my schema, but I must correct the schema before anybody wants to insert it to the database, and all nodes must appear in the schema.
C, I define the schema using open-content, and I set the document type to ANY storing all documents under this node.
So, what should I do? What is your experience? I think that I make something wrong.
I have tried the A and C with a 31111 database about 25000 documents. I use taminoclient.query, plus a count so the query runs twice (unfortunately, the getTotalCount not reliable).
I experienced that the A (maybe the B too) generated a very good response time, less than 2 sec together.
But the C choice, it generated a very bad response time, the query runs 18-20 secs, but the count takes 222 secs.
thanks in advance,