Performance - ListGrid - "Finding all records that match your criteria"

[mayankrjain]

Hello,

I have built a fairly complex app -- 100% atop SmartGWT. Thank you for all the great work you guys are doing.

The app passed dev testing well. Now we went ahead and put some serious data onto the system (~100K rows in tables etc - dev tests were arond ~100 rows only) -- and the List Grids now take a very long time to fully load.

The displayed portion of the grid (10 or so rows) get populated pretty fast but the prompt "Finding all records that match your criteria" stays put for a long time (~30sec).

Can you please advise on what I could to do optimize this? We are using SmartGWT 1.7 with MySQL as the database.

Thank you.

Mayank

[Isomorphic]

Start with the basics: where is the time being spent?

The RPC tab will show you the total server turnaround time, and server-side logs will show you which server-side operations are taking time.

The most likely explanation here is that you have done something to disable data paging.