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

Quote:
Originally Posted by Black Rose View Post
Not necessarily. It depends on each situation I guess but as long as you don't need the string again you're better off storing it as an int.
In this nVault situation it's better with the string.
How would you pass an integer into the query? Wouldn't the steam id always go into a SQL query string? I agree with you in the table design setting the steamid as in integer, 4 bytes would always be better than 34 bytes or whatever that is needed for a steam id string.

"SELECT * FROM tblWhatever WHERE SteamID=123123"
__________________
Bugsy is offline