[Koha-devel] How we can input a very large field

[Corey Burger]

On 5/26/05, Paul POULAIN <paul.poulain at free.fr> wrote:
> Andrés Tarallo a écrit :
> > Albert:
> >
> > The solution you are proposig seem to be very clean. For doing that some
> > fieldos should be blobs. However in the current DB Schema is not clear
> > to me that this can be done. On the other hand searches in blobs could
> > be very slow.
> > Andres
> 
> The DB scheme & Koha perl code supports fields > 255 char. The problem
> was only in HTML that had a limit to 255. In marc_words, there is a
> bloblink field. It's field only if the entry is >255 char. In this case,
> the bloblink contains the number of the blob in marc_blob file.
> With this, you have fields <255 easily accessible & other still managed.
> Note that with marc_word structure all words are indexed, so
> SearchMarc.pm can deal with any size with indexed performances.
> 
> Hope it's clear.
> 
> 
> --
> Paul POULAIN
> Consultant indépendant en logiciels libres
> responsable francophone de koha (SIGB libre http://www.koha-fr.org)
> 

As a side note, from my work in Wikipedia, who also use MySQL, that
storing large blobs of text in the database itself is a very bad
thing, due to major performance hits once you start getting large
numbers of them.

Corey