Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Conquer Online 2 > CO2 Private Server
You last visited: Today at 02:47

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



How can mysql handling can be improved?

Discussion on How can mysql handling can be improved? within the CO2 Private Server forum part of the Conquer Online 2 category.

Reply
 
Old   #1
 
mujake's Avatar
 
elite*gold: 0
Join Date: Dec 2010
Posts: 494
Received Thanks: 54
How can mysql handling can be improved?

I want to know how can mysql handling ca be improved, in order to increase performance of an source.
For example, i have an source and with 22 players online it burns about 900 Mb of RAM memory, i am thinking that is because of mysql queries that are processed for each player.
I am using an Trinity based source, most of things are working well, source itself works well it has that kill connection thing implemented,is that any good at all?
Also i am interested in improving coding style, i mean learning what coding styles to avoid and what are efficient.(I cant find that term to fit best in this sentence)
For example : in albetros are used iron python scrips for NPCs instead of trinity based ones witch are into an .cs file.(correct me if i am wrong)
mujake is offline  
Old 12/13/2012, 16:26   #2
 
Super Aids's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 1,761
Received Thanks: 950
Are you sure that the problem lies in your mysql?
Super Aids is offline  
Old 12/13/2012, 16:38   #3
 
mujake's Avatar
 
elite*gold: 0
Join Date: Dec 2010
Posts: 494
Received Thanks: 54
i am not sure, but that's not the point, it's an example...i mean i am interested in the ways that mysql and server handling can be improved
mujake is offline  
Old 12/13/2012, 18:55   #4
 
Super Aids's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 1,761
Received Thanks: 950
Uhmm I don't know. I don't use mysql, I use mssql.

Also it's hard to tell when I have no idea how your mysql handler is coded.
Super Aids is offline  
Reply


Similar Threads Similar Threads
plz help me out with handling
09/01/2012 - Need for Speed World - 4 Replies
plz any1 send me a hack with obtion handling perfect DarkTitties idk but handling is no like the others i think no work rest work thx
Packet Handling Ways
01/17/2012 - CO2 Private Server - 5 Replies
well im interested in packet and i seen alot of examples of building packets so here is some examples Heres Example of Attack Packets : 1st Example public Attack(bool Create) { if (Create) { Buffer = new byte;
Socket Handling
11/03/2011 - CO2 Private Server - 3 Replies
Well i wanna know smthing about sockets ...i wanna handle about 500 Player (As an example) how to know the max number of player that my socket can handle without getting players in my server ??
Handling Packets
10/19/2011 - CO2 Private Server - 0 Replies
well iam learning Coding using C# Tutorials but i didnt find how to handle packets ..So any1 have tutorials or guides for that i'd be appreciate
[Question]New way of packet handling?
01/26/2011 - CO2 Private Server - 16 Replies
I have been thinking, and to me it seems that a lot of the packet handlers (especially LOTF) are pretty large. Would it take up more resources to do something more dynamic such as the following? This is just an example obviously. But the main concept is there. The void would be your PacketID, the Arg1 would be your data. And it simply calls the method immediately rather then going through a case? class Program { static void Main(string args) { string...



All times are GMT +1. The time now is 02:49.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.