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: 1) which version of MonetDB XQuery are you using? 2) what exactly does "crash" mean? does the Mserver simply stop? Is the any error message? Does Mserver grow/excessively use resources before crashing? ...? 3) what does "large" and "small" mean wrt., your document sizes? (serialized file size in byte? number of /collection/doc nodes in either document? ...?) 4) how much memory does your machine have? > (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. 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:[EMAIL PROTECTED] | | 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 | ------------------------------------------------------------------------- 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