<![CDATA[PunBB Forums — flat file vs. database]]> https://punbb.informer.com/forums/topic/6035/flat-file-vs-database/ Wed, 26 Jan 2005 16:27:49 +0000 PunBB <![CDATA[Re: flat file vs. database]]> https://punbb.informer.com/forums/post/32474/#p32474 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

]]> Wed, 26 Jan 2005 16:27:49 +0000 https://punbb.informer.com/forums/post/32474/#p32474 <![CDATA[Re: flat file vs. database]]> https://punbb.informer.com/forums/post/32430/#p32430 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.

]]> Wed, 26 Jan 2005 01:59:15 +0000 https://punbb.informer.com/forums/post/32430/#p32430 <![CDATA[Re: flat file vs. database]]> https://punbb.informer.com/forums/post/32426/#p32426 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.

]]> Wed, 26 Jan 2005 00:16:28 +0000 https://punbb.informer.com/forums/post/32426/#p32426 <![CDATA[Re: flat file vs. database]]> https://punbb.informer.com/forums/post/32323/#p32323 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

]]> Tue, 25 Jan 2005 13:23:12 +0000 https://punbb.informer.com/forums/post/32323/#p32323 <![CDATA[Re: flat file vs. database]]> https://punbb.informer.com/forums/post/32296/#p32296 got it, thank you.

]]> Tue, 25 Jan 2005 08:17:06 +0000 https://punbb.informer.com/forums/post/32296/#p32296 <![CDATA[Re: flat file vs. database]]> https://punbb.informer.com/forums/post/32294/#p32294 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

]]> Tue, 25 Jan 2005 07:50:55 +0000 https://punbb.informer.com/forums/post/32294/#p32294 <![CDATA[flat file vs. database]]> https://punbb.informer.com/forums/post/32287/#p32287 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.

]]> Tue, 25 Jan 2005 06:13:35 +0000 https://punbb.informer.com/forums/post/32287/#p32287