Re: [OPEN-ILS-GENERAL] Do you trim database tables?

2014-03-27 Thread Tim Spindler
Martha, Not that I have anything to add but I would like to know what are some good practices also. We also have similar issues where tables are getting quite large. Tim On Thu, Mar 27, 2014 at 9:33 AM, Martha Driscoll drisc...@noblenet.orgwrote: We have been on Evergreen for nearly 2

Re: [OPEN-ILS-GENERAL] Do you trim database tables?

2014-03-27 Thread Mike Rylander
Martha, Other than storage, the auditor tables won't impact performance -- they are insert-only in practice. What process are you using for loading patrons? If you're using the staging tables, it may just be a matter of creating some indexes. On Thu, Mar 27, 2014 at 9:40 AM, Rogan Hamby

Re: [OPEN-ILS-GENERAL] Do you trim database tables?

2014-03-27 Thread Jason Stephenson
We age circulations after 7 days. Not all circs get aged at that time since patron settings to keep circulation history can affect that, as does the setting to keep previous circulations on copies. (We keep 2.) We do delete data from the auditor tables. We keep 1 year for most tables, but for the

Re: [OPEN-ILS-GENERAL] Do you trim database tables?

2014-03-27 Thread Martha Driscoll
I am using staging tables to load the patron records. Once they are in staging, I update the staging records with the actor.usr.id and then run a bunch of update statements for name, address, phone, etc. Those records not already in the database are added as new. This has worked fine but

[OPEN-ILS-GENERAL] Holdings Export

2014-03-27 Thread Tim Spindler
I was wondering if there is a limit to the number of holdings that can be exported using the function in vandelay? -- Tim Spindler tjspind...@gmail.com *P** Go Green - **Save a tree! Please don't print this e-mail unless it's really necessary.*

Re: [OPEN-ILS-GENERAL] Do you trim database tables?

2014-03-27 Thread Bill Ott
On 03/27/2014 09:33 AM, Martha Driscoll wrote: We have been on Evergreen for nearly 2 years. Recently it has been taking significantly longer to load patron records than it used to. We load files just about weekly for our college libraries and the files contain thousands of records. I

Re: [OPEN-ILS-GENERAL] Do you trim database tables?

2014-03-27 Thread Tim Spindler
Mike, I haven't checked the quantity or compared it to our entire database size but we probably have a lot deleted bibs and copies in the database just do to normal workflows. Is there ever an advantage in wiping those from the database (not just changing the deleted flag)? I know this would

[OPEN-ILS-GENERAL] TODAY: IRC practice time on Thursday, March 27 at 2PM - new presentation link

2014-03-27 Thread Yamil Suarez
Hello, Last week at the 2014 Evergreen conference I gave a lightning talk presentation on how easy is to get started with using the Evergreen IRC. Which is used by the community to collaborate and answer each others questions. Here is a longer version of the presentation with more

Re: [OPEN-ILS-GENERAL] TODAY: IRC practice time on Thursday, March 27 at 2PM - new presentation link

2014-03-27 Thread Amy Terlaga
This will be an hour long session for newcomers to practice using IRC to be held on TODAY Thursday, March 27 at 2PM. This will be a designated practice time, so no one feels like they are interrupting others. I will be there, Yamil! Will cocktails be served at this event? No matter - wouldn't

Re: [OPEN-ILS-GENERAL] TODAY: IRC practice time on Thursday, March 27 at 2PM - new presentation link

2014-03-27 Thread McCanna, Terran
I will be there, too! Thanks so much, Yamil! Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org - Original Message - From: Amy Terlaga terl...@biblio.org To: Evergreen

Re: [OPEN-ILS-GENERAL] TODAY: IRC practice time on Thursday, March 27 at 2PM - new presentation link

2014-03-27 Thread Hardy, Elaine
I plan on being there as well Elaine J. Elaine Hardy PINES Collaborative Projects Manager Georgia Public Library Service 1800 Century Place, Ste 150 Atlanta, Ga. 30345-4304 404.235-7128 404.235-7201, fax eha...@georgialibraries.org www.georgialibraries.org www.georgialibraries.org/pines

Re: [OPEN-ILS-GENERAL] Release Manager Proposal for 2.7

2014-03-27 Thread Lindsay Stratton
Hi Ben, This is a great initial outline, thanks! Pioneer is currently planning to save all of our upgrade energies for 2.7, so we have a pretty vested interest. My strength is in the end user/staff client side of things, and I would be more than happy to be involved in any testing thereof

[OPEN-ILS-GENERAL] Help with Circulation Limit Sets Groups

2014-03-27 Thread Deana Cunningham
Hi all, We recently migrated from Evergreen 2.3.2 to 2.5.1, and I am having trouble separating out Circulation Limit Sets. In 2.3.2 I had Circulation Limit Sets set up for the majority of our items (books, etc.) at 999 (unlimited). I have Circulation Limit Sets for our DVDs and Magazines (5