[Koha] how does koha save data

[Joe Atzberger]

Octavee--

You are seeing the value that is preserved in the index.  Clearly the index
is necessary to avoid searching entire database tables for each query.
Depending on whether or not you use zebra indexing, a manual reindex can be
called by:

misc/migration_tools/rebuild_zebra.pl
misc/migration_tools/rebuild_nozebra.pl

Rebuilding indexes is typically accomplished each night with the same
scripts via scheduled job.  In full production, it doesn't make sense for
cataloguers to rebuild all the indexes each time they add a record.

If you manipulate data directly through mysql, you are no longer using
Koha.  It is up to you to figure out how the application may be broken by
this, why MARC relationships or table pointers may no longer be valid, etc.
Basically, whatever problems result are not attributable to the
application.

On the other hand, if you are using Koha's interface, and the logic breaks
down, then it may be a bug developers can address.  Some of the behavior of
indexing and in particular MARC manipulation have been greatly improved in
the newest versions of Koha.  In particular, you might benefit from
examining the 3.0 alpha just released.

-joe atzberger
LibLime

On Jan 11, 2008 3:43 PM, Octavee Uhl <octavee at gmail.com> wrote:

>
> Hello,
>
> does anyone know how koha saves biblio and item data? Obviusly the data
> gets
> saved in different places twice. When I change the data for a biblio or an
> item in the mysql database it is only changed in the opac fields or the
> simple view fields in opac. When I switch to the complete view in opac I
> see
> a different value.
> For exapmple when I change a title in the database (without going through
> the koha intranet interface) it only gets changed in the simple view in
> opac.
> The reason why I am asking is that for checking errors the koha intranet
> is
> way too slow and time consuming. Through the mysql database it is much
> faster and easier.
>
> Thank you
> Regards
> Octavee
> __________________________________
> Koha version 2.2.8
> OS version Linux Librarian 2.6.18-4-686
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080111/2e3c51e3/attachment-0001.htm