> > Per the suggestion I tried '//*' and it did dramatically > well. For 8000 items, first run took ~4000ms and second run > ~80ms (probably everything is in cache).
You still forgot to either set in your workspace.xml respectDocumentOrder to false, *or* to add an order by clause in your query. From jr 1.5, default respect document order will be false. I am convinced your 4000ms will drop pretty steep. Also, iterating over the 8000 nodes will probably be slower then iterating over a resultset from a database, logically. Ard > > I am afraid I might not be able to use '//*' everytime, the > given example was the simple one, but for each of these type > nodes, I would have nodes which carry other information and > one referring the other. Doing a scan everytime and > filtering out unwanted would be expensive too. > > Can I specify the schema for the tables, with the current > tables with just 2 columns it seems like it won't scale > well(storing hierarchy in 2 columns/flat table) > > Ard your documentation will definitely help. Thanks. > > Are there any benchmarks that I can look at? > > -Sateesh. > > >
