Hello.
I am currently trying to implement Full-Text Search into Roblox for quick database lookups but I have a question.
How does Roblox database querying work in the back-end side?
Does Roblox create search lexemes based on the data that you are both trying to save and get? I couldn’t find if this was documented nor any statistic on how long it generally takes to search for data in large Roblox databases.
It might look like the database keys say whatever you set the key to, but I want to know if this is really true in the actual Roblox servers that they are searched from. Does Roblox translate the key somehow when the data is actually requested from their servers and the actual key itself is in lexeme form over there.
I want to know this because if I were to have a database with say 1 million different indexes, how fast would those search queries be?
If they are very slow, I would like to create Full-Text Search into Roblox so that those database lookups are quicker, because based on the data that I am searching, I would have the direct ID to search for but even if I were to do that would it all be for nothing because does Roblox automatically already do that for you in their source code?
Thank you for any help.