You are not logged in. Please login or register.
PunBB Forums → Programming → flat file vs. database
which is better? faster? pros and cons of each.
i'm considering Limbo for my production site and it has the option of either flat file or database and i was wondering which is better and/or faster or more secure.
well a database is going to be faster as it takes time to open, write and save files whereas a database is always open, the advantage of not using a database is your host doesn't need to support a database, however it is presumably faster to read files hence caching them
got it, thank you.
oh also i think files can be read simultantiously whereas in sql the table is locked while a query is being run, this isn't going to affect you unless you have alot of hits though
I think the table is only locked if you are inserting into it or updating it, so it shouldn't be slowed down by reading. Also if your files are small enough (and they are used enough) then they will probably be kept in memory by the operating system.
similar question- db stored themes or files (currently files)...??
and does lightly loaded server versus busy one make one lean one way or the other?
for me db is better, "order by" advantage enough. easier to backup as well.
i would have thought if the data is going to be read alot more than written (by alot i mean many 1000s of times) and it only needs to be read not queried then flat files will be better, as only one query is run at once on the database
PunBB Forums → Programming → flat file vs. database
Powered by PunBB, supported by Informer Technologies, Inc.