How can mysql handling can be improved?

12/13/2012 14:35 mujake#1
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)
12/13/2012 16:26 Super Aids#2
Are you sure that the problem lies in your mysql?
12/13/2012 16:38 mujake#3
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
12/13/2012 18:55 Super Aids#4
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.