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@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@liblime.com> wrote:

On Wed, Oct 27, 2010 at 4:15 AM, Dobrica Pavlinusic <dpavlin@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@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel