Greetings For The Day.

I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.

But inside the loop while executing ExecuteNonQuery control does not come back wait for 10 hours still not came and no error message and it happens on random rows not always for the same recrod

I am struck past 7 days i am working googled but no solution Finally i decided to firebird support team

My project is getting delayed please, help

Thanks

Sukhen Dass