Have you considered doing pagination to the datagrid, so that you only display a certain number of rows at a time?
Thanks so much for your answer that sounds like a good idea...
I found the answer to my initial problem...In my coldfusion I had set maxrows = 1000. So the datagrid was always returning 1000 records even when a lot more than that should have been returned...When I removed the maxrows parameter in the coldfusion code, my datagrid was now been populated with the correct number of rows...
thanks again for your help,
Ronnie Raigrodski (Aka -- FlexNerd)