We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

insert many rows performance

Thread ID:

Created:

Updated:

Platform:

Replies:

118884 Apr 19,2015 12:38 PM Apr 23,2015 03:30 AM WPF 8
loading
Tags: SfDataGrid
Oleg
Asked On April 19, 2015 12:38 PM

Hello! 
I have a data stream in real time, which I have to display in the table. I use the insert in collection data view model, but display all hopelessly behind in realtime. The data to be displayed all at a time, you can not miss (a stream of market transactions). Please help!

Ganeshkumar Lingappan [Syncfusion]
Replied On April 20, 2015 08:54 AM

Hi Oleg,

Thank you for contacting Syncfusion support,

We have analyzed your query and we have prepared a sample for SfDataGrid with 25 Columns based on your requirement. In this Sample, we have inserted 10000 records in a Button click and here all the records getting loaded at a considerable time. we have attached the test sample, please revert us by modifying the attached sample based on your application along with the replication procedure that would be helpful for us to proceed further and resolve the issue

Please Refer the Sample in the Below mentioned Location.
Sample Link : http://www.syncfusion.com/downloads/support/forum/118884/CS-2079283653.zip
Please let us know if you require any further assistance.

Regards,
Ganesh.

Oleg
Replied On April 20, 2015 01:26 PM

Thank you for your example, I implemented it in my code, but the delay big. A lot of data, they should all display in turn. New print = insrert[0] in table. I think to do differently - to fix the size of the grid and in the mode stack data drive through it. But it is impossible, the grid is automatically extended, and it slows down the speed. I need to get a table had a constant number of rows and update all information shifted, and the first line contains new information. Help, how to implement it.

for (int i = 1; i<grid.rows.count; i++)
grid.rows[i] = grid.rows[i-1]

grid.rows[0] = new_print


Oleg
Replied On April 20, 2015 04:16 PM

i find Data Virtualization , but I can not test, please help with the example


 public class FastViewModel:NotificationObject
    {        
        GridVirtualizingCollectionView data;
        List<Tick> prints;
        public FastViewModel()
        {
            prints = new List<Tick>();
            data = new GridVirtualizingCollectionView(prints);

            Add(); Add(); Add(); it works
        }

        public GridVirtualizingCollectionView Stocks
        {
            get { return data; }
        }

        public void  Add() it does not work from an instance of an object, in what could be the reason?
        {
            Tick mm = new Tick();
            mm.Time = DateTime.Now.Ticks.ToString();
            prints.Insert(0, mm);
        }

    }

Attachment: CS20150420_57d0d3c8.zip

Ganeshkumar Lingappan [Syncfusion]
Replied On April 21, 2015 10:08 AM

Hi Oleg,

We are sorry about the inconvenience caused.

We have analyzed your query and you are using List. List is not implemented from INotifyCollectionChanged interface. So add, remove operations in the itemsource is not reflected in Grid. We have used ObservableCollection instead of List to make this work. Please find the modified sample from below location,

Sample Link : http://www.syncfusion.com/downloads/support/forum/118884/CS-1567587559.zip

Please let us know if you require further assistance

Regards,

Ganesh


Oleg
Replied On April 21, 2015 11:10 AM

This technology can not cope with the influx of data, each tick which requires the addition of a single line. What are the options for acceleration, for example, to create a static table and update directly on the key of line?
Tell me how to assign a line key and gain access to the line for this key?

Ganeshkumar Lingappan [Syncfusion]
Replied On April 22, 2015 09:46 AM

Hi Oleg,

We are regret to inform you that, we are not able to understand your requirement clearly. Please share simple sample that reproducing the reported issue otherwise share more details regarding your requirement, that would be more helpful for us to serve you better.

Regards,

Ganeshkumar


Oleg
Replied On April 22, 2015 11:20 AM

I found a solution to quickly add new rows to a table
https://peteohanlon.wordpress.com/2008/10/22/bulk-loading-in-observablecollection/

Saranya CJ [Syncfusion]
Replied On April 23, 2015 03:30 AM

Hi Oleg,

We are glad to know that you have found out solution for your issue. Please let us know if you require further assistance.

Regards,
Saranya

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;