>First of all I started using a filter
>The table contains 0.5 million records and will grow to maybe 1 million records.

FILTERs are slow on grids, use an SQL SELECT statment, but create the cursor ahead of time and use an Alias as the recordsourcetype.