Thread: nVault Tutorial
View Single Post
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 09-24-2016 , 12:31   Re: nVault Tutorial
Reply With Quote #92

Quote:
Originally Posted by KliPPy View Post
Yes, the number has to be a string in a query, but DB will parse your query and use it as an integer most likely. Performance should be better with an integer as a key, I think, especially in table joins (I am no expert though).
However, I don't think it will matter a lot, especially for a database of a few thousand players.
That's the point I was getting at. I agree that from a database/table design perspective the integer wins. From a plugin perspective, it doesn't matter whether it's stored as a string or integer since in the end you are still formatting it into a string query with formatex().
__________________
Bugsy is online now