Re: [MonetDB-users] MonetDB XML - slow execution of query, with test on attribute

Hi Jan, thank you for your response. I thought that all documents within a collection are stored within one (or several) relational tables? I am not sure, if merging all documents into one big document is an option. The documents are supposed to be updateable ... does that give a good performance for one large document? Patrick

Message: 7 Date: Tue, 15 Jun 2010 21:58:44 +0200 From: Jan Rittinger Subject: Re: [MonetDB-users] MonetDB XML - slow execution of query with test on attribute To: Communication channel for MonetDB users Message-ID: <702CE627-774E-47C5-B3B7-34A5431F20CF@uni-tuebingen.de> Content-Type: text/plain; charset="windows-1252"

Hi Patrick,

the evaluation plan of your query looks quite bad -- with respect to what could be possible...

If you could use 'doc("tu")' (with a single big document containing all small documents), you would get the result in *no* time, as then the attribute index is used. Unfortunately I'm not aware of the difference in the attribute index with respect to collections...

Regards, Jan