I have loaded a few thousand pieces of content in the form of xml files and resource bundles. I am using chemistry to retrieve the content. I try running a single threaded performance test to see the response times. For query by path response times are ~500ms and for select * from cmis:document where cmis:name='' the response times are multisecond.
I am running on windows with a default installation. I wasn't expecting miracles but was expecting much better.
Does anyone know what I should expect? For a better benchmark what would be a reasonable configuration?