Built-in SQlite vs own ORM for MySql

[garry]

Hi guys.

Could you please advice me?

I need to choice between convenience of built-in account system and corresponding functions (get/set/fetch) under SQlite

OR

Build own ORM system above mysql in order to avoid locks.

So the point is: is it enough sqlite performance for large gmode (>200 online), i scared of a lot of potential locks OR should i go from start for mysql but loose nice build-in account system?

[tosfera]

Well, it really depends on what you're doing. If you're going to use a query each time a player says something, none of the actual sql systems are going to stay up. Your only chance would be RavenDB but that's not that easy to setup, requires quite a lot of knowledge of java/c# mvc systems and no-sql databases. Take care of the amount of queries you're using and you'll be fine. Fire a query once for a login, register, and when the resource starts/stops. save the rest in tables.