2012-09-24, 16:40
(2012-09-22, 11:17)jmarshall Wrote: 1. The separate queries for art.
[...]
The first can't really be - after all, art is a 1:many map, so you can't retrieve it all in one go.
But can there be multiple "thumb"'s for 1 item?
Because, mainly, the performance issue is because the remotes want to retrieve the thumb of a list of items.
If there is only 1 thumb (which seems to be the case, unless mistaken), we add it to the views and performance is great in this case.
In my remote mysql case, it adds 100ms for a ~50 items query vs. adding nearly 1sec PER ITEM.
I have an unpublished patch for this.
(2012-09-22, 11:17)jmarshall Wrote: 2. The open/close of the db for each of those queries.
I already tried something which avoided the open/close.
Although the performances increased, it still wasn't usable, whether with Yatse or the official remote's fork which implement JSON.
BTW, asking for "resume" also fetches from the database for each item, while the info is available from the views. This also degrades performance....
I'm working on a patch.