I'm a great fan of not changing working code for a "might be better sometime in the far future if lots of things change" <G>...
Erick On Mon, Dec 8, 2008 at 10:54 AM, Donna L Gresh <[EMAIL PROTECTED]> wrote: > Erick- > Thanks for the pointer; in my app the difference is between 30 > milliseconds and 45 milliseconds (and this is a once-a-day kind of thing), > but hey it's always worth doing something the better way in case my index > ever gets a whole lot bigger or the use case changes-- thanks. > > Donna L. Gresh > Business Analytics and Mathematical Sciences > IBM T.J. Watson Research Center > (914) 945-2472 > http://www.research.ibm.com/people/g/donnagresh > [EMAIL PROTECTED] > > > "Erick Erickson" <[EMAIL PROTECTED]> wrote on 12/08/2008 09:28:16 > AM: > > > is empid indexed? If it is this should run *much* faster if you used > > TermEnum/TermDocs to fetch all the empids...... > > > > FWIW > > Erick >