Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

csv file vs database data

Posted on 2011-10-27
2
Medium Priority
?
392 Views
Last Modified: 2012-05-12
Can anyone tell me the efficiency of retrieving data from a database vs a csv file stored in server?  Is there a difference.  I am trying to determine if it is beneficial to transfer data from a csb file to a database format.  Most of our data is in database format on servers and there is very little of our data (needed) in a csv format.

Thanks

0
Comment
Question by:rckrch
2 Comments
 
LVL 35

Accepted Solution

by:
Paul MacDonald earned 1000 total points
ID: 37038467
While it depends on what sort of database you're talking about, generally data stored in a database server product (like SQL Server) will be easier to manage and be faster to access.  Note however, that some of the benefits come from creating indexes, etc, so the database server can operate more efficiently.  Even at the low end however I would expect a database server product to be much faster than querying a CSV file.
0
 

Author Closing Comment

by:rckrch
ID: 37039279
Thanks very much for the information.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question