LOTF Bugs

08/19/2009 23:22 _Emme_#31
Quote:
Originally Posted by _tao4229_ View Post
MySQL is actually harder to use code-wise.(Or any SQL really that I've used, which is MySQL/MSSQL and I've read code using PostgreSQL [ehhhhh])
You've obviously never handled a database alone so I can't really blame you there.
Can't really agree with that. Once you learn the basic of SQL querys, you're ready to go. All you really have to do is catch, set and close basically. Besides, textfiles are slow to parse, and MySQL IS faster than INI files, MySQL takes less space than INI files on the host, why else would serious games use SQL databases instead of INI files.

SQL > Ini ( IMO )
08/19/2009 23:36 _tao4229_#32
There's only one function you need to know to write, one for read (for strings).
With MySQL you have to worry about live connections (and the multithreaded connections, although INI files aren't thread safe themselves considering the file could be already an open handle elsewhere). Connections can be already in use, or dropped, and can't 'die' if over-spammed. In order to read a file you have to use a query to make a data reader, then query from the entry in the table. In order to read a value from an INI file, you call one function (assuming this from a C/C++ background where you can directly call a native function without having to marshal parameters etc).

Not arguing about speed, that wasn't my point. Text files are actually faster to parse if you need one thing of data at start-up than actually making a live connection and sending queries only to be closed again. The only thing that makes ini's slow at reading an entire character data is the fact that the win32 API opens and closes a file every time you call a read/write function to an ini (Write/ReadPrivateProfileString) and that it needs to parse out every string until it finds the right section/key.

My point is about using them in a program, not the speed or what you think of them, stop straying from the argument here.
To quote one of your idols (and make a point):
Quote:
Originally Posted by unknownone View Post
It's not opinion that binary files are grossly better for performance, It's hard fact. Are you trying to teach us something new? Because this is the basic of the basic.
And if you didn't know SQL database use structured binary files (structures depending on the table).
08/19/2009 23:42 InfamousNoone#33
Quote:
Originally Posted by EmmeTheCoder View Post
Can't really agree with that. Once you learn the basic of SQL querys, you're ready to go. All you really have to do is catch, set and close basically. Besides, textfiles are slow to parse, and MySQL IS faster than INI files, MySQL takes less space than INI files on the host, why else would serious games use SQL databases instead of INI files.

SQL > Ini ( IMO )
Under certain circumstances, wrong, wrong, simplicity of editing the database / web support / already build APIs.
08/19/2009 23:50 f0am#34
Quote:
Originally Posted by InfamousNoone View Post
Under certain circumstances, wrong, wrong, simplicity of editing the database / web support / already build APIs.

you rock my socks.


i like using mysql, because i dont know how to use either of them efficiently and if i use ini its going to take me long :( to convert.