Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 546212" data-attributes="member: 18896">Thank you. I must say that I found no delays in using it, but the initial load was excruciating.I assume the main slowdown is correlating how many movies an actor has played in, to decide if they should be listed. On 1000 movies with 5 actors per movies, that is 5000 actor entries that have to be checked against the 1000 movies to see if they played in each of them. Roughly speaking that would boil down to 5 million checks, which would explain the slowdown.Perhaps there needs to be some SQL caching added, like an extra field that keeps track on how many movies an actor has been in. That 'counter' could be updated auto during the adding/removal of a movie, or manual from inside the configuration. Then on building the category views, you use that counter to quickly filter out the actors that played in the amount of movies configured in the advanced settings (2 by default).I'm probably oversimplifying things, but sometimes that helps <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="RoChess, post: 546212, member: 18896"] Thank you. I must say that I found no delays in using it, but the initial load was excruciating. I assume the main slowdown is correlating how many movies an actor has played in, to decide if they should be listed. On 1000 movies with 5 actors per movies, that is 5000 actor entries that have to be checked against the 1000 movies to see if they played in each of them. Roughly speaking that would boil down to 5 million checks, which would explain the slowdown. Perhaps there needs to be some SQL caching added, like an extra field that keeps track on how many movies an actor has been in. That 'counter' could be updated auto during the adding/removal of a movie, or manual from inside the configuration. Then on building the category views, you use that counter to quickly filter out the actors that played in the amount of movies configured in the advanced settings (2 by default). I'm probably oversimplifying things, but sometimes that helps :) [/QUOTE]

Verification