Reply to thread

Message

<blockquote data-quote="thlucas" data-source="post: 1098584" data-attributes="member: 111098">OK, I finally figured out the OutOfMemoryException errors, and uploaded the 1.0.11.0 MSI installer.As it turns out, I was doing a LEFT JOIN on the SCRIPTS table for every movie in the database, which causes the script content to be returned for every movie!&nbsp; I adjusted this processing to load the SCRIPTS table by itself, then do a look-up by ID into the SCRIPTS table to get the script content to resolve the movie script ID and NAME values from.&nbsp; This reduced the memory considerably - using Sea Monkeys database, it took it down from 1.5GB to about 120KB!Anyway, give it a try and let me know.[DOUBLEPOST=1409772393][/DOUBLEPOST]Imzadi - your database is kind of odd, in that you have a ton of &quot;black_list&quot; filters specified, as well as multiple users.&nbsp; The tool handles it, but it is extremely slow due to the amount (113,000+) black list filters.&nbsp; Is there a reason why you have that many black list filters?</blockquote>

[QUOTE="thlucas, post: 1098584, member: 111098"] OK, I finally figured out the OutOfMemoryException errors, and uploaded the 1.0.11.0 MSI installer. As it turns out, I was doing a LEFT JOIN on the SCRIPTS table for every movie in the database, which causes the script content to be returned for every movie! I adjusted this processing to load the SCRIPTS table by itself, then do a look-up by ID into the SCRIPTS table to get the script content to resolve the movie script ID and NAME values from. This reduced the memory considerably - using Sea Monkeys database, it took it down from 1.5GB to about 120KB! Anyway, give it a try and let me know.[DOUBLEPOST=1409772393][/DOUBLEPOST] Imzadi - your database is kind of odd, in that you have a ton of "black_list" filters specified, as well as multiple users. The tool handles it, but it is extremely slow due to the amount (113,000+) black list filters. Is there a reason why you have that many black list filters? [/QUOTE]

Verification