looping through all of the all the users to check if there in a certain group.
#5

The fact that you are calling possibly hundreds if not thousands of queries in a few nanoseconds is quite a problem, I think you need to re-think how your system is structured. Why is there even a limit to how many people can register on your server? It's not good coding practice at all to call thousands of SQL queries in a few milliseconds, SQL is designed in a way that you should be able to call one query and get all of your information from that single query, which is far more efficient.

I've made this point time and time again, look here for an example of how you can easily get information from every single row in a table with a single query, instead of having 500 queries:

http://forum.sa-mp.com/showpost.php?...85&postcount=2
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 2 Guest(s)