Hello,
I'm using the GridModel.GetData method with paging to retrieve data for a table with 100million+ rows. The issue I'm noticing is that when this method is called, it also gets the total row count. The total row count seems to be the bottleneck and takes about 2-3 seconds just for the SELECT COUNT() query. I noticed that this query is also called twice, which makes it even slower.
This is definitely a database issue that is causing the query to take 2-3 seconds and I know there is not much infragistics can do about this. What I was wondering, is if there was anyway to prevent the SELECT COUNT() query from running in the first place when using the GetData method? If I could do this, then I could write my own SELECT COUNT() query that could be more efficient. I could probably also write my own GetData method, but the infragistics method already does a great job with filtering and paging and this doesn't seem worth the effort.
Any help you can provide on this is appreciated.
Thanks,
Paul
Thanks for the update. I will probably end up manually changing the Select Count logic.
Hi Paul,
I have been investigating this but it seems like GetData() method of the GridModel class cannot be overridden. Of course you can go and create your custom class that derives the GridModel class and implement a custom method, but this way you have to implement all code by yourself, but as you mentioned it does not worth the effort.
So in order to achieve your goal I suggest that you download the source code and manually change the Select Count logic inside the GetData method.