[MySQL] SQLID vs Name Checking

[MySQL] SQLID vs Name Checking - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MySQL] SQLID vs Name Checking (/showthread.php?tid=281755)

[MySQL] SQLID vs Name Checking - wups - 07.09.2011

Do I gain much speed, when checking by SqlID (WHERE ID = %i), instead of (WHERE NAME = '%s')?

Re: [MySQL] SQLID vs Name Checking - Vince - 07.09.2011

I don't think so, except if you need to get the name every time you execute a query, as opposed to the sqlid that's already stored in a variable. I myself prefer the sqlid method though, pure for my convenience.

Re: [MySQL] SQLID vs Name Checking - wups - 07.09.2011

Yeah, I tested it.

pawn Код:

SELECT BENCHMARK(100000000,(SELECT `Name` FROM Accounts WHERE `Name` = 'SomeName' LIMIT 1));
SELECT BENCHMARK(100000000,(SELECT `Name` FROM Accounts WHERE `ID` = '1024' LIMIT 1));

pawn Код:

[SQL] 
SELECT BENCHMARK(100000000,(SELECT `Name` FROM Accounts WHERE `Name` = 'SomeName' LIMIT 1));
Affected rows: 0
Time: 4.055ms

[SQL] 
SELECT BENCHMARK(100000000,(SELECT `Name` FROM Accounts WHERE `ID` = '1024' LIMIT 1));
Affected rows: 0
Time: 4.077ms