I was very surprised when downloaded two imageboard php scripts. There is no connection to database, threads and posts are listed as files and folders. Is this way faster than standard mysql database connection or there is another reason?
+2
A:
Two factors lead to this. 1) The number one purpose of imageboards is to hold images, and images don't do well when stored in a database. 2) Threads in an imageboard are strictly linear, therefore a simple monotonic filename scheme suffices to distinguish them.
Ignacio Vazquez-Abrams
2010-01-19 22:59:05
so seeking file in filesystem is faster than select from database?
dfens
2010-01-19 23:03:33
It can be. Or it could be slower. It's a different *kind* of access.
Ignacio Vazquez-Abrams
2010-01-19 23:05:39