[OPEN-ILS-DEV] ***SPAM*** ***SPAM*** Deindexing deleted bibs; superpage settings

[Mike Rylander]

On Wed, Mar 17, 2010 at 2:46 PM, Brandon W. Uhlman
<brandon at branflakes.net> wrote:
> Quoting Mike Rylander <mrylander at gmail.com>:
>
>>> - is cleaning up indexing for these deleted bib records as easy as
>>> 'DELETE
>>> FROM metabib.*_field_entry WHERE source IN (SELECT id FROM
>>> biblio.record_entry WHERE deleted = true)'
>>
>> ... you remove the metabib.metarecord_source_map entries for delete
>> bibs, as this will effectively hide them from all searches (yes, even
>> non-metarecord searches).
>
> Yeah, when I look at the staged_search, I understand why that works.  I
> still don't understand why we'd bother keeping these data (the m*fe entries)
> around knowing that (because of the change in metarecord_source_map) they'll
> never return as results anyway. It just feels like Evergreen is trying to
> star in an episode of TLC's 'Hoarding: Buried Alive' (in this case, by
> indexing data). :-p
>

I'm not against it, I'm just not strongly in favor of it.  However,
that data is removed on update by the trunk in-db triggers ... so, in
the future it will be automatic.

>
>>> - what do folks think of delete indexing information for bibs at the time
>>> of
>>> 'deletion', and to make re-ingesting part of the undeletion process --
>>> since
>>> deleted records by design can't be found by indexed-field searches,
>>> anyway,
>>> IIRC. If there's consensus that this is a good idea, I can submit a patch
>>> to
>>> that effect.
>
>> Actually, I've been pondering whether it would be best to have the
>> delete-protecting RULE simply delete the metabib.metarecord_source_map
>> entry for the bre.  That, to me, seems the most straight-forward thing
>> to do, eh?  (And, incidentally, the in-db ingest trigger /does/ do
>> this in trunk.)
>
> Like Galen, +1 on this as well, with the caveat (probably borne of
> misunderstanding) I mention above.
>

Ok ... I'll start testing.

>
>> Mike Rylander
>>  | VP, Research and Design
>>  | Equinox Software, Inc. / The Evergreen Experts
>>  | phone:  1-877-OPEN-ILS (673-6457)
>>  | email:  miker at esilibrary.com
>>  | web:  http://www.esilibrary.com
>>
>
>
>
> =============================================
> Brandon W. Uhlman
> President, Lillooet-Camelsfoot TV and Radio Association
> 641 Victoria St, PO Box 2325
> Lillooet, BC   V0K 1V0
>
> (250) 256-7541 | brandon at branflakes.net
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com