As version 2.0 has been modded heavily to fulfill our needs, it became slower, especially when google and other bots hits the site for indexing. Version 3.0 seems to be having 99% of our existing functionality in the core, without need of any modification, im expecting big speed boost / server load decrease.
After migration, i hit two issues :
1) the forum cannot be loaded, because it is hitting the max_allowed packet mysql error - for anonymous user it tries to do some nasty update to phpbb_users table to set user_permissions= ... kind of sql, which is currently 1.050.000 bytes long. I know i can update this parameter on the mysql, but I wonder, why is this so huge, if each of our 6000 users will have 1Mb set of permissions, that makes 6Gb just for the users table !!! How the user permissions are used during the work ? are they accessed each time, are they stored server side on some session variable, in memory or file ? or are they sent via cookie to client ? and what is the relationship between ACL_ROLES table and this USER_PERMISSIONS field ? does it duplicate its role ?
2) i cannot set any permissions, as any try to load the list of forums in admin panel ends with
"Maximum execution time of 30 seconds"
error. When doing the same in our old forum, ptirhiiks mod, it works fine, even if there are 4500 branches, we have like 15 top level categories with up to level 8 nesting below them. How the admin page of 3.0 works with the forums ? does it cache it somehow ? can I set something somewhere to be able to work with them ? Again, increasing timeout is kind of solution, but if this is what it takes to have the forum working, i dont think it is the right one for me to use, i cannot have my user wait over 30s to get page displayed
Please let me know, if you have any experience with such a size of forum in 3.0 version, or if there are any kind of optimalisation that can be done to vanilla 3.0 to make it work faster.
the forum is running on dual core machine with 4 gb memory and sata raid, only big application on this server, so most of the resources are available to the forum.Version of phpBB3: 3.0
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? : fresh install, then upgrade from 2.0
Was this an install through your host? : no, but i have full control of the server, including hardware
MODs you have installed: none yet
When the problem started: immediatly after conversion was done
Additionally, you may wish to provide the following (where applicable)
Template(s) used: prosilver only
Language(s) used: en, czech
Version of PHP used: 4.4.4-pl8-gentoo
Database and version used: 4.0.26