FAQ
Anyone have any ballpark stats about sorting a single field versus sorting
multiple fields? I understand every implementation is different, but I'm
just trying to get a sense of what to expect before I revamp my index.

We need fairly fine-grained sorting of items, so I have a field with the
date indexed in the following format:

YYYYMMDDHHmm

This is too big for an int, so I sort it as a string. I am debating storing
two integer fields like so:

FIELD #1: YYYYMMDD
FIELD #2: HHmm

And then sorting on field #1 and field #2. The advantage is that I'm moving
from a string sort to an int sort; the disadvantage is I'm sorting on two
fields instead of one. The index is about 30 million rows, and performance
is key. Anyone have any performane numbers or implementation tips?

Thanks!
Monsur



---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupjava-user @
categorieslucene
postedNov 17, '05 at 5:02p
activeNov 17, '05 at 5:02p
posts1
users1
websitelucene.apache.org

1 user in discussion

Monsur Hossain: 1 post

People

Translate

site design / logo © 2022 Grokbase