Hi, poggi. I recently decided to do some experimenting with this, after seeing your previous post, since this would soon be a problem for me too, when I try to make my largest course so far.
The results are unfortunately not very conclusive, but I thought I’d share them anyway, just in case they can shed any light.
I made a dummy course purely for testing what happens when I try to compile levels from a very large database. I specifically wanted to investigate what happens when it would lead to more than 500 levels, to see if there is indeed a set limit.
I created a spreadsheet of 7,500 items, simply a single column of “1”, “2”, “3”, etc., and bulk uploaded them all into my database.
I first wanted to see what happened if I made large levels, so I tried compiling with 100 items per level. I waited about four minutes after confirming the compile, with no re-direct, but oddly enough, when I went to the level editor, everything seemed to be compiled.
I then deleted all newly-compiled levels, leaving only the two empty ones I had made to access the database editor. After that, I tried compiling again, this time with 15 items per level. If this were to succeed, it would compile 500 full levels, in addition to the two I started with.
Again, I waited about four minutes, with no redirect, before going to the level editor. It had compiled 132 new levels, before giving up, with the last level empty. (1,965 items total)
From here, I basically tried the same thing repeatedly, without deleting any levels and working my way up to the 500 level mark to see if it capped.
- The second attempt yielded 70 levels, with the last level empty.
- The third attempt yielded 42 levels, with the last level missing the last nine items.
- The fourth attempt yielded 123 levels, with the last level empty.
- The fifth attempt yielded 36 levels, with the last level empty.
- The sixth attempt yielded 115 levels, with the last level empty.
My course had a total of 520 levels by now, and I tried manually creating a new level without any issues (other than it taking quite a while with so many levels). So there doesn’t seem to be a limit of 500 levels, at least.
I tried the same routine one more time after this, getting 44 new levels, with the last level empty.
Unfortunately, I can find no rhyme or reason to these results. The amount compiled seems to be very sporadic, but within a certain range. I initially suspected that the number of levels currently in the course would hinder how many it manages to compile, but the data doesn’t seem to support this theory. Although the first attempt was still the most successful…
It’s also interesting to note that aside from the third attempt, every other attempt resulted in a completely empty level at the end.
It doesn’t seem that there is a time limit to how long it can work on it before giving up either, which was another guess of mine, as it seemed to work on it anywhere between two to six minutes before giving up each time.
So yes, I’m not sure how much help that will be to anyone, but those are the results of my experiments with it. As it stands, I’m unsure on how to proceed with my future course, which I expect to total over 3,000 unique items, plus duplicated levels for different testing directions. If there aren’t any new developments on the issue by the time I’m ready to start building it, I’ll probably be coming up with some more experiments to run. I’ll share any other results I come up with.
Any insight from the staff would be very appreciated though! 
