2011-11-14, 00:08
pilluli Wrote:Thanks for the quick response Montellese, I will keep doing that then. The only problem I see is that the query takes 3 seconds (to retrieve my entire videos collection and it is not that big) and was looking for ways to reduce that time...
Again, thanks!
Yeah the problem is that retrieving the "resume" property requires two extra queries for every item retrieved. So if you retrieve 100 movies that makes 100 * 2 + 1 query compared to 1 query if you don't retrieve the "resume" property.
That's why it takes so long. Obviously pre-filtering will reduce the number of queries but as I already said that's not possible right now (but it is a planned feature).