AsmBB

Power
Login Register

Show thread by id not by slug
0

#16070 (ツ) ganuonglachanh
Created 22.03.2020, read: 2427 times

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"

#16071 (ツ) johnfound
Created 22.03.2020, read: 2426 times
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.

#16074 (ツ) ganuonglachanh
Created 22.03.2020, read: 2424 times
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 :-)

#16078 (ツ) johnfound
Created 22.03.2020, read: 2423 times
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.

Show thread by id not by slug
0

AsmBB v3.0 (check-in: a316dab8b98d07d9); SQLite v3.42.0 (check-in: 831d0fb2836b71c9);
©2016..2023 John Found; Licensed under EUPL. Powered by Assembly language Created with Fresh IDE