Performance evaluation of reading/writing data from CSV and Excel in C sharp

By -
Recently I did a performance evaluation(not part of my plan) on the performance In reading CSV and Excel files and there was a clear winner. I did this test because I had to process a hell lot of data which was given to me was in excel format. I used C# as my platform to start and immediately I found some libraries such as Interop to help me out. It was pretty easy. At the beginning I used only a small portion of the data and when I started using the original files which has like thousands of records, it started to take a lot of time. So I has a preprocessing function where I write this data to a CSV file. And when I started to read from the CSV, it was very fast. Instead of taking some five minutes, now it take less than 10 seconds. I used the csvHelper lib to help me out and it was pretty easy. Even though it might be a one time execution in the production system, while you are doing the coding you might have to execute it a hundred times. So I would suggest to convert it into a CSV and then do the development.

Comments

Post a Comment

Popular posts from this blog

How To Install LEX and YACC in Linux or Ubuntu

By -
Image
To program LEX programs and yacc programs you need to install two packages in Ubuntu 1:Flex -to make the Lex program work 2.Bison -to make the yacc programs work To install,Open terminal and do the following...  1.To install Flex sudo apt-get upgrade sudo apt-get install flex 2.To install Lex sudo apt-get upgrade sudo apt-get install bison And its done ..!!!
Read more

Listing/Delisting of an article in to an Assortment in SAP SCM Retail

By -
Image
Retail companies are rarely organized along strictly uniform lines. Different stores in the same corporate group are often different sizes. Some stores have a different status (legally independent companies with the status of an external customer) while others take on different functions (wholesaling, for example). All these different parts of the same company or group must be kept up to date with changes that affect them. Stores that replenish stocks by manual inspection require up-to-date information about the articles they can carry in their assortment (for example, the merchandise category to which an article belongs or the vendor from which an article can be procured).-SAP We need to use the Tcode: WSM3 , provide the article, assortment, the validity dates and the listing procedures in the page. Now press F8/execute. The article will get listed in to the assortment.   In order to delist the article we need to go to the Tcode: WSP6 , provide the assortme...
Read more

How to Create Live Search In Html Using Ajax Ad PhP - Google Live Search / Instant Search Code And Example

By -
Image
Hi, Here Is the code and example for how to create a live search or instant search for your website.It consist of 3 parts 1.A JavaScript including Ajax 2.A Input box to enter the keywords by user 3.A Php Code to do the searching           Now , the JavaScript code is given below <script type="text/javascript"> function showResult(str) { if (str.length==0) { document.getElementById("livesearch").innerHTML=""; document.getElementById("livesearch").style.border="0px"; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("livesearch").innerHTML=xmlhttp.responseTe...
Read more