When using a IQueryable dataset in my GridDataSourceAction I'm seeing a "SELECT TOP(1)" query on my large complex SQL Server view. Is there a reason why the iggrid needs to get the first row of my view and if so how can I stop it?
I can return 40,000 rows in less than a second but the TOP (1) takes multiple seconds.
Hello Dr Tone,
The reason that "Select Top(1)" query is generated could be related to the fact that your grid has Paging, AppendRowsOnDemand or AutoGenerateColumns enabled on any of the layouts. However in order to investigate this behavior further, please send me an isolated sample that reproduces the issue. Looking forward to hearing from you.
Regards,
Tsanna
JavaScript file attached.
The datasource is a very simple [GridDataSourceAction] decorated controller action.