Optimizing Database Access in CritiqueBrainz

“Raw” SQL, not their fancy expression language.

This will take a lot of time. It might be better to convert one model at a time and all its usages.

Is this how it’s supposed to be done? @Bitmap, @rob?

You shouldn’t remove old way of accessing data through the web service. This will simplify development by not adding another huge dependency (MusicBrainz Server). Maybe just add an option in config file and then route function calls accordingly.

Another thing to consider here is doing requests in batches instead of getting data one by one. This is important because some pages display 10 or more reviews at a time, each requires one or more calls to these functions.

Good idea. :thumbsup: