[alerad]

On map change, I'm running 8*PlayersOnline queries, I know this is a lot and can't avoid doing it without several hours of refactoring stuff.

My problem is the following:

If I run this queries connected to a local db (Same amount of rows and stuff as the remote db), they execute pretty fast, say 1 second.

However, I need to run this queries connected to a remote-hosted DB, and that's where stuff slows down. They take up to 8 seconds, and I'm sure the problem is on the sourcemod side since I tried connecting to the DB via CLI and got 0.004s responses for the same queries.

I also get really different query time results on local db, but they are less prominent. If I run the query on CLI, they aren't a hassle at all and execute really quick.

Any idea on how to approach this?

Thanks!

[asherkin]

The result set was probably cached when you ran it manually. The only artificial limit in SM for DB stuff is that threaded queries are rate limited to 20 per second.

[alerad]

Yeah, I thought about caching, but if I execute the same query twice with sourcemod, loading time doesn't differ by much, it's still reasonably high, will keep looking into it I guess

[shanapu]

If I understand you correct, putting your 8*N queries in a transaction would speed this up.

[alerad]

Sadly, all of my queries have complex callbacks, so I think using a transaction isn't an option (Maybe i'm wrong)

[asherkin]

Oh, I didn't see that this was 8*N queries - yeah, it is probably the rate limit getting you.

[alerad]

I doubt it's solely the rate limit, when I test it with only one player, only 8 queries are executed on map start, yet they still delay quite a bit.

Also, there's no way to edit that rate other than forking and hosting my own sourcemod version right?