摘要：最近处理一个将csv内容导入到sqlite数据库中，使用了事务(BEGINTRANSACTION; sql语句;COMMIT;)测试发现一次1000条导入，反而比10000条导入要快，总共6万多条数据，整下下来竟然快有6分钟，真是奇怪 var iCount = 0; var dDataTime = DateTime.Now; var mCsvHelp = new CsvHelper(); var mDataTable = mCsvHelp.GetCsvData(@"E:\", "scrm_friend"); var mSql = new StringB. 阅读全文

摘要：GMT时间转成时间戳DateTime gtm = new DateTime(1970, 1, 1); DateTime utc = DateTime.UtcNow.AddHours(8);int timeStamp = Convert.ToInt32(((TimeSpan)utc.Subtract(gtm)).TotalSeconds); 时间戳转换成时间int timeStamp = 1326332584;DateTime d = ((new DateTime(1970,1,1))).AddHours(8);d = d.AddSeconds(timeStamp ); 阅读全文