Bulk data import to MSSQL

I was about to upload 2 million record of data using NHibernate’s default save method, which will transact every record independently. It estimated almost 2 days to upload all data. In this mass data upload, bulk import utility, bcp is pretty useful. It takes 10 minutes for 2 million record to import. Related well written article. http://lostechies.com/jimmybogard/2010/06/24/bulk-processing-with-nhibernate/ And… Continue reading Bulk data import to MSSQL

Published
Categorised as DB

Resources for reading and writing photo meta tag like EXIF

http://social.msdn.microsoft.com/Forums/en-US/windowswic/thread/fdbcd8f4-5d75-4c33-8bed-97ef03a65c70 http://stackoverflow.com/questions/2755000/inplacebitmapmetadatawriter-trysave-returns-true-but-does-nothing http://www.andrewdothay.net/blog/2010/08/16/HowToEditMetaDataInsideJPGFilesWithC.aspx http://www.dreamincode.net/code/snippet3144.htm http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/EXIF.html http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/XMP.html#exif    

Published
Categorised as ASP.Net Tagged

C# Library for QR code

There are several c# project about QR code. Among them, http://code.google.com/p/zxing/ looks one of the best as of now. Tip 1. When reading QR code from jpg file, the image size should be relatively small. I thought that big image of QR code is better to read, but it was wrong. Small QR code image… Continue reading C# Library for QR code