Help with database types

Hello Guys i just needed to know which is the best database to use in conquer, shall i use .text files or mysql and why.
thanks for helping :)

database ofc , why ? google , i swear google works in egypt
and using database is way easier and better than using texts

Last time I checked, notepad wasn't a database type. I think you mean "flat-file database", in which case I would strongly advice against that. It doesn't scale well for servers.

i can do well in the notepad i can use datagrid view for that but whats faster in loading and makes the server lighter and faster ?

oracle :D
well mysql is your right decision. ability to cache, own procs, methods, views foreign keys and so on.

but i think it makes the server heavier and it loads so slow if many records is that right ?

No, MySQL is optimized in ways that it would be redundant to wrap up the same functionality with a flat-file database, as MySQL manages a flat-file database in their own format under the hood. Also, MySQL is heavily optimized for reads since the caller has to wait for retrieval of the data.

Mssql anyone?

Quote:

Originally Posted by Super Aids Mssql anyone?

BerkleyDB anyone?

Not really worth it for a game as small as conquer with so many static things but still a rather interesting system.

SWGEmu is using it for all of their volatile data (due to the insane update speed it offers) combined with I believe MYSQL for their accounts and other more permanent data.

Well .NET already has Mssql covered in the framework + Visual Studio with datasets = godlike to use as database management.

I prefer WordPad myself...

Quote:

Originally Posted by Korvacs I prefer WordPad myself...

[Only registered and activated users can see links. Click Here To Register...]

BerkleyDB i will check that thanks :)

Quote:

Originally Posted by hazemz BerkleyDB i will check that thanks :)

Was kinda joking... for a program as small as conquer you're best going with mssql/mysql depending on your needs and what you prefer.


The fact of the matter is that if flatfile (including text, xml and ini files) were in any way better for servers then databases would have never been invented.

They are perfectly fine for storing settings and configurations, that's what they are good for. Databases scale better as you add more users and are simply better for any sort of server app where data is being inserted, retrieved or modified regularly.