[OPEN-ILS-DEV] Indexing problem?
Bill Ott
bott at grpl.org
Mon May 12 13:53:30 EDT 2008
Jason Etheridge said the following on 05/09/2008 05:40 PM:
> On Mon, May 5, 2008 at 11:30 AM, Bill Ott <bott at grpl.org> wrote:
>
>> My test database has 360,000+ bib records, and only about 20,000 holdings
>> attached. When performing a simple keyword search from the staff client I
>> get hundreds or thousands of results in a couple of seconds. If I limit
>> those to items with holdings or those available, in either the staff client
>> or opac, it takes about 60 seconds to receive any results, if it ever
>> finishes.
>>
>
> Hey Bill, did you figure this one out?
>
Turns out it just needed the Dyson treatment (insert Hoover, Oreck,
your favorite vacuum cliche).
I guess I hadn't done a full vacuum after importing all of my data. She
runs like the wind now!
More information about the Open-ils-dev
mailing list