I have used SSIS for migrating from Oracle to a new structure in sql server. Like it very much but for this, C# just makes sense.

I can...

Okay. Thank you everyone for your replies. 🙂

You're right, if it was smooth sailing then I wouldn't be here.

I got it to preform well. My problem was...

Ninja's_RGR'us (6/15/2011)

---

What are you doing with that file one in C#?

You could use SSIS or BCP out to dump that data into a csv or whatever and be done in...

Hmmm....

Maybe this will help for anyone who's following this...

http://www.4guysfromrolla.com/webtech/042606-1.shtml

Oh and I had to do it in chunks because this statement pukes in c# if there are too may records (know problem)

bf.Serialize(mycmp, events1);

If that worked, I would...

I have to do it this way. There is no option.

I can though change the query and ya, I think that may be where the problem lies.

I need to...

Aaaand, I have seen a lot of similar issues posted on the internet regarding this type of problem and 'parameter sniffing'. Wondering if anyone has solved this problem.

The user is not reading these records. They are being archived off and then can be brought into a temp table for the user to view and query on...

Actually, the user can pick the amount of records to select. At 100 000, makes no difference. Still slows down at the same place.

This is originally written in...

This is sql server 2008 64 bit by the way. Is this in the correct group?