Do you have some sample XQJ API code that I could see Robby?

Regards,

Charles

On 15 Jan 2013, at 15:07, Robby Pelssers <robby.pelss...@nxp.com> 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:rusabaku...@gmail.com] 
> Sent: Tuesday, January 15, 2013 3:16 PM
> To: Robby Pelssers
> Cc: sedna-discussion@lists.sourceforge.net; 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 <robby.pelss...@nxp.com>
> 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:rusabaku...@gmail.com]
> Sent: Tuesday, January 15, 2013 1:49 AM
> To: Robby Pelssers
> Cc: ???? ?????????; sedna-discussion@lists.sourceforge.net
> 
> 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
> Sedna-discussion@lists.sourceforge.net
> 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
> Sedna-discussion@lists.sourceforge.net
> 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
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to