Speed / Load testing on a fat db shows as you can see a faster system, vertical axe is seconds , horizontal sections
i had to strip the vertical axe to 50, some section took a lot longer than 50 seconds when fully loaded (first admin login, online assessments, etc)
in average, 3.x loads any section in 4.2 seconds while 2.x used to do the same db in 14.5 seconds…in average, it seems 3.x is 3-4 times faster. we believe it could go faster (3.x is not using caching yet) but as it stands now we are quite happy. the important is now if a section has many thousands of items, loading times wont be exponentially affected (as it would have happened in 2.x) … loading times even with many thousands of items should remain around 4-7seconds. in the past it took thousands of queries to load a section, in average now is 100-150 queries no matter the amount of items.
next tuesday we finish the migration, we will need the rest of the week for bug fixing…maybe the week after we’ll start communicating customers to upgrade to 3.x