Print Page | Close Window

Very Slow Query

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2232
Printed Date: 29-Jul-2026 at 6:19am


Topic: Very Slow Query
Posted By: wilcecil
Subject: Very Slow Query
Date 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.


Replies:
Posted By: DenisK
Date 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.


Print Page | Close Window