Store/GridPanel with 17k+ rows - slow - help!

[Tbaseflug]

I have a query which returns 17k+ rows - the query itself has been optimized and executes in/around 2 seconds - but loading the grid - even with limiting the grid to 30 rows per page takes 3-5 minutes - any way to speed this up or why it is so slow?

[geoffrey.mcgill]

Loading 17000 records into the client in one request is not a good idea. I'd suggest implementing server-side paging and limit the data being returned to 30 rows.