I haven't tested MyBB 1.8 in a while, but I installed it tongiht and there are some notable differences. First of all, index query count is down from 9 on stock to 7. Memory usage is also down from ~2MB to 1.25MB. All in all, my 1.8 install is hitting some impressive stats:
MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 21 ms
No. DB Queries: 7
PHP Processing Time: 13 ms (61.08%)
DB Processing Time: 8 ms (38.92%)
Extensions Used: mysqli, xml
Global.php Processing Time: 15 ms
PHP Version: 5.5.9
Server Load: 0
GZip Encoding Status: Enabled
No. Templates Used: 43 (44 Cached / 0 Manually Loaded)
Memory Usage: 1.25 MB (1310720 bytes)
Memory Limit: 128M
Now to see what happens as I pile on a few plugins...
There should be a reduction of 2 queries per page, at least. We removed the
SET NAMES query and started caching the default theme.
Additionally with the APC cache handler that's another global query gone. We're doing pretty well performance wise.
Very sweet. Thanks for the hard work and useful happy information!
(2014-02-13, 11:32 PM)Nathan Malcolm Wrote: [ -> ]There should be a reduction of 2 queries per page, at least. We removed the SET NAMES query and started caching the default theme.
Additionally with the APC cache handler that's another global query gone. We're doing pretty well performance wise.
Yup, things are looking good. I'm not even using APC - just Zend optimizer and PHP 5.5.
(2014-02-13, 10:38 PM)Euan T Wrote: [ -> ]I haven't tested MyBB 1.8 in a while, but I installed it tongiht and there are some notable differences. First of all, index query count is down from 9 on stock to 7. Memory usage is also down from ~2MB to 1.25MB. All in all, my 1.8 install is hitting some impressive stats:
MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 21 ms
No. DB Queries: 7
PHP Processing Time: 13 ms (61.08%)
DB Processing Time: 8 ms (38.92%)
Extensions Used: mysqli, xml
Global.php Processing Time: 15 ms
PHP Version: 5.5.9
Server Load: 0
GZip Encoding Status: Enabled
No. Templates Used: 43 (44 Cached / 0 Manually Loaded)
Memory Usage: 1.25 MB (1310720 bytes)
Memory Limit: 128M
Now to see what happens as I pile on a few plugins...
hmm, PDO got a good caching system that increase speed too. Always keep a Persistent db connection though.
I really should finish off my MyBB PDO implementation...