New Posts New Posts RSS Feed: Very Slow Query
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Very Slow Query
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
wilcecil View Drop Down
Newbie
Newbie


Joined: 15-Oct-2010
Posts: 1 		Post Options Post Options   Quote wilcecil Quote  Post ReplyReply Direct Link To This Post Topic: Very Slow Query
    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.
Back to Top
DenisK View Drop Down
IdeaBlade
IdeaBlade


Joined: 25-Aug-2010
Posts: 715 		Post Options Post Options   Quote DenisK Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down