DevForce Community Forum : Slow Grid Scrolling http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Slow Grid Scrolling Wed, 10 Jun 2026 10:02:21 -700 Sat, 13 Mar 2010 04:20:18 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1682 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Slow Grid Scrolling : Thanks for your reply. It turned... http://www.ideablade.com/forum/forum_posts.asp?TID=1682&PID=6357#6357 Author: agrogers
Subject: 1682
Posted: 13-Mar-2010 at 4:20am

Thanks for your reply.  It turned out to be an issue related to running the application through Visual Studio.  We had tried both debug and release version but it didnt make any difference.  But when we launched the application from outside VS the scrolling work correctly and smoothly.

What caught us up was that sighting all records in some grids resulted in good scrolling and sighting all records in other grids made no difference.  Still dont know why that is but it is a good 'fix'.

Thanks for the performance tuning link.

Cheers
Andrew
]]> Sat, 13 Mar 2010 04:20:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1682&PID=6357#6357 Slow Grid Scrolling : The usual reason for poor grid... http://www.ideablade.com/forum/forum_posts.asp?TID=1682&PID=6354#6354 Author: IdeaBlade
Subject: 1682
Posted: 12-Mar-2010 at 10:20am

The usual reason for poor grid performance is indeed supplementary trips to the database to retrieve entities referenced in navigation properties which are not already in the cache. I'm not sure what might be causing your performance problems with the grid where you've already viewed the rows and therefore (presumably) already retrieved the related entities.
 
However, the solution to the standard problem may also solve your non-standard one: that being, to preload the data you're going to need (using a span query) before displaying the grid.  See, for example, the section "Span Queries" in the Object Persistence chapter in the Developers Guide.  There is also material in the Performance Tips powerpoint file in the Learning Units at
 
     LearningUnits\300 Advanced\Performance Tuning a DevForce App\01 Slides
]]> Fri, 12 Mar 2010 10:20:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1682&PID=6354#6354 Slow Grid Scrolling : HelloWe found that a number of... http://www.ideablade.com/forum/forum_posts.asp?TID=1682&PID=6346#6346 Author: agrogers
Subject: 1682
Posted: 11-Mar-2010 at 5:51am

Hello

We found that a number of our DevEx 2009.2 grids were scrolling quite slowly and so began investigating the issue.  It became clear fairly quickly that once records in the grid had been viewed that section of the grid would then scroll very efficiently.  The data had of course been loaded into the cache.

However we have other grids where, even though we have viewed every record in the grid, the slowness of scrolling that grid remains.  Scrolling speed is returned to normal when I group by the columns that are joined to other tables so that only simple columns are shown in grid.  That suggests that the problem is with the grid traversing the entity graph to get other data.  But that doesnt make sense since it should already have that data in the cache and so it should be real fast.

Does anyone have any thoughts?

Thanks
Andrew
]]> Thu, 11 Mar 2010 05:51:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1682&PID=6346#6346