Taking much time to find particular value in 64 million rows and 200 columns grid

[rohith]

Hi All,

In One of my application uses gridcontrol , i have method "Find all" which is going to find all instances of the value given as parameter .

I have 64 million rows and 200 columns .

So in order to search data i am going through 2 for loops but its taking huge time around 6 to 7 hr to complete the search.

I have to reduce the searching time .

Is there is method it will give directly row and column numbers of the data to be searched or any algorithm can be used to reduce the time of searching?

[Arulpriya Ramalingam]

Hi Rohith, 

Thanks for your interest in Syncfusion products. 

By default, using “for loop” to search data from GridControl will take more time when the Grid has many records. This is the behavior of searching text in grid. If you want to highlight the searched data, PrepareViewStyleInfo event can be used. Please make use of below code and sample 

Code snippet 

//Event triggering 

this.gridControl1.PrepareViewStyleInfo += GridControl1_PrepareViewStyleInfo; 

 

//Event customization 

private void GridControl1_PrepareViewStyleInfo(object sender, GridPrepareViewStyleInfoEventArgs e) 

{ 

    if (e.RowIndex > 0 && e.ColIndex > 0) 

    { 

        if (e.Style.Text == textBox1.Text) 

        { 

            e.Style.BackColor = Color.LightBlue; 

        } 

    } 

} 

 

 

Screenshot 

 

Sample Link: http://www.syncfusion.com/downloads/support/forum/129468/ze/Search-517998660  

Note: 

The grid has the support for find and replace the cell values. But it will also take some more time if the grid has more number of records. Please refer to the below UG for further references, 

UG Link: https://help.syncfusion.com/windowsforms/grid/find-and-replace#highlight-search-text  

 

Dash Board Sample: <Install Location> \Syncfusion\EssentialStudio[Version Number]\Windows\Edit.Windows\Samples\Interactive Features\Find and Replace 

Regards, 

Arulpriya