[OPEN-ILS-GENERAL] test message -please disregard

2013-09-25 Thread Sharp, Chris
Testing.

-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csh...@georgialibraries.org
http://pines.georgialibraries.org/


[OPEN-ILS-GENERAL] 2.5 Release Update [RM2.5]

2013-09-25 Thread Dan Wells
Hello all,

[NOTE: This message was sent yesterday, but I am told that list problems 
prevented it from getting through, so this is a resend.]

The purpose of this email is to announce the official delay of the 2.5 release, 
and to establish a new timeline for release.  A number of factors are 
contributing to this delay, including some exciting development targeted at 
making the TPAC work better on mobile devices.  In talking with many community 
members, the consensus opinion was that the benefits of delaying and including 
the to-be-reviewed work outweighed the costs, but several also cautioned that 
we must emphasize these costs (loss of release predictability, increased chance 
of instability).  How the community wants to balance similar tradeoffs in the 
future will need to be discussed more thoroughly at a later date.

Here is the new timeline:

9/26, noon - feature freeze for master (beta cutoff)
9/26, end-of-day - packaged beta release
10/4 -2.5 RC1 release
10/14 - 2.5 final release

In addition to the mobile TPAC branch (which Lebbeous and I have both offered 
to review), there are still 4 outstanding branches (well, more like 3.25) on 
the original beta-blockers list which I would like to include if possible.  I 
know this recent burst in development activity has spread everyone a little 
thin, but any help in reviewing these would be much appreciated:

https://bugs.launchpad.net/evergreen/+bugs?field.tag=2.5-beta-blocker

Thanks as always,
Dan



Daniel Wells
Library Programmer/Analyst
Hekman Library, Calvin College
616.526.7133





[OPEN-ILS-GENERAL] Spinals

2013-09-25 Thread Mary Toma
Has anyone had success in printing spinals from Evergreen using an 8.5 x 11
inch (50 spinals per page) sheets of spinals.  Specifically Bro Dart
laserink jet labels 55-395-014.

-- 
Mary Toma
Head Librarian
South Central Regional Library
160 Main Street
Box 1540
Winkler, MB R6W 4B4
204-325-5864


Re: [OPEN-ILS-GENERAL] Spinals

2013-09-25 Thread Rogan Hamby
I know that folks have but I wasn't personally involved with the process so
I can't help, sorry.


On Wed, Sep 25, 2013 at 11:22 AM, Mary Toma scrlhead...@gmail.com wrote:

 Has anyone had success in printing spinals from Evergreen using an 8.5 x
 11 inch (50 spinals per page) sheets of spinals.  Specifically Bro Dart
 laserink jet labels 55-395-014.

 --
 Mary Toma
 Head Librarian
 South Central Regional Library
 160 Main Street
 Box 1540
 Winkler, MB R6W 4B4
 204-325-5864




-- 

Rogan Hamby, MLS, CCNP, MIA
Managers Headquarters Library and Reference Services,
York County Library System

You can never get a cup of tea large enough or a book long enough to suit
me.
-- C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis


Re: [OPEN-ILS-GENERAL] Spinals

2013-09-25 Thread Tina Ji (Project Sitka)

Hi Mary,

Will this help you: http://www.branchdistrictlibrary.org/professional/labels/?

Tina

Quoting Mary Toma scrlhead...@gmail.com:


Has anyone had success in printing spinals from Evergreen using an 8.5 x 11
inch (50 spinals per page) sheets of spinals.  Specifically Bro Dart
laserink jet labels 55-395-014.

--
Mary Toma
Head Librarian
South Central Regional Library
160 Main Street
Box 1540
Winkler, MB R6W 4B4
204-325-5864





Tina Ji
1-888-848-9250
Trainer/Help Desk Specialist
BC Libraries Cooperative/Sitka




Re: [OPEN-ILS-GENERAL] Placing Holds on Records with Parts

2013-09-25 Thread Mary Llewellyn
Hi Brent,

 

The mention of parts and part holds makes me twitch!

 

When we first started implementing parts, like you, we had a mixture of
items with and without parts. The All Parts label for the title level hold
confused librarian and patron alike, leading them to think that the hold was
being placed upon every part. Instead, patrons would often get an item that
should have had a part label, but didn't, so they'd get a piece they didn't
want, as you describe Getting Part 2 when they thought they were getting
the entire collection. Unhappy patrons, unhappy librarians.

 

