943,722 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Marked Solved
  • Views: 2484
  • MS SQL RSS
Dec 6th, 2008
0

file storage vs database storage

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
dips255 is offline Offline
36 posts
since Jun 2008
Dec 7th, 2008
0

Re: file storage vs database storage

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.
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 871
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004
Dec 8th, 2008
0

Re: file storage vs database storage

thanks peter_budo
i've switched to DB storage
Reputation Points: 10
Solved Threads: 0
Light Poster
dips255 is offline Offline
36 posts
since Jun 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: How to Join 2 Table
Next Thread in MS SQL Forum Timeline: Calculating each row individually





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC