Database vs. Flat-Files

[[GMs]]

Post your opinion.

[high9]

What do you mean? They both have their own uses...

[Warlax]

***** innit, all depends on whether u need concurrent access or not :P

[~Yuki~]

Whats the difference between Flatfiles and a database?

[kinshi88]

*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 *** time.
Ugh I could go on forever!

Use a *** damned database!

[~Falcon]

Originally Posted by kinshi88

*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 *** time. Not necessarily
Ugh I could go on forever! I really do doubt that

Use a *** damned database! No thanks

Isosceles Triangle

[Warlax]

Originally Posted by kinshi88

*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 *** time.
Ugh I could go on forever!

Use a *** 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?

[ChingChong23]

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.

[Warlax]

hence different situations, different needs, different answers to the which is better question

[kinshi88]

Originally Posted by Warlax

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

[InfamousNoone]

Originally Posted by kinshi88

*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 *** 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 *** damned database!

i<3pie

[Luiz01]

Database is better.

[high9]

Derp, lets store our application configs in a database!

[DarkMessiah]

Originally Posted by high9

Derp, lets store our application configs in a database!

signed

[Warlax]

Originally Posted by DarkMessiah

signed

lol u know he was taking the **** right?