So we removed the text All parts and left it blank, hoping that would lead
the patron to actually open the dropdown list when placing the hold, so they
would actually look at the list of parts and select one. That didn't fly
either.

 

Finally, we made a rule that if one library broke a set into parts and
labeled them, then the other libraries that circulated the set as a whole
needed to use a part labeled as boxed set. We removed the title level hold
entry entirely for bibs with items with parts. The result is the patron can
pick either the boxed set part or an individual. No more title level holds
in this case. Any library not applying a part will not have their items
available for holds. I think that has calmed things down a bit. 

 

But don't get me started about the librarians that want their patrons to be
able to place holds on part 1, part 2, part 3, in one step, not realizing
that defeats the purpose of parts.to be able to control the order in which
the part hold is filled!

 

Mary

 

Mary Llewellyn

Database Manager

Bibliomation, Inc.

24 Wooster Ave.

Waterbury, CT 06708

mllew...@biblio.org

 

 

 

From: open-ils-general-boun...@list.georgialibraries.org
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
Brent Mills
Sent: Tuesday, September 24, 2013 3:37 PM
To: Evergreen Discussion Group
Subject: [OPEN-ILS-GENERAL] Placing Holds on Records with Parts

 

Hello everyone,

 

I was wondering if someone could help me get some clarity on hold targeting
within records that have a mix of items with parts and without.

 

In a record like this one: http://tinyurl.com/pbg9lkz, there are a mix of
libraries that don't split out the item into parts and those that do.

 

