>Hello Mike,
>
>So you mean to load the Policy table into a Datatable and the Transaction table into a Datatable also.(Transaction table has 2.5 million records and Policy table has 1 million record).
>
>Sergio

I think that would be better than 1 million attempts at disk access. I don't usually work with so many records... so I would say try it and see what happens.