Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard
Chatting Places
Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 8,952,151
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
03-28-24 10:55 AM
Guest: Register | Login

0 users currently in AcmlmBoard Developer Zone | 2 bots

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


Arisotura
Posted on 09-22-15 02:22 PM, in (rev. 2 of 09-22-15 02:23 PM by Arisotura) Link | ID: 87467
Developer
pancakes
Level: 83


Posts: 878/1868
EXP: 5395274
Next: 36947

Since: 01-05-12
From: France

Last post: 654 days
Last view: 193 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 - melonDS

want some revolution in your coffee?

Emuz
Posted on 09-22-15 02:36 PM, in Link | ID: 87469
Site Administrator

11 Hit Combo:
Mother's Rosario
Level: 108


Posts: 2755/3392
EXP: 13210410
Next: 310089

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

Last post: 115 days
Last view: 10 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â„¢


"Never Knows Best"
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_
'Yukata Noriko' by @yunyunmaru_
'Birthday Wishes Noriko' by @thatsheepagain

Arisotura
Posted on 10-06-15 11:00 PM, in Link | ID: 87646
Developer
pancakes
Level: 83


Posts: 892/1868
EXP: 5395274
Next: 36947

Since: 01-05-12
From: France

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

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

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


Acmlmboard v2.5.5 (10/04/2020)
© 2005-2024 Acmlm, Emuz, et al.

Page rendered in 0.042 seconds. (765KB of memory used)
MySQL - queries: 74, rows: 494/526, time: 0.034 seconds.