Re: sort by uniq fields

2008-03-17 Thread Yonik Seeley
The first time sort on a particular field is normally slow. Subsequent sorts on the same field should be just as fast. -Yonik On Mon, Mar 17, 2008 at 4:42 PM, Jae Joo <[EMAIL PROTECTED]> wrote: > I have 30 millions document indexed and tried sort by "sequenceid" which is > unique over the docume

sort by uniq fields

2008-03-17 Thread Jae Joo
I have 30 millions document indexed and tried sort by "sequenceid" which is unique over the document. I am experiencing "very slow" than sort by pub_date. sequenceid is not defined as "unique key" in the schema.xml and there is the "unique key" defined in schema.xml - item_id. Anyone knows why? T