As you know, It causes problems to show huge amount of data (some millions records) on DBGrid. Especially, when users want to go to the last record, All of records are loading into the client machine. It seems to use stored procedures to handle with this situation! Maybe paging with stored procedure! I'm currently using SQL Server 2000. And of course there are some problems more.. e.g. Users want to find any record! Can you show me your approaches about these!?