[Include] Useful Functions v1.0 (MySQL)
#10

Quote:
Originally Posted by Spookie98
Посмотреть сообщение
Calgo, we don`t think that it is a Bad Method and about the Difficulty of the INC, we made this especally for newbies, we never wanted to say that BUD or any other INC is worse than our, we said that our INC is better for someone that doesen`t know what MySQL means, but wants to learn it.
I'm not saying the idea of the include is a bad idea - I'm sure it's very useful to newbies. But you don't use the most efficient methods to save data (or to load it), which you really should if you're encouraging newbies to use it. Those who base their scripts on this will have hell in the future.

Consider using caching, threading and functions with support for multiple parameters.

Take a look at BUD - https://sampforum.blast.hk/showthread.php?tid=187720 - there's multiSet and multiGet, for roleplay servers, there's on average probably around 100-200 fields for each player, that's 200 select queries just to login, then 200 to save everything. If you made a function like multiSet or multiGet, the code would be a lot more efficient, you could reduce those queries by much more than half.
Reply


Messages In This Thread
Useful Functions v1.0 (MySQL) - by Spookie98 - 28.05.2012, 13:12
Re: Useful Functions v1.0 (MySQL) - by Hoss - 28.05.2012, 13:57
Re: Useful Functions v1.0 (MySQL) - by Shadow_ - 28.05.2012, 14:51
Re: Useful Functions v1.0 (MySQL) - by Calgon - 28.05.2012, 16:15
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 28.05.2012, 16:39
Re: Useful Functions v1.0 (MySQL) - by Calgon - 28.05.2012, 16:40
Re: Useful Functions v1.0 (MySQL) - by WaLLy.SAMP - 28.05.2012, 16:42
Re: Useful Functions v1.0 (MySQL) - by The__ - 28.05.2012, 16:45
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 28.05.2012, 16:47
Re: Useful Functions v1.0 (MySQL) - by Calgon - 29.05.2012, 08:13
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 29.05.2012, 10:06
Re: Useful Functions v1.0 (MySQL) - by Edvin - 29.05.2012, 11:04
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 29.05.2012, 11:53
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 04.06.2012, 09:50
Re: Useful Functions v1.0 (MySQL) - by Slice - 04.06.2012, 09:58
Re: Useful Functions v1.0 (MySQL) - by TheLazySloth - 04.06.2012, 11:35
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 04.06.2012, 11:40
Re: Useful Functions v1.0 (MySQL) - by Slice - 04.06.2012, 12:08
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 04.06.2012, 12:16
Re: Useful Functions v1.0 (MySQL) - by Slice - 04.06.2012, 12:20
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 04.06.2012, 12:30
Re: Useful Functions v1.0 (MySQL) - by Spookie98 - 04.06.2012, 12:35

Forum Jump:


Users browsing this thread: 1 Guest(s)