I’m playing around with the mysqloo module for GMod and have a few ides on how I could use it. However, some of them would require me to query the database every 20-30 seconds. I really don’t know if this would be a good idea. It seems like it could slow my server down if I’m making queries that often. Does anyone know what kind of effect this would have on my server’s performance, or some actions I can take to make doing something like this more efficient?
Depends on the size of the query. One query every 20-30 seconds won’t have any negative affects at all.
Ok. It wouldn’t be very advanced. Just check if some new stuff is added to the database and if so then run do some lua stuff. Ill probably try it out later.