My question is, when a patron (or staff member) goes to place a title level
hold on a record that has a mix of parts and no parts, if they select the
default All Parts option instead of Part 1 or Part 2 (pic:
http://tinyurl.com/lqaogmy), does the hold target both parts as a whole in
addition to the other, non-parted items? Or does it fill the hold by
grabbing the first available item? Basically, when a patron selects the All
Parts option, what is Evergreen looking at when choosing where to place the
hold? Hope that made some sense. Curious if patrons might be getting a Part
2 of something when they thought they were getting the entire collection.

 

Just basically looking for some advisement on hold targeting behavior with a
mix of parts/no parts.

 

Thanks!

 

-

Brent Mills
Sage Technical Support Specialist
Hood River Library District
502 State Street / Hood River OR / 97031

email: br...@hoodriverlibrary.org
tickets: https://sagesupport.eou.edu https://sagesupport.eou.edu/ 

 

 

 

 



[OPEN-ILS-GENERAL] ***SPAM*** Re: Placing Holds on Records with Parts

2013-09-25 Thread Michele Morgan

Hi All,

Implementing parts does have it's challenges, and it's not perfect yet, but we 
feel it's a big step in the right direction.


Implementing parts affords the huge benefit that patrons are able to place their 
own holds on materials like popular dvds, and actually get the part they want, 
rather than needing to ask a staff member to place copy level holds for them.


We are still working on converting data to parts after migration, and we 
struggled with the catalog display that didn't make it clear enough that a 
choice of part might need to be made. We tried to make the display clearer, 
which has helped. Here's a screenshot:


http://screencast.com/t/Y4gc7bplc

There are also a few bugs that make managing parts and converting the data 
difficult, but we still feel that the benefits of using parts outweigh the 
current headaches.


-Michele

On 9/25/2013 2:12 PM, Mary Llewellyn wrote:

Hi Brent,

The mention of parts and part holds makes me twitch!

When we first started implementing parts, like you, we had a mixture of items
with and without parts. The “All Parts” label for the title level hold confused
librarian and patron alike, leading them to think that the hold was being placed
upon every part. Instead, patrons would often get an item that should have had a
part label, but didn’t, so they’d get a piece they didn’t want, as you describe
“Getting Part 2 when they thought they were getting the entire collection.”
Unhappy patrons, unhappy librarians.

So we removed the text “All parts” and left it blank, hoping that would lead the
patron to actually open the dropdown list when placing the hold, so they would
actually look at the list of parts and select one. That didn’t fly either.

Finally, we made a rule that if one library broke a set into parts and labeled
them, then the other libraries that circulated the set as a whole needed to use
a part labeled as “boxed set.” We removed the title level hold entry entirely
for bibs with items with parts. The result is the patron can pick either the
“boxed set” part or an individual. No more title level holds in this case. Any
library not applying a part will not have their items available for holds. I
think that has calmed things down a bit.

But don’t get me started about the librarians that want their patrons to be able
to place holds on part 1, part 2, part 3, in one step, not realizing that
defeats the purpose of parts…to be able to control the order in which the part
hold is filled!

Mary

Mary Llewellyn

Database Manager

Bibliomation, Inc.

24 Wooster Ave.

Waterbury, CT 06708

mllew...@biblio.org

*From:*open-ils-general-boun...@list.georgialibraries.org
[mailto:open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Brent
Mills
*Sent:* Tuesday, September 24, 2013 3:37 PM
*To:* Evergreen Discussion Group
*Subject:* [OPEN-ILS-GENERAL] Placing Holds on Records with Parts

Hello everyone,

I was wondering if someone could help me get some clarity on hold targeting
within records that have a mix of items with parts and without.

In a record like this one: http://tinyurl.com/pbg9lkz, there are a mix of
libraries that don't split out the item into parts and those that do.

My question is, when a patron (or staff member) goes to place a title level hold
on a record that has a mix of parts and no parts, if they select the default
All Parts option instead of Part 1 or Part 2 (pic:
http://tinyurl.com/lqaogmy), does the hold target both parts as a whole in
addition to the other, non-parted items? Or does it fill the hold by grabbing
the first available item? Basically, when a patron selects the All Parts
option, what is Evergreen looking at when choosing where to place the hold? Hope
that made some sense. Curious if patrons might be getting a Part 2 of
something when they thought they were getting the entire collection.

Just basically looking for some advisement on hold targeting behavior with a mix
of parts/no parts.

Thanks!

-

Brent Mills
Sage Technical Support Specialist
Hood River Library District
502 State Street / Hood River OR / 97031

email: br...@hoodriverlibrary.org mailto:br...@hoodriverlibrary.org
tickets: https://sagesupport.eou.edu https://sagesupport.eou.edu/



--
Michele Morgan, Technical Assistant
North of Boston Library Exchange, Danvers Massachusetts
mmor...@noblenet.org


Re: [OPEN-ILS-GENERAL] Evergreen Software Performance Analysis

2013-09-25 Thread Scott Myers
Hi Rogan,

The db work Command Prompt has done for KCLS is mostly configuration things, 
work mem, max connections, etc. They have been fine tuning all those settings 
to get the best performance. These settings wouldn't help other people as it 
would be dependent on each libraries load. Another change made by Command 
Prompt was to remove slony replication and move to pgpool. If anyone needs help 
doing the same with their database I would highly recommend Command Prompt.

As for work done by Catalyst, all work that is directly applicable and 
beneficial to the community has been added. Kyle Tomita 
https://launchpad.net/~tomitakyle and Fred Parks https://launchpad.net/~fparks 
have been the most active community members from our team with Kyle being the 
9th on the top contributors list as of 9/24/13.

Catalyst also shared a multithreaded bib reingest that greatly reduces the time 
needed to do a full reingest. We also plan to share the way that Catalyst 
deploys code to KCLS without downtime.

Catalyst considers itself part of the community and is actively working to add 
more value. We have developed a strong relationship with KCLS and enjoy working 
with them greatly and our relationship has allowed us to gain a strong 
understanding of Evergreen. We've got some interesting work that we are going 
to be doing in the near future for KCLS, and as we have in the past, that which 
is beneficial to the community will be shared.

If you would like detail on any of these items now, feel free to reach out to 
me. You have my cell phone number.

Thanks

Scott Myers


From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan 
Hamby
Sent: Tuesday, September 24, 2013 7:10 AM
To: Joshua D. Drake
Cc: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Evergreen  Software Performance Analysis

Picking back up an old thread...

I was hoping at some point to hear more about the db work Command Prompt has 
done for KCLS and perhaps see some work in git. I was sad to see that in the 
new LJ article that Jed Moffitt said that at this point KCLS has forked 
Evergreen so I suppose the work Catalyst and Command Prompt has done isn't 
relevant to the rest of the Evergreen community.  I suppose that also means 
that any experience gained in working on the KCLS system isn't transferrable.





On Thu, Aug 22, 2013 at 11:05 AM, Rogan Hamby 
rogan.ha...@yclibrary.netmailto:rogan.ha...@yclibrary.net wrote:
Hi Joshua,

I don't know if you had a chance to see my message below so I'll copy you in 
directly as well and maybe touch base again after labor day.  With the 
Evergreen community having a rich collection of input from various contributors 
(many like yourself paid to do individual development by community members) all 
participating in the open source spirit and putting their code out there, 
allowing others to build on top of it or modify it or package it into master it 
would be exciting to see this work since you've indicated it's had a big impact 
for your customers.

I did a quick mark mail search since I sometimes lose emails to spam filters 
and noticed that back in Feb you mentioned that your Evergreen customer has 
been KCLS.  I know that at the conference they talked about setting up a public 
repo that would be available right after the conference.  Maybe they can chime 
in on an update on that?


On Fri, Aug 9, 2013 at 11:52 AM, Rogan Hamby 
rogan.ha...@yclibrary.netmailto:rogan.ha...@yclibrary.net wrote:
HI Josh,

Can you share with folks some more specifics?

For example:

In regards to optimizing the conf file can you share what kind of optimizations 
and the benchmarks?  E.g. with X records we see Y performance in activity Z.

A lot of other changes obviously touch on changes to code and/or schema 
changes.  Are these going to be released on a public repo or fed back into 
master?




On Thu, Aug 8, 2013 at 2:01 PM, Joshua D. Drake 
j...@commandprompt.commailto:j...@commandprompt.com wrote:

On 08/07/2013 10:12 AM, Rogan Hamby wrote:
I'm guessing maybe Joshua doesn't keep track of the list serv but is
there someone else from Command Prompt or whomever they did the
development work for that could chime in?  When he says they've made
improvements do those include GPLed code?

Sorry folks, I do watch this list but not as much as the postgresql lists. We 
have also been very busy. Here are some of the basic things we have done:

1. Optimized the postgresql.conf, it is amazing how much you can get from some 
minor tweaks after some performance analysis.

2. Converted some of the procedures to C, for example translate_isbn1013

3. Modified the holds process to use a look up table.

4. Changed the process for holds so they don't indefinitely exist but get 
migrated out for reporting but does not affect performance of the active table.

5. Partitioning of larger tables

6. Upgraded versions of PostgreSQL to more modern versions 

Re: [OPEN-ILS-GENERAL] Evergreen Software Performance Analysis

2013-09-25 Thread Rogan Hamby
Hi Scott,

I am curious about any improvement metrics you've seen from work you've done 
and where it might be available to look at for replication. Joshua made some 
pretty broad comments that sound really interesting and anything that improves 
db performance is of great interest to me.

Excuse my brevity, sent from my iPhone 

-- 

Rogan Hamby, MLS, CCNP, MIA
Managers Headquarters Library and Reference Services, 
York County Library System

“You can never get a cup of tea large enough or a book long enough to suit me.” 
― C.S. Lewis


 On Sep 25, 2013, at 3:50 PM, Scott Myers smy...@catalystitservices.com 
 wrote:
 
 Hi Rogan,
  
 The db work Command Prompt has done for KCLS is mostly configuration things, 
 work mem, max connections, etc. They have been fine tuning all those settings 
 to get the best performance. These settings wouldn’t help other people as it 
 would be dependent on each libraries load. Another change made by Command 
 Prompt was to remove slony replication and move to pgpool. If anyone needs 
 help doing the same with their database I would highly recommend Command 
 Prompt.
  
 As for work done by Catalyst, all work that is directly applicable and 
 beneficial to the community has been added. Kyle Tomita 
 https://launchpad.net/~tomitakyle and Fred Parks 
 https://launchpad.net/~fparks have been the most active community members 
 from our team with Kyle being the 9th on the top contributors list as of 
 9/24/13.
  
 Catalyst also shared a multithreaded bib reingest that greatly reduces the 
 time needed to do a full reingest. We also plan to share the way that 
 Catalyst deploys code to KCLS without downtime.
  
 Catalyst considers itself part of the community and is actively working to 
 add more value. We have developed a strong relationship with KCLS and enjoy 
 working with them greatly and our relationship has allowed us to gain a 
 strong understanding of Evergreen. We’ve got some interesting work that we 
 are going to be doing in the near future for KCLS, and as we have in the 
 past, that which is beneficial to the community will be shared.
  
 If you would like detail on any of these items now, feel free to reach out to 
 me. You have my cell phone number.
  
 Thanks
  
 Scott Myers
  
  
 From: open-ils-general-boun...@list.georgialibraries.org 
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of 
 Rogan Hamby
 Sent: Tuesday, September 24, 2013 7:10 AM
 To: Joshua D. Drake
 Cc: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Evergreen  Software Performance Analysis
  
 Picking back up an old thread...
  
 I was hoping at some point to hear more about the db work Command Prompt has 
 done for KCLS and perhaps see some work in git. I was sad to see that in the 
 new LJ article that Jed Moffitt said that at this point KCLS has forked 
 Evergreen so I suppose the work Catalyst and Command Prompt has done isn't 
 relevant to the rest of the Evergreen community.  I suppose that also means 
 that any experience gained in working on the KCLS system isn't transferrable. 
  
  
  
  
  
  
 
 On Thu, Aug 22, 2013 at 11:05 AM, Rogan Hamby rogan.ha...@yclibrary.net 
 wrote:
 Hi Joshua,
  
 I don't know if you had a chance to see my message below so I'll copy you in 
 directly as well and maybe touch base again after labor day.  With the 
 Evergreen community having a rich collection of input from various 
 contributors (many like yourself paid to do individual development by 
 community members) all participating in the open source spirit and putting 
 their code out there, allowing others to build on top of it or modify it or 
 package it into master it would be exciting to see this work since you've 
 indicated it's had a big impact for your customers.  
  
 I did a quick mark mail search since I sometimes lose emails to spam filters 
 and noticed that back in Feb you mentioned that your Evergreen customer has 
 been KCLS.  I know that at the conference they talked about setting up a 
 public repo that would be available right after the conference.  Maybe they 
 can chime in on an update on that?
  
  
 
 On Fri, Aug 9, 2013 at 11:52 AM, Rogan Hamby rogan.ha...@yclibrary.net 
 wrote:
 HI Josh,
  
 Can you share with folks some more specifics?
  
 For example:
  
 In regards to optimizing the conf file can you share what kind of 
 optimizations and the benchmarks?  E.g. with X records we see Y performance 
 in activity Z.  
  
 A lot of other changes obviously touch on changes to code and/or schema 
 changes.  Are these going to be released on a public repo or fed back into 
 master?
  
  
  
  
 
 On Thu, Aug 8, 2013 at 2:01 PM, Joshua D. Drake j...@commandprompt.com 
 wrote:
 
 On 08/07/2013 10:12 AM, Rogan Hamby wrote:
 I'm guessing maybe Joshua doesn't keep track of the list serv but is
 there someone else from Command Prompt or whomever they did the
 development work for that could chime in?  When he says they've made
 improvements do those 

Re: [OPEN-ILS-GENERAL] Evergreen Software Performance Analysis

2013-09-25 Thread Rogan Hamby
P.S.

I hit send too soon.  I really appreciate the response Scott.  I look forward 
to seeing some of the information you referenced and am glad to see that Jed at 
KCLS was still committed to sharing.  If it can be reasonably forward ported to 
the community Evergreen is obviously what I am hoping will be the case.  And I 
think I speak for most if not all when I say we value everyone who contributes. 

Obviously, I don't expect Catalyst to speak for other vendors.  But I hope that 
all the vendors in the community are as dedicated to sharing as you are and I 
look forward to seeing more of what you've developed while working with KCLS.  
Certainly other vendors such as Equinox and Emerald Data have been similarity 
minded and I think it helps the community as a whole to have strong vendors 
participating.

Excuse my brevity, sent from my iPhone 

-- 

Rogan Hamby, MLS, CCNP, MIA
Managers Headquarters Library and Reference Services, 
York County Library System

“You can never get a cup of tea large enough or a book long enough to suit me.” 
― C.S. Lewis


 On Sep 25, 2013, at 3:50 PM, Scott Myers smy...@catalystitservices.com 
 wrote:
 
 Prompt.


Re: [OPEN-ILS-GENERAL] Evergreen Software Performance Analysis

2013-09-25 Thread Mike Rylander
Scott,

I echo Rogan's down-thread thanks for following up here.

I'm curious where the multi-threaded reingest project is shared.  I
can't find anything like that searching any of the Evergreen the
mailing lists or launchpad for terms like ingest and multi.
Perhaps I'm just missing it.  Some interest was expressed in the
community IRC channel, but also some confusion as to what exactly that
means.

TIA,

-- 
Mike Rylander
 | Director of Research and Development
 | Equinox Software, Inc. / Your Library's Guide to Open Source
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Sep 25, 2013 at 3:50 PM, Scott Myers
smy...@catalystitservices.com wrote:
 Hi Rogan,



 The db work Command Prompt has done for KCLS is mostly configuration things,
 work mem, max connections, etc. They have been fine tuning all those
 settings to get the best performance. These settings wouldn't help other
 people as it would be dependent on each libraries load. Another change made
 by Command Prompt was to remove slony replication and move to pgpool. If
 anyone needs help doing the same with their database I would highly
 recommend Command Prompt.



 As for work done by Catalyst, all work that is directly applicable and
 beneficial to the community has been added. Kyle Tomita
 https://launchpad.net/~tomitakyle and Fred Parks
 https://launchpad.net/~fparks have been the most active community members
 from our team with Kyle being the 9th on the top contributors list as of
 9/24/13.



 Catalyst also shared a multithreaded bib reingest that greatly reduces the
 time needed to do a full reingest. We also plan to share the way that
 Catalyst deploys code to KCLS without downtime.



 Catalyst considers itself part of the community and is actively working to
 add more value. We have developed a strong relationship with KCLS and enjoy
 working with them greatly and our relationship has allowed us to gain a
 strong understanding of Evergreen. We've got some interesting work that we
 are going to be doing in the near future for KCLS, and as we have in the
 past, that which is beneficial to the community will be shared.



 If you would like detail on any of these items now, feel free to reach out
 to me. You have my cell phone number.



 Thanks



 Scott Myers





 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Rogan Hamby
 Sent: Tuesday, September 24, 2013 7:10 AM
 To: Joshua D. Drake
 Cc: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Evergreen  Software Performance Analysis



 Picking back up an old thread...



 I was hoping at some point to hear more about the db work Command Prompt has
 done for KCLS and perhaps see some work in git. I was sad to see that in the
 new LJ article that Jed Moffitt said that at this point KCLS has forked
 Evergreen so I suppose the work Catalyst and Command Prompt has done isn't
 relevant to the rest of the Evergreen community.  I suppose that also means
 that any experience gained in working on the KCLS system isn't
 transferrable.











 On Thu, Aug 22, 2013 at 11:05 AM, Rogan Hamby rogan.ha...@yclibrary.net
 wrote:

 Hi Joshua,



 I don't know if you had a chance to see my message below so I'll copy you in
 directly as well and maybe touch base again after labor day.  With the
 Evergreen community having a rich collection of input from various
 contributors (many like yourself paid to do individual development by
 community members) all participating in the open source spirit and putting
 their code out there, allowing others to build on top of it or modify it or
 package it into master it would be exciting to see this work since you've
 indicated it's had a big impact for your customers.



 I did a quick mark mail search since I sometimes lose emails to spam filters
 and noticed that back in Feb you mentioned that your Evergreen customer has
 been KCLS.  I know that at the conference they talked about setting up a
 public repo that would be available right after the conference.  Maybe they
 can chime in on an update on that?





 On Fri, Aug 9, 2013 at 11:52 AM, Rogan Hamby rogan.ha...@yclibrary.net
 wrote:

 HI Josh,



 Can you share with folks some more specifics?



 For example:



 In regards to optimizing the conf file can you share what kind of
 optimizations and the benchmarks?  E.g. with X records we see Y performance
 in activity Z.



 A lot of other changes obviously touch on changes to code and/or schema
 changes.  Are these going to be released on a public repo or fed back into
 master?









 On Thu, Aug 8, 2013 at 2:01 PM, Joshua D. Drake j...@commandprompt.com
 wrote:


 On 08/07/2013 10:12 AM, Rogan Hamby wrote:

 I'm guessing maybe Joshua doesn't keep track of the list serv but is
 there someone else from Command Prompt or whomever they did the
 development work for that could chime in?  When he says they've 

[OPEN-ILS-GENERAL] ***SPAM*** RE: Evergreen Software Performance Analysis

2013-09-25 Thread Scott Myers
Mike,

The multithreaded reingest project was shared during the hackathon at the last 
evergreen conference.

Here is a link to what we ended up running for moving KCLS from 2.1 to 2.2.

https://github.com/CatalystIT/multithread_2_2_update

The files to pay attention to are the data_update_driver.pl and the 
update_driver.pl both have pod files attached with quite a few comments on how 
they work. 

If I can clear up what that means basically we created driver files that divide 
large amounts of data into smaller chunks and run those on multiple connections 
for cpu bound updates. A good example is the 2.1-2.2  which had changes in how 
the data was stored in the metabib field entry tables. This was a very CPU 
bound update and ended up being run with 32 simultaneous connections to reduce 
the amount of estimated time from 5 days to complete in 4 hours. 

Let me know if you have questions on how this can be setup or run. 

Thanks

Scott Myers

-Original Message-
From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Mike 
Rylander
Sent: Wednesday, September 25, 2013 1:41 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Evergreen  Software Performance Analysis

Scott,

I echo Rogan's down-thread thanks for following up here.

I'm curious where the multi-threaded reingest project is shared.  I can't find 
anything like that searching any of the Evergreen the mailing lists or 
launchpad for terms like ingest and multi.
Perhaps I'm just missing it.  Some interest was expressed in the community IRC 
channel, but also some confusion as to what exactly that means.

TIA,

--
Mike Rylander
 | Director of Research and Development
 | Equinox Software, Inc. / Your Library's Guide to Open Source  | phone:  
1-877-OPEN-ILS (673-6457)  | email:  mi...@esilibrary.com  | web:  
http://www.esilibrary.com


On Wed, Sep 25, 2013 at 3:50 PM, Scott Myers
smy...@catalystitservices.com wrote:
 Hi Rogan,



 The db work Command Prompt has done for KCLS is mostly configuration things,
 work mem, max connections, etc. They have been fine tuning all those
 settings to get the best performance. These settings wouldn't help other
 people as it would be dependent on each libraries load. Another change made
 by Command Prompt was to remove slony replication and move to pgpool. If
 anyone needs help doing the same with their database I would highly
 recommend Command Prompt.



 As for work done by Catalyst, all work that is directly applicable and
 beneficial to the community has been added. Kyle Tomita
 https://launchpad.net/~tomitakyle and Fred Parks
 https://launchpad.net/~fparks have been the most active community members
 from our team with Kyle being the 9th on the top contributors list as of
 9/24/13.



 Catalyst also shared a multithreaded bib reingest that greatly reduces the
 time needed to do a full reingest. We also plan to share the way that
 Catalyst deploys code to KCLS without downtime.



 Catalyst considers itself part of the community and is actively working to
 add more value. We have developed a strong relationship with KCLS and enjoy
 working with them greatly and our relationship has allowed us to gain a
 strong understanding of Evergreen. We've got some interesting work that we
 are going to be doing in the near future for KCLS, and as we have in the
 past, that which is beneficial to the community will be shared.



 If you would like detail on any of these items now, feel free to reach out
 to me. You have my cell phone number.



 Thanks



 Scott Myers





 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Rogan Hamby
 Sent: Tuesday, September 24, 2013 7:10 AM
 To: Joshua D. Drake
 Cc: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Evergreen  Software Performance Analysis



 Picking back up an old thread...



 I was hoping at some point to hear more about the db work Command Prompt has
 done for KCLS and perhaps see some work in git. I was sad to see that in the
 new LJ article that Jed Moffitt said that at this point KCLS has forked
 Evergreen so I suppose the work Catalyst and Command Prompt has done isn't
 relevant to the rest of the Evergreen community.  I suppose that also means
 that any experience gained in working on the KCLS system isn't
 transferrable.











 On Thu, Aug 22, 2013 at 11:05 AM, Rogan Hamby rogan.ha...@yclibrary.net
 wrote:

 Hi Joshua,



 I don't know if you had a chance to see my message below so I'll copy you in
 directly as well and maybe touch base again after labor day.  With the
 Evergreen community having a rich collection of input from various
 contributors (many like yourself paid to do individual development by
 community members) all participating in the open source spirit and putting
 their code out there, allowing others to build on top of it or modify it or
 package it