csv file vs database data

Posted on 2011-10-27
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.


Question by:rckrch
    LVL 33

    Accepted Solution

    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.

    Author Closing Comment

    Thanks very much for the information.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    User art_snob ( encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now