AsmBB

Power
Login Register
Threads Categories Chat

Show thread by id not by slug

ganuonglachanh (ツ)

Hi johnfound,

Currently Amsbb find thread by slug, this could be a performance problem if database is huge with many links, should we extract the thread id in slug for faster searching? The problem is Asmbb current have 3 types of slug:

https://board.asm32.info/source/learning-the-asmbb-source-64/ https://board.asm32.info/asmbb/how-the-string-dispatching-is-implemented-in-asmbb.210/ https://board.asm32.info/asmbb/asmbb-how-to-download-compile-and-install_49/

And we should note about user create a tag like "asbmm.120" "install_49" "source-64"

johnfound (ツ)
ganuonglachanh

Hi johnfound,

Currently Amsbb find thread by slug, this could be a performance problem if database is huge with many links, should we extract the thread id in slug for faster searching? The problem is Asmbb current have 3 types of slug:

https://board.asm32.info/source/learning-the-asmbb-source-64/ https://board.asm32.info/asmbb/how-the-string-dispatching-is-implemented-in-asmbb.210/ https://board.asm32.info/asmbb/asmbb-how-to-download-compile-and-install_49/

And we should note about user create a tag like "asbmm.120" "install_49" "source-64"

Well, AsmBB demo site now have 2 types of slugs, because of the engine evolution. And the current database is from the version before 1.0; The latest version generates only slugs of the type "this-is-my-slug.id" because of the SEO superstitions. ;-)

The queries by the slug in the database are not slower than the queries by the ID. At least, the difference is negligible. Because SQLite actually searches in the table index, not by strings comparisons. And this applies equally to the ID field and to the slug field.

ganuonglachanh (ツ)
johnfound
ganuonglachanh

Hi johnfound,

Currently Amsbb find thread by slug, this could be a performance problem if database is huge with many links, should we extract the thread id in slug for faster searching? The problem is Asmbb current have 3 types of slug:

https://board.asm32.info/source/learning-the-asmbb-source-64/ https://board.asm32.info/asmbb/how-the-string-dispatching-is-implemented-in-asmbb.210/ https://board.asm32.info/asmbb/asmbb-how-to-download-compile-and-install_49/

And we should note about user create a tag like "asbmm.120" "install_49" "source-64"

Well, AsmBB demo site now have 2 types of slugs, because of the engine evolution. And the current database is from the version before 1.0; The latest version generates only slugs of the type "this-is-my-slug.id" because of the SEO superstitions. ;-)

The queries by the slug in the database are not slower than the queries by the ID. At least, the difference is negligible. Because SQLite actually searches in the table index, not by strings comparisons. And this applies equally to the ID field and to the slug field.

Thanks for the info, I'm building demo forum with milions threads to test the limit of AsmBB and get some optimize ideas, will test and feedback :-)

johnfound (ツ)
ganuonglachanh

Thanks for the info, I'm building demo forum with milions threads to test the limit of AsmBB and get some optimize ideas, will test and feedback :-)

It would be very helpful. I am very curious as well. The maximum database I tested was with the FlatAssembler forum database ported to AsmBB format. Something like 200000 posts by 6000 users.

©2016..2020 John Found; Licensed under EUPL; AsmBB v2.8 (check-in: 6d0d9d4bca1af5dd); SQLite v3.31.1 (check-in: 3bfa9cc97da10598); Powered by Assembly language; Created with Fresh IDE;