Forum Discussion

campelliann's avatar
campelliann
Post Patron
5 years ago
Solved

Csv files vs SQL server performance

Hi,    So we have a company timesheet from which we can extract Csv files with the time, costs and revenue from the projects.   My managers now want a centralized report with many of the companie...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi campelliann 

     

    If your data is all imported into the dataset, I think the performance has little difference when you viewing the report because queries are sent to the dataset which already holds the data rather than to the data sources. The performance difference will probably occur when you refresh the dataset. When refreshing data, queries are sent to data sources, so different data sources will have different connection and query durations, which leads to different refreshing time. 

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

aj1973's avatar
aj1973
Community Champion
5 years ago

Hi campelliann 

Like Anonymous said SQL is better, so it is also better to insert your data into SQL DB from the get going rather than into CSV files and then upload them to SQL.