Hi ,

I Am very much new to .net and as well as sybase (SQL Anywhere).
I have a .net application in which am supposed to read almost 30 huge text files onvert them to datatable and insert into sybase SQL Anywhere database table.There are a set of business rules which are needed to be applied on some of these text files while processing.
Right now am processing each and every row and validating against the business rules and inserting them which is taking very long time and effecting the performance.

What would be the better way of dealing with this scenario. As performance has become a huge constraint.


It will be great if anyone of you suggest me a better solution so that its improves the performance.

Thanks in advance.
Satish