[LambdaLambda]

Originally Posted by LambdaLambda Let's say there are 10 servers using the same database. 40 players max on each, which means 400. Around 1/4 of them would finish the stage during the same minute - database goes crazy.

Add to that queries on cmd usage (rank etc), web interface ranking queries.

It won't lag the server, but it will lag the database, which basically comes to the same output.

[ClassicGuzzi]

Originally Posted by LambdaLambda Add to that queries on cmd usage (rank etc), web interface ranking queries. It won't lag the server, but it will lag the database, which basically comes to the same output.

Yeah but a lag on the database just means that it will take longer for the callback to be called, that doesn't affect the server itself.

[LambdaLambda]

And eventually lost some queries + lost DB connection. Which will affect the server, obviously.

[m_bNightstalker]

Originally Posted by LambdaLambda And eventually lost some queries + lost DB connection. Which will affect the server, obviously.

Okey and what about stoing the stuff in a sqlite db?

[Mathias.]

You are making no sense, you just reject everything offered to you out of lazyness, why even ask for help if you going to reject everything until someone hold your hand and does it for you. You have threaded sql, adt array and other type of dynamic memory menagement offer by sourcemod, beyond that your asking for something that is not in there. Even got examples on the wiki or hundreds of them on the forum.

Wrong section, you should ask in the Plugin/Gameplay Ideas and Requests section.

Sound rude? I just got tired of your excuses.

[Potato Uno]

Originally Posted by LambdaLambda And eventually lost some queries + lost DB connection. Which will affect the server, obviously.

You would have to have an extremely shitty database and or internet connection for that to happen. And "lost queries"? Wat.

Use a local database (sqlite) if that's a problem.

[LambdaLambda]

Originally Posted by m_bNightstalker Okey and what about stoing the stuff in a sqlite db?

Thank you for that idea, however it is not way out for me, as this would be accesable only for one SRCDS. Alternatively I could make another script that would update sql database with data taken from mysql server, and update mysql on map change. That would be an idea! Howerver I will wait, maybe someone will show me another way for that.

What the fuck you mean "excuses"? Im asking about method of storing data without declaring variable's size, and I'd get an example that also requires it! Point me that lazyness, or get out.

It does make NONE sense of using threaded queries methods to retrieve details, since you can do this locally. Especially so I want to use one database shared for different locations, including US and EU, delays are obvious, transfer also cost money. Calculating rank over and over again by queries is pointless and harmful for databse performace. I see you got no idea what you're talking about, so stop being asshole, cos you ain't smartass as you're trying to show you are.

It's just exactly dumb idea to base plugin dedicated for over 400 players at once on constant database queries, as holding css or html code on your mysql server - it costs database performance, in case when you can make it without it.

[Mathias.]

at this point you make a web API or you manage your queries to be sent at certain event or time. You just get when connect and cache that info, I don't know why you try to cache the entire database on the srcds. Even if you did cache the whole database you would have merges issues when updating it.

[LambdaLambda]

I see I did not specify my idea enough clear. So here it is:

I'm running servers that are really popular (I don't wanna to share community name), currently after two months from last rank clearing, we had 140k of players, 120k of them are active players, they constantly beat their times and so and so.


I don't wanna to store all the players at once, but only records of specific map. So these are always next to, when there's such need. I also don't wanna to call insert/update queries at the map end, these will be called constantly. I don't wanna to spam with select queries, that's the reason of storing all the records for current map in variables.

I want to limit no. of queries to minimum. Our database already get ass kicked strongly. We got forum, sb, other mods and that huge database on singe DB server, which makes it really slow. Also, do have online web-interface for ranking. So to get rid of callback delays problem, I've designed my plug to keep data that are going to be in constant need, in place.

And reason of my thread is not to ask you guys for you opinion - I really know what I'm doing and I'm sure some of you would make it better. I showed you my problem, and been in curious if you someone would show me up another method of storing these.

[Mathias.]

but what exacly do y ou want to store? can you give an example? if it is database structures you should know the structures size and recreate it on server side to be able to work with ADT arrays. You are curious about how to show up another method to store data but we still have no ideas of what it is. Is it multiple structures? What are they? Do you have a need to sort?