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

Affiliates
Super Mario Bros. X | Kuribo64
Views: 5,131,570
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Calendar | Stats | Ranks | Online users | Search
04-25-18 10:40 AM
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: 70


Posts: 878/1561
EXP: 2958928
Next: 56883

Since: 01-05-12
From: France

Last post: 9 days
Last view: 16 hours
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: 95


Posts: 2755/3183
EXP: 8626534
Next: 42073

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

Last post: 14 hours
Last view: 9 hours
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"
Note: if you can see this my layout broke. ALL THE CREDITS WILL BE REVEALED!!
'Victory Noriko' by @thatsheepagain.
'Chibi Dance Noriko' by @Haru__Kitsu.
'Deity's Night Out (Featuring Gabbie)'
by @thatsheepagain
Noriko Emotes by @Haru__Kitsu.
Side Bar Noriko by @thatsheepagain
'Noriko's Nature Walk' by @projectTiGER_
Emotive Noriko by @thatsheepagain.
"Space Candy Noriko" by BerryVerrine.
"Super Sharp Noriko" by Xionfes.
A gift illustration from the wonderful EverKinzPony!
"Magical Girl Noriko" by @cute_hospital!
"Patient Chibi Noriko" by @Ruii_ki!
'Dapper '60s Noriko' by @thatsheepagain.
'Shiny Chibi Noriko' by @inioli.
'Flower Veil Noriko' by @Sushiee_.
'Noriko in Realism' by @_Sarybuu.
'Noriko's Midnight Adventure' by @projectTiGER_

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


Posts: 892/1561
EXP: 2958928
Next: 56883

Since: 01-05-12
From: France

Last post: 9 days
Last view: 16 hours
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.4 (4/12/2018)
© 2005-2018 Acmlm, Emuz, et al.

Page rendered in 0.045 seconds. (592KB of memory used)
MySQL - queries: 70, rows: 455/0, time: 0.028 seconds.