DevForce Community Forum : Very Slow Query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Very Slow Query Wed, 29 Jul 2026 06:18:52 -700 Tue, 19 Oct 2010 17:04:55 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2232 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Very Slow Query : Hi wilcecil;A few suggestions:1.... http://www.ideablade.com/forum/forum_posts.asp?TID=2232&PID=8831#8831 Author: DenisK
Subject: 2232
Posted: 19-Oct-2010 at 5:04pm

Hi wilcecil;

A few suggestions:

1. Please check to see if the child record is being read in one by one. This can make grid loads extemely slow

2. Check with the DataGrid's vendor to see if there any recommendations on grid performance.

3. Use a paged grid so it does not display all records in one swoop.

Hope this helps.
]]> Tue, 19 Oct 2010 17:04:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2232&PID=8831#8831 Very Slow Query : Ive noticed that my query's... http://www.ideablade.com/forum/forum_posts.asp?TID=2232&PID=8798#8798 Author: wilcecil
Subject: 2232
Posted: 15-Oct-2010 at 11:08am

Ive noticed that my query's on about 1500, three Int32 with a single child table, records or so are very slow in updating to a grid... About a minute or so to paint to the grid. 
Are there query optimizations, or anything, that I am missing?

I'm using MsSQL Express 2008, SilverLight 4 and DevForce Universal 2010 Express's latest version on Windows 7 Ultimate.
]]> Fri, 15 Oct 2010 11:08:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2232&PID=8798#8798