29 Mar
2011
29 Mar
'11
12:58 p.m.
Hello Dimitar,
sure: I'm using version 6.6.
Query: //*[randnr] Compiling: - optimizing descendant-or-self step(s) Result: root()/descendant::*[randnr] Timing: - Parsing: 0.3 ms - Compiling: 0.1 ms - Evaluating: 6730.8 ms - Printing: 73.88 ms - Total Time: 6805.09 ms Query plan: <IterPath> <Root/> <IterStep axis="descendant" test="*"> <AxisPath> <IterStep axis="child" test="randnr"/> </AxisPath> </IterStep> </IterPath>
For "dinstinct-values(//*[randnr]/name())" there is no execution plan generated until BaseX crashes or the "out of main memory"-error.
Greetings, Rupert Jung
--
Rupert Jung
<pagina> GmbH
Gesamtherstellung wissenschaftlicher Werke
Herrenberger Str. 51
D-72070 Tübingen
Handelsregister Stuttgart HRB 380249
Geschäftsführer: Tobias Ott
E-Mail: rupert.jung@pagina-tuebingen.de
Phone: (0 70 71) 98 76-37
Fax: (0 70 71) 98 76-22
http://www.pagina-online.de
-----Ursprüngliche Nachricht-----
Von: Dimitar Popov [mailto:Dimitar.Popov@uni-konstanz.de]
Gesendet: Dienstag, 29. März 2011 18:41
An: basex-talk@mailman.uni-konstanz.de; rupert.jung@pagina-tuebingen.de
Cc: 'Andreas Weiler'; bjoern.duenckel@pagina-tuebingen.de
Betreff: Re: [basex-talk] Out of memory
Hi Rupert,
could you post the execution plans of the two queries? And also the version
of
BaseX that you use.
Best regards,
Dimitar
Am Dienstag 29 März 2011, 17:31:26 schrieb Rupert jung:
> Hi Andreas and thanks for your answer,
>
>
>
> unfortunely that didnt work (java.exe consumed 1.2 GB, then stopped). The
> expected result should not be longer then about 10 element names or so...
>
>
>
> Maybe this could be a bug in basex itself
?
>
>
>
>
>
> _____
>
> Rupert Jung
>
> <pagina> GmbH
> Gesamtherstellung wissenschaftlicher Werke
> Herrenberger Str. 51
> D-72070 Tübingen
>
> Handelsregister Stuttgart HRB 380249
> Geschäftsführer: Tobias Ott
>
> Phone: (0 70 71) 98 76-37
> Fax: (0 70 71) 98 76-22
> E-Mail: rupert.jung@pagina-tuebingen.de
> http://www.pagina-online.de http://www.pagina-online.de/
>
>
>
> Von: Andreas Weiler [mailto:andreas.weiler@uni-konstanz.de]
> Gesendet: Dienstag, 29. März 2011 16:25
> An: rupert.jung@pagina-tuebingen.de
> Cc: basex-talk@mailman.uni-konstanz.de;
bjoern.duenckel@pagina-tuebingen.de
> Betreff: Re: [basex-talk] Out of memory
>
>
>
> Hi,
>
>
>
> as first hint you could start BaseX with the Xmx flag of Java:
>
>
>
> java -cp BaseX.jar -Xmx1G org.basex.BaseXGUI
>
>
>
> Probably that will solve this issue.
>
>
>
> Kind regards,
>
> Andreas
>
>
>
> Am 29.03.2011 um 16:14 schrieb Rupert jung:
>
>
>
>
>
> Hi there,
>
>
>
> Im currently doing some tests with BaseX and a mid-sized database (around
> 2 GB).
>
>
>
> I wonder myself why Im not able to process this xquery-statement:
>
>
>
> dinstinct-values(//*[randnr]/name())
>
> (Give me a list of all elements which have a child-element <randnr> and
> remove all double entries)
>
>
>
> After about 10 seconds a got a out of main memory error. Whats really
> strange about this: Processing the nodes itself with //*[randnr]/
>
> works like a charm (but gives me a HUGE amount of text and is not really
> useful for me at all).
>
>
>
> My system: win7-x64, 4 GB RAM, Java 1.6.0_21
>
>
>
> Thank you in advance,
>
> Rupert Jung
>
>
>
> _____
>
> Rupert Jung
>
> <pagina> GmbH
> Gesamtherstellung wissenschaftlicher Werke
> Herrenberger Str. 51
> D-72070 Tübingen
>
> Handelsregister Stuttgart HRB 380249
> Geschäftsführer: Tobias Ott
>
> Phone: (0 70 71) 98 76-37
> Fax: (0 70 71) 98 76-22
> E-Mail: rupert.jung@pagina-tuebingen.de
> http://www.pagina-online.de http://www.pagina-online.de/
>
>
>
> _______________________________________________
> BaseX-Talk mailing list
> BaseX-Talk@mailman.uni-konstanz.de
> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk