function distinctvalues() is very slow!

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

function distinctvalues() is very slow!

Евгений-8
Hi!



function distinct-values() is VERY slow!!!

For example:

Execute "distinct-values(/classified/subject/car/mark)" about 1000-3000 ms



Where "/classified"  is root of every document of 10000 documents:
                              <classified>
                                    <subject>
                                        <car>
                                            <mark>
                                                Any Mark Name
                                            </mark>
                                         </car>
                                    </subject>
                               </classified>




Evgeny
[hidden email]





-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Exist-open mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/exist-open
Reply | Threaded
Open this post in threaded view
|

RE: function distinctvalues() is very slow!

Chris Marasti-Georg
Depending on the structure of your data, you may want to try distinct-values(//mark), or distinct-values(//mark[parent::car]), or something along those lines.  Getting to the deepest node first and then working back tends to work much faster on my data.  So if mark is only present along the specified path (as a child of car, which is a child of subject, which is a child of classified), //mark is faster than /classified/subject/car/mark.
 

> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]] On Behalf Of ???????
> Sent: Wednesday, September 07, 2005 7:02 AM
> To: [hidden email]
> Subject: [Exist-open] function distinctvalues() is very slow!
>
> Hi!
>
>
>
> function distinct-values() is VERY slow!!!
>
> For example:
>
> Execute "distinct-values(/classified/subject/car/mark)" about
> 1000-3000 ms
>
>
>
> Where "/classified"  is root of every document of 10000 documents:
>                               <classified>
>                                     <subject>
>                                         <car>
>                                             <mark>
>                                                 Any Mark Name
>                                             </mark>
>                                          </car>
>                                     </subject>
>                                </classified>
>
>
>
>
> Evgeny
> [hidden email]
>
>
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference &
> EXPO September 19-22, 2005 * San Francisco, CA * Development
> Lifecycle Practices Agile & Plan-Driven Development *
> Managing Projects & Teams * Testing & QA Security * Process
> Improvement & Measurement * http://www.sqe.com/bsce5sf 
> _______________________________________________
> Exist-open mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/exist-open
>


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Exist-open mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/exist-open