[Koha-devel] DBIx::Class vs current Koha's DBI performance

[Clay Fouts]

Speaking of DBIC, has anyone looked into other ORM layers as potential
candidates for integration? The only other one I've looked at and
experimented with is Rose::DB::Object. It's considerably faster than DBIC,
both during startup and ongoing execution. The API makes more sense to me,
too, but that's a personal preference. However, it lacks some of DBIC's
schema management utilities and the ResultSet-style of subquerying (which
also has the advantage of not having deal with a ResultSet in the first
place).

Thoughts?

Clay


On Wed, Oct 27, 2010 at 12:06 PM, Chris Cormack <chris at bigballofwax.co.nz>wrote:

> Gah bumped by people on the bus, what I was trying to say was that for 3.4
> we plan to use the schema tools to move us one step away from mysql
> dependency.
>
> We are talking about plack at the dev conf tomorrow, please try and join us
> on irc.
>
> Chris
>
> On 28 Oct 2010 03:52, "Fouts, Clay" <cfouts at liblime.com> wrote:
>
> On Wed, Oct 27, 2010 at 4:15 AM, Dobrica Pavlinusic <dpavlin at rot13.org>
> wrote:
> >
> > You are correct t...
>
> DBIx::Class handles cache invalidation very well as long as it is used
> uniformly as the only means of accessing the database. My concern is more in
> regards to the challenges with getting all of Koha's use of a given set of
> tables to go through the dbic interface.
>
>
>
>
> > Another intersting bit is change at:
> >
> > http://git.rot13.org/?p=koha.git;a=commit;h=8b27e87c2...
>
>  While this is much faster, the ISO format has hard-coded limitations that
> Koha needs to surpass.
>
>
>
>
> > From my expirience so far, there are quite a few more low hanging fruits
>  > which we can pick in...
>
> Getting Koha to run persistently (and to do so safely!) seems like a higher
> priority in my estimation than the conversion to DBIC, if for no other
> reason than pervasive use of DBIC is going to seriously impede CGI
> performance. In mean time, I find that applying small, judicious use of
> local caching often gives a high return on very little time and additional
> code while not interfering with the API.
>
> Clay
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20101104/4d00c97b/attachment.htm>