>Hi Vlad,
>
>>My grids contain a LOT of functionality, but I do not run processing of 40,000 records at once in the user interface. There are approaches and ways in database programming and building user interfaces that allow to avoid this and limit number of records with wich users work to 1000 or even less, that speed up the application. Users never need more than 1000 records at once because they just cannot work with such amount of information at once, except when need a list of items through which they process one by one. Updating of 40,000 records become updating of one or few records, if you create your database model correctly. I recommend to read some theory about databases building, specially about different normal forms and normalization of data.
>
>Refer to my code, the 40,000 records is in the maintable that I'll loop and from this many records I pick a few according to the information I want.
>I think my database is normal enough,everything is placed on its place, there is no abundant data, I think I have to optimize my code.
>

Yes, better optimize it. Instead of Scan command or Do While command that loops through all record, use such things as SELECT - SQL, UPDATE - SQL and INSERT - SQL, that work far more quickly and use indexes to do not process ALL record, but only records needed by criteria defined.

>>Code sample of one of my grids you can find in the File#9970 - a sample of the grid sortable by header click on any column. The sample created 30,000 records, then allow to sort them.
>
>Thanks for the sample, I'll look into it,anyway thanks again.
>
>regards,
>
>Budianto