[Koha-bugs] [Bug 20664] Optimize retrieval of biblio and item data

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664

--- Comment #88 from David Cook <dcook at prosentient.com.au> ---
Maybe this would be a compromise for Ere's situation:

https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary-SQL-through-a-custom-ResultSource

It wouldn't work for my scenario as I'm doing higher performance inserts, but
this might be a nice way of adding arbitrary SQL while maintaining use of the
DBIx::Class framework?

(I was inspired by Class::DBI. I work on a legacy project that uses Class::DBI
and it has some functionality for adding arbitrary SQL to the ORM:
https://metacpan.org/pod/Class::DBI#Ima::DBI-queries)

There's also some interesting discussion at
https://www.perlmonks.org/?node_id=700283. 

I wonder if a person could define a custom search through
https://metacpan.org/pod/DBIx::Class::ResultSet#ATTRIBUTES to achieve the
performance that Ere wants.

Ere, you're not re-using statement handles, right? So are you getting
performance improvement basically by reducing the number of SQL queries being
made? If so, you might be able to avoid the arbitrary SQL by just making a more
detailed search as noted in the attributes link above. 

Worth thinking about maybe?

-- 
You are receiving this mail because:
You are watching all bug changes.