Do you have some sample XQJ API code that I could see Robby?
Regards,
Charles
On 15 Jan 2013, at 15:07, Robby Pelssers <Rob...@nx...> wrote:
> Thx for the investigation. We indeed use the XQJ API. I guess I will need to check out the packaged Java API.
>
> Robby
>
> From: Konstantin Abakumov [mailto:rus...@gm...]
> Sent: Tuesday, January 15, 2013 3:16 PM
> To: Robby Pelssers
> Cc: sed...@li...; Ivan Shcheklein; Oleg Borisenko
> Subject: Re: [Sedna-discussion] poor performance for large collection
>
> Hi again!
>
> I suggest that you are using Sedna XQJ API, is it right?
>
> I've compared three drivers on your queries:
> 1. Java API
> , packaged with Sedna,
> 2. Sedna XML:DB API
> 3. Sedna XQJ API
> , both from Charles Foster
>
> It took only several seconds to execute queries using 1 and 2, but XQJ API worked about half a minute on each query - seems it can be a bottleneck in your case.
>
>
> 2013/1/15 Robby Pelssers <Rob...@nx...>
> Hi,
>
> We use the driver from Charles Foster. But also a test using the Sedna Database Administrator results in temporarily freezing. It is indeed a remote host.
>
> Robby
>
>
> From: Konstantin Abakumov [mailto:rus...@gm...]
> Sent: Tuesday, January 15, 2013 1:49 AM
> To: Robby Pelssers
> Cc: ???? ?????????; sed...@li...
>
> Subject: Re: [Sedna-discussion] poor performance for large collection
>
> Hello again!
>
> Sorry for the late reply. And thank you for sending us the data!
>
> Both the queries you had profiled in previous letters executed fast on my machine:
> for $i in index-scan("chemicalcontent_id", "", "GE")/@id return string($i)
> and
> for $doc in collection("chemicalContent/released") return document-uri($doc)
>
> it took less than a second to execute each of them. I had executed queries on locally through built-in terminal se_term.
>
> You noticed that:
> Serializing and sending that data over the wire… takes like forever.. >> 1 minute.
>
> Seems that slowdown can be achieved during connection to Sedna and sending query results. Is Sedna server located on remote host? What driver do you use?
>
> --
>
> I've tried some tests on generated data. As expected, the more schema of individual documents differs from each other, the more performance degradation is observed. But in case of similar or not very different documents (which is yours) Sedna performs satisfactory fast. Hope that we will resolve your performance issue.
>
> Best regards,
> Konstantin Abakumov
>
> ------------------------------------------------------------------------------
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> _______________________________________________
> Sedna-discussion mailing list
> Sed...@li...
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
>
>
>
> --
> С уважением,
> Константин Абакумов.
> ------------------------------------------------------------------------------
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512_______________________________________________
> Sedna-discussion mailing list
> Sed...@li...
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
|