On Jul 29, 2005, at 6:11 AM, Peter Hickman wrote:
[...]
Could it be that your paragraphs are always numbered (with
@number) in document order? If so, then you can leave off the
"order by" clause, as this is probably the main reason for the
query being slow right now.
Problem is that the data is not necessarily in the correct order. I
am thinking of writing an XSLT to reorder the documents before
feeding them into the database.
I tested a version of the query without the order by clause and the
saving was 6 ms (yes milliseconds).
However changing from
createContainer books.dbxml d novalidate
to
createContainer books.dbxml in novalidate
has reduced the query time by an order or magnitude, and the
removal of the order by clause has saved another 37 ms.
Using a node storage container is almost always better for query speed,
regardless of document size, and has a major effect (as you have seen)
on large documents.
Node storage is the default type for the API methods that create
containers,
but is is *not* the default type for the dbxml shell program. We are
considering
changing that.
Regards,
George
------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe-E1rGyZxLSgzby3iVrkZq2A@xxxxxxxxxxxxxxxx
|
