Attention!!™
SMB3 Hacking Forum Opened!
Information needed!
If you have any useful data on hacking SMB3, please post it in the this stickied thread in the new SMB3 Forum. We are also looking for someone to help run a SMB3 hacking Wiki.
Join the Kafuka Discord! (Click here)
Views: 5,572,172
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Calendar | Stats | Ranks | Online users | Search
10-20-18 07:04 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: 72


Posts: 878/1627
EXP: 3267932
Next: 55830

Since: 01-05-12
From: France

Last post: 3 days
Last view: 19 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
obsolete advert is obsolete

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

11 Hit Combo:
Mother's Rosario
Level: 98


Posts: 2755/3280
EXP: 9365140
Next: 289213

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

Last post: 15 hours
Last view: 15 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

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


Posts: 892/1627
EXP: 3267932
Next: 55830

Since: 01-05-12
From: France

Last post: 3 days
Last view: 19 hours
This is being tested on Kuribo64. We'll see how it goes.

____________________
Kuribo64 - we hack shit
obsolete advert is obsolete

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


Acmlmboard v2.5.4 (10/13/2018)
© 2005-2018 Acmlm, Emuz, et al.

Page rendered in 0.035 seconds. (612KB of memory used)
MySQL - queries: 66, rows: 459/492, time: 0.020 seconds.