Database vs. Flat-Files

03/30/2010 02:24 [GMs]#1
Post your opinion.
03/30/2010 09:11 high9#2
What do you mean? They both have their own uses...
03/30/2010 10:52 Warlax#3
lmfao innit, all depends on whether u need concurrent access or not :P
03/30/2010 22:55 ~Yuki~#4
Whats the difference between Flatfiles and a database?
03/31/2010 05:12 kinshi88#5
*Sigh*

Database storage is 1000x better than Flat-files in every way, evar.

Database queries are very fast compared to flat-file storage,
Database storage takes up WAY less space then flat-file storage,
Need to change things? Using a database would takes seconds, using flat-file would take a long ass time.
Ugh I could go on forever!

Use a god damned database!
03/31/2010 07:16 ~Falcon#6
Quote:
Originally Posted by kinshi88 View Post
*Sigh*

Database storage is 1000x better than Flat-files in every way, evar. Wrong

Database queries are very fast compared to flat-file storage, Not in all cases
Database storage takes up WAY less space then flat-file storage, Not necessarily
Need to change things? Using a database would takes seconds, using flat-file would take a long ass time. Not necessarily
Ugh I could go on forever! I really do doubt that

Use a god damned database! No thanks
Isosceles Triangle
03/31/2010 18:09 Warlax#7
Quote:
Originally Posted by kinshi88 View Post
*Sigh*

Database storage is 1000x better than Flat-files in every way, evar.

Database queries are very fast compared to flat-file storage,
Database storage takes up WAY less space then flat-file storage,
Need to change things? Using a database would takes seconds, using flat-file would take a long ass time.
Ugh I could go on forever!

Use a god damned database!
lol say im trying to store the value '5', i only need to store it at save time, i do not need to access it at any other point, except at load time, does it really make sense to use up all those extra resources having a separate database process running?
03/31/2010 18:43 ChingChong23#8
Database is good with a high amount of data. Try searching each player for a specific item in their inventory, when theres 200k users with flat-file, compared to sql.
03/31/2010 18:51 Warlax#9
hence different situations, different needs, different answers to the which is better question :)
04/01/2010 00:31 kinshi88#10
Quote:
Originally Posted by Warlax View Post
lol say im trying to store the value '5', i only need to store it at save time, i do not need to access it at any other point, except at load time, does it really make sense to use up all those extra resources having a separate database process running?
Yes
04/01/2010 01:26 InfamousNoone#11
Quote:
Originally Posted by kinshi88 View Post
*Sigh*

Database storage is 1000x better than Flat-files in every way, evar. No.

Database queries are very fast compared to flat-file storage, No.
Database storage takes up WAY less space then flat-file storage, Assuming there's no compression, then yes, sometimes.
Need to change things? Using a database would takes seconds, using flat-file would take a long ass time. No it takes seconds to -send- the query, not for it to execute. Either way it shouldn't be taking 'seconds'.
Ugh I could go on forever! Me too

Use a god damned database!
i<3pie
04/06/2010 16:45 Luiz01#12
Database is better.
04/06/2010 18:10 high9#13
Derp, lets store our application configs in a database!
04/06/2010 18:16 DarkMessiah#14
Quote:
Originally Posted by high9 View Post
Derp, lets store our application configs in a database!
signed
04/07/2010 12:29 Warlax#15
Quote:
Originally Posted by DarkMessiah View Post
signed
lol u know he was taking the piss right?