Again, I never saw a situation that requires to display millions of lines in a datagrid! You need to give criteria to user for them to retreive only what they need. I often also limit the number of records returned (select top 500 * from ...).


>Hi Eric,
>I am creating a Call Accounting application, everyday, all of phone usage (incoming & outgoing) will be saved to a table named daily .. then display to the datagrid, the table already had primarykey, and other index .. any comment? thanks
>
>Winan