On Wed, Feb 08, 2012 at 10:33:21AM -0500, Dan Scott wrote: > On Wed, Feb 8, 2012 at 10:07 AM, Mary Llewellyn <[email protected]> wrote: > > Hi Janet, > > > > Yes, the loader is slow and not very robust in terms of how big a bib file > > you can load through Vandelay. I tried a big file yesterday, and it choked > > at the 1000 record mark. When we got things started again, the queue was > > empty. > > Well, there's slow and then there's slow. 5-10 minutes to process 6 > records is insanely slow. > > I strongly suspect there are indexes missing on the CWMARS database. > What version of Evergreen is CWMARS running?
This got me thinking, too. I tried a test on my system (4-core/4G) and was able to load and import 1000 (smallish) records in 7 minutes into a database with minimal data in Evergreen 2.2. Granted, these are ideal conditions, but, as Dan suggested, the difference in speed should not be that big. -b -- Bill Erickson | Senior Software Developer | phone: 877-OPEN-ILS (673-6457) | email: [email protected] | web: http://esilibrary.com | Equinox Software, Inc. / Your Library's Guide to Open Source
