Re: Pagination

2007-07-03 Thread mcmoisei
It looks that we may have different cases. What I do I index my items prior to insert them into the database. When I do a search I get the ids that have the best match and then lookup the items from the database. So far worked just fine. I have 5000 rows of items and I think will still work fi

RE: Pagination

2007-07-03 Thread mcmoisei
I get the ids then I do look the items in the database using select item.* from item where item.id in ( ids ) -- Original message -- From: "Lee Li Bin" <[EMAIL PROTECTED]> > Hi, > > Thanks Mark! > > I do have the same question as Alixandre. How do I get the con

Re: IndexSearcher cache

2007-03-05 Thread mcmoisei
I agree those are benefits when you batch process the indexes once or once in a while. The beauty of AOP is that I can intercept writes and do change the index on the spot. At that point I'd need to let the search know or drop it. If I do that that will face issues on the search side since this

Re: IndexSearcher cache

2007-03-05 Thread mcmoisei
That part is self understood. However as I describe the problem initially - and the use case is a very practical way of dealing with documents in real live - they change, we edit them, I don't want to run a batch re-indexing thing every night... I just wanted done on the spot. One instance Index