GetPlayerIp weird thing
#6

Quote:
Originally Posted by Konstantinos
View Post
Sure it does. If the "Username" is not indexed and is also a text will obviously be slower searching than an indexed (primary keys are) integer.

Worth noting that any column is used in WHERE or ORDER BY must be indexed.
Well I use the mysql database for saving the Admin information, what I build is an Admin FS, I don't have any other tables and I don't need any
I use Username as Primary, so basically, I don't think it would make such difference
I would like to see your opinions about what Konstantinos offered me, since i'm pretty new to Pawn MYSQL at all
Reply


Messages In This Thread
GetPlayerIp weird thing - by NeXoR - 16.06.2016, 02:41
Re: GetPlayerIp weird thing - by oMa37 - 16.06.2016, 03:36
Re: GetPlayerIp weird thing - by Konstantinos - 16.06.2016, 11:09
Re: GetPlayerIp weird thing - by Gammix - 16.06.2016, 11:16
Re: GetPlayerIp weird thing - by Konstantinos - 16.06.2016, 11:26
Re: GetPlayerIp weird thing - by NeXoR - 17.06.2016, 02:37

Forum Jump:


Users browsing this thread: 1 Guest(s)