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

[Brandon W. Uhlman]

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


>> - 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.


> 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.