[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