MS SQL

MS SQL RSS

file storage vs database storage

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jun 2008

Posts: 25

Reputation: dips255 is an unknown quantity at this point

Solved Threads: 0

dips255

Offline

Light Poster

file storage vs database storage

Dec 6th, 2008

hi,

i need some advise regarding storage of data
is it good to store data in files rather than storing into database? (eg data like comments or additional features of products that users advertise on our website.) will it help for speed optimization.

•

Join Date: Dec 2004

Posts: 4,208

Reputation: peter_budo has much to be proud of

Solved Threads: 486

peter_budo peter_budo is offline

Offline

Code tags enforcer

Re: file storage vs database storage

Dec 7th, 2008

Of course!
Take for example simple search process to check how many people earn between 20k-25k. With file approach you need to read the file, temporary store it somewhere, close the file, you need to iterate trough to find results and then do what ever you want. Where in case of database you just write a query and check for results from DB.

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group