Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?

2018-04-03 Thread Bill Erickson
en-ils-general [mailto:open-ils-general- > boun...@list.georgialibraries.org] *On Behalf Of *Bill Erickson > *Sent:* Monday, April 02, 2018 3:31 PM > *To:* Evergreen Discussion Group <open-ils-general@list. > georgialibraries.org> > *Subject:* Re: [OPEN-ILS-GENERAL] metabib.browse_ent

Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?

2018-04-03 Thread Josh Stompro
...@list.georgialibraries.org] On Behalf Of Bill Erickson Sent: Monday, April 02, 2018 3:31 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup? Hi Josh, I clean these up about once a year. It's never been a problem, thou

Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?

2018-04-02 Thread Mike Rylander
Josh, It's not causing any issues in any instance that EOLI oversees. It's a unique string listing based on a B+Tree index, so until you get past several quintillion entries you should be fine. The one benefit of removing orphaned entries would be for the off chance that the terms in the string

Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?

2018-04-02 Thread Bill Erickson
Hi Josh, I clean these up about once a year. It's never been a problem, though. I just like cleaning things. -b On Mon, Apr 2, 2018 at 4:10 PM, Josh Stompro wrote: > Hello, I’ve been changing around some indexing rules and applied the fix > to the full stop/rda

[OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?

2018-04-02 Thread Josh Stompro
Hello, I've been changing around some indexing rules and applied the fix to the full stop/rda relator code normalization issue and now just noticed that all the no longer used browse entries are sticking around in metabib.browse_entry. There are 175K entries out of 950K that are no longer used