I've searched...using the wrong keywords I guess, but I get 1,200 results...in which maybe 1% are worth looking into...
How do you search just the title for keywords?
Anyways, how about I start a thread (using this) to debate the benefits of DB over file system?
I've found some articles which indicate that retreival (especially in today's RDBMS) is actually just as fast and one benchmark that suggests DB retreival is even faster!!!
Who would have thunk it...although it doesn't indicate what file system was used when compared to what DB...
http://www.cis.ksu.edu/~rpalani/MSRepor ... Server.htm
I had another from oracle that said the same thing, but did not show any benchmarks...
So other than:
- Increased security
- Possiblly faster retreival
- Tamper resistent (FTP, etc)
What are some other advantages to using a DB???
For me the only concern is retreival speed as I don't care about additional HDD consumption, etc...
I've personally ofund that images fetched from a database tend to load a helluva lot slower...I guess because each call to a fetching script would incur the cost of connecting to a DB, etc...so I'm not sure if caching would help in that case...
I wonder if those tests/benchmarks took into consideration that a web application cannot effectively capitalize on caching, etc...
Is this still redundant??? Lock it or drop it if it is...I understand...I'll take the hint and keep on searching
Edit: It just occured to me...but are images cached on the client side? Even if the HTML page is defined as NON cacheable? Does each individual file need to declare it's cacheability on the client side using
header()???
Cheers
