I am using Marklogic 8 and using the Java API to retrieve and store documents.
All my documents store (JSON files) are at the maximum of 2Kb file size.
I have two questions:
Indexes are set on most of the JSON nodes by which am querying.
The search will by default include a range of timestamp (in long) i.e., an inclusive search of to and from timestamps. Plus any any other node as requested by the end user.
The code uses QBE approach to query the database.
Question 1: Is there a better approach like String Query Definition search, Key-Value Search, Structured Query Definition or Combined Query search that has better performance than Query By Example
Question 2: Will the machine it is running on have an impact on the performance?
Am now working on my local Windows machine but eventually the Marklogic will be hosted on a UNIX machine in production.
Am not sure of the specs though for the Unix machine.