Re: [Koha-zebra] Re: [Koha-devel] playing with the zebra on cvs head

[Sebastian Hammer]

For what it's worth, my instinct would be against putting the circ info in 
the record, as tempting as it may be otherwise... Zebra isn't really 
designed with that kind of transaction-oriented updates in mind; that's 
relational database stuff.

Doing the lookups required to show circ status for a screenful of records 
isn't a big deal. It's more complicated if you want circ status to be a 
searchable (like a filter) or sortable field, and retain the scalability of 
Zebra's query engine... then we might want some kind of queue-like system 
to stream circulation info into Zebra and into the indexes once the 'real' 
circulation system has been updated... You could think of it as primary 
(RDBMS) and secondary (Zebra) storage of circ info.

Hope this makes sense,

--Sebastian

At 11:13 14-08-2005 +1200, Chris Cormack wrote:
> Hi Paul
> > 5- questions :
> > ==============
> > for instance, item status are not stored in the marc record (being 
> > issued...) It means that when the user issues a catalogue query, if there 
> > is 20 resulting biblios, with 35 items, Koha has to check status of those 
> > 35 items.
> > We can :
> > * do nothing, the cpu needed is not so big.
> > * embeed the item status. It means everytime the status is modified 
> > -issue/return/transfert-, the record has to be updated (cpu consumming too ?)
> > * add a checkbox "show item status" on search screen (with orderby). 
> > disabled by default, would means "don't check status".
>
> By status we are checking onloan, lost etc? We also would want to be able 
> to search by branch. So we would need to check holdingbranch also.
> So we would need to make sure that was stored in the zebra idx, if we 
> choose to do it this way.
>
> From what ive observed at library's. Circulation needs to be the fastest 
> process, searching comes second. If we can get get the item info into the 
> zebra index without causing a performance hit when issuing and returning, 
> that would be cool. But I wouldnt like to slow circulation down.
>
> Chris
> --
> Chris Cormack                                      Katipo Communications
> Programmer                                         www.katipo.co.nz
> 027 4500 789
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Koha-zebra mailing list
> address@hidden
> https://lists.sourceforge.net/lists/listinfo/koha-zebra

--
Sebastian Hammer, Index Data, www.indexdata.com
Direct phone: (603) 209-6853 Fax: (603) 357-1813