15.05.2014, 09:49
****** : Of course posting help request here about SQL isn't very clever, because as you've said, it's a forum about the PAWN language, but I don't see like 100 help request per day about SQL for samp elsewhere than here. Lemme explain myself : about %90 of the SQL help posted here are about SAMP, so it's not really the best place to ask, but it's not the worst place anyway.
And, as you said, "SQL Language" is redundant because SQL means "Structured Query Language".
I've made a tutorial in French on "how to optimize your queries", and it's usually a "*" problem. '*' means "all" in MySQL, selecting all the data in the table/database only to use the password (maybe the salt), and the username, it's a little bit idiot, because it's performance wasting.
Author : You're using a very old release of BlueG's plugin. Get the cache functions, it would be better for the performances.
And, as you said, "SQL Language" is redundant because SQL means "Structured Query Language".
I've made a tutorial in French on "how to optimize your queries", and it's usually a "*" problem. '*' means "all" in MySQL, selecting all the data in the table/database only to use the password (maybe the salt), and the username, it's a little bit idiot, because it's performance wasting.
Author : You're using a very old release of BlueG's plugin. Get the cache functions, it would be better for the performances.