Points of Required Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard | IRC: #abdev
Chatting Places
IRC: #kafuka | Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 4,786,923
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Calendar | Stats | Ranks | Online users | Search
01-22-18 09:34 PM
Guest: Register | Login

0 users currently in AcmlmBoard Developer Zone | 1 guest

Main - AcmlmBoard Developer Zone - Possible optimization: merging posts and poststext back
Next newer thread | Next older thread


StapleButter
Posted on 09-22-15 02:22 PM (rev. 2 of 09-22-15 02:23 PM by StapleButter) Link | ID: 87467
Developer
Acmlmboard has... side effects
Level: 69


Posts: 878/1548
EXP: 2862696
Next: 7047

Since: 01-05-12
From: France

Last post: 4 days
Last view: 2 days
Xkeeper had that idea back in 2007: http://acmlm.kafuka.org/board/thread.php?id=1364&page=1

Basically, all post data would go in one table. Old post revisions would go in a separate table, and the main posts table would only hold the latest post revisions.


Supposedly, it'd be faster. Although MySQL is pretty fast already so there isn't much difference unless your board is big.


I gave it a try on my localhost, with two tests: one with the typical posts/poststext tables, one with a separate table containing the same data but all merged together in one table (and only latest post revisions). Each test ran a full post data fetch query on 20 random posts 10000 times.

The results are the following:

* separate posts/poststext: 7.3s
* merged table: 5.7s


There isn't much gain, but it isn't negligible either.

____________________
Kuribo64 - we hack shit

Emuz
Posted on 09-22-15 02:36 PM Link | ID: 87469
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 2755/2933
EXP: 7475864
Next: 281073

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 51 min.
Last view: 9 min.
Might be worth taking on as an item. I have always wanted to merge them actually. It may be marginal improvement performance wise, it makes the database structure less muddy on top of it. Can also reduce query counts in come contexts.

The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

StapleButter
Posted on 10-06-15 11:00 PM Link | ID: 87646
Developer
Acmlmboard has... side effects
Level: 69


Posts: 892/1548
EXP: 2862696
Next: 7047

Since: 01-05-12
From: France

Last post: 4 days
Last view: 2 days
This is being tested on Kuribo64. We'll see how it goes.

____________________
Kuribo64 - we hack shit

Next newer thread | Next older thread
Main - AcmlmBoard Developer Zone - Possible optimization: merging posts and poststext back


Acmlmboard v2.5.3 (1/7/2018)
© 2005-2018 Acmlm, Emuz, et al.

Page rendered in 0.026 seconds. (673KB of memory used)
MySQL - queries: 68, rows: 520/544, time: 0.014 seconds.