WPF DataGrid Slow Loading during render

Question

I have a WPF DataGrid with almost 8000 Rows. It's taking approx. 25 seconds to load. Any clues how do I improve its performance?

This Grid has 3 static ButtonType Columns and other columns are dynamic. I fetch data inside a list and assign it to the ItemsSource property of the DataGrid on CodeBehind.

Here is the XAML code:

Data Loading Logic

var customerList = (from c in context.Customers
                                            where c.IsDeleted == false
                                            select new
                                            {
                                                FirstName = c.FirstName,
                                                LastName = c.LastName,
                                                Phone = c.Phone,
                                                CustomerId = c.CustomerId
                                            }).ToList();

                            DG_Details.ItemsSource = customerList;
                            DG_Details.Items.Refresh();

A thing to note here is, DataGrid's performance is great after loading. No lag at all. I am using a Core i5 machine with 4 GB RAM and 512 MB graphics card.

Please let me know if any optimizations can be done in this code.

paparazzo · Accepted Answer

DataGrid does a lot of stuff but it also has a lot of overhead.

ListView / GridView is more work but is faster.

WPF DataGrid Slow Loading during render

Answers (1)

Related Questions