We have a collection with 9200 very small and simple documents (data volume in total ~1MB ) like:
Retrieving all documents with the query “input()/person” via Java-Api takes about 6 seconds (only the query time, without reading the result in java) This is too long, when comparing with e.g. SQL Server, storing the data in a relational table, takes only a few milliseconds. We expect much higher data volume.
We guess this is not normal and we missed something, e.g. some parameter settings or inappropriate query??
Any kind of tuning suggestion is welcome.
In Java, we use TDOMObjectModel and TXQuery objects to perform the query.
We use Tamino 220.127.116.11 (from XML Starter Kit) on Windows XP Professional. The Computer is a Pentium 2,8 Ghz, 2GB RAM