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:
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.
Created 22.03.2020 11:07:58, read: 47 times