flexigird

Hey guys

I have a msflexigrid to display my table. It has 6 firlds and arnd 60,000 rows. It takes quite a lot of time for it to get the table filled. around 3 - 4 minutes. I displayed the same thing in 6 ilst boxes and it came up in 15 seconds. But the problem of haveing 6 list boxes is it gives 6 scroll bars. Is there a way to display all recordsets in a single listbox. Or is there a better way of displaying my data to make it faster.

Thanx
Brat

It seems to me you need to rethink your code. 60,000 rows in a grid object is pretty much "over the top". What user would want to try to scroll through that much stuff?

Maybe you can come up with some paging method that can keep the # of rows to a reasonable number.

Another possible gotcha is the amount of memory required by the grid for that much data might cause your code to fail on some machines.