[Koha-devel] NoSQL

[Rick Welykochy]

Cab Vinton wrote:

> According to that font of universal wisdom, Wikipedia, "Typical modern
> relational databases have shown poor performance on data-intensive
> applications including indexing a large number of documents [= any
> ILS?], serving pages on high-traffic websites and delivering streaming
> media. They can be efficient only when they are tuned either for small
> but frequent read/write transactions or for large batch transactions
> with rare write accesses, while there are demands for the data stores
> capable of heavy workloads with frequent updates."

I checked the date and it isn't April 1st!

The wikipedia article indicates that RDB performance can start to flag
when doing joins on databases that are in the TB and PB sizes (tera-
and peta-byte). This is not the case for Koha, yet! Nor for the foreseeable
future.

> Thoughts? How wedded is Koha to SQL in the long run?

Quite wedded in the data model. Actually, Koha is quite wedded to MySQL
specifically. It would be a lot of work to convert the existing code to use
a different SQL database, let aone a different style of data store.

NoSQL is a storm in a teacup unless you are a Facebook type application
dealing with truly enormous datasets.

cheers
rickw

-- 
_________________________________
Rick Welykochy || Praxis Services

"Most folk are about as happy as they make up their minds to be."
    -- anon