-----Original Message----- From: Stefan Manegold [mailto:Stefan.Manegold@cwi.nl] Sent: 24 May 2007 18:00 To: M.Clements@cwi.nl Cc: monetdb-users@lists.sourceforge.net Subject: Re: [MonetDB-users] MonetDb-XQuery problem
On Thu, May 24, 2007 at 05:07:03PM +0200, Maarten Clements wrote:
Using the following XQuery in MonetDb (WinXP) crashes on large documents
the usual questions:
- which version of MonetDB XQuery are you using?
The latest, from sjoerd's directory
- what exactly does "crash" mean?
does the Mserver simply stop? Is the any error message? Does Mserver grow/excessively use resources before crashing? ...?
It fills up my memory and after doing that Mserver stops.
- what does "large" and "small" mean wrt., your document sizes?
(serialized file size in byte? number of /collection/doc nodes in either document? ...?)
The problem occurs with C1 = 59Mb, C2 = 7Kb (but I didn't search for the critical sizes:) Both files contain movie data: C1 is IMDB data with nodes: title,year,tag1,tag2...tagx (im not sure how many movies) C2 is Netflix data with nodes: title, year (100 movies)
- how much memory does your machine have?
1 Gb
(when C1 and C2 are small it works ok):
<col> { for $b in doc("C1.xml")/collection/doc for $top in doc("C2.xml")/collection/doc where ($b/year > 1950) and ($b/title = $top/title) return <movie> {$b/year} </movie> } </col>
If I remove one of the two conditions it works perfectly, e.g.:
<col> { for $b in doc("C1.xml")/collection/doc for $top in doc("C2.xml")/collection/doc where ($b/title = $top/title) return <movie> {$b/year} </movie> } </col>
Can anyone explain this problem?
most probably, the more complex join condition is not recognized as join, then the intermediate result (corss product) blows up.
It is very likely that this is indeed the problem... Why does this happen for a query this simple?
Stefan
Maarten Clements
--- This SF.net email is sponsored by DB2 Express Download
DB2 Express
C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | CWI, P.O.Box | 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |