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.
Hello Dr Tone.
We are still following your case and I was wondering did you have a chance to try Martin`s suggestion to turn off GroupBy feature off?
Please do not hesitate to contact us if you need any further assistance with this matter.
I need remote group by I'm not turning it off.
I just wanted to check something for me on your end in order to verify that the remote GroupBy is the source of the issue. I didn't want you to give up on the GroupBy feature.
Anyway, after some research we think we found the reason and will try to fix it. I logged an internal issue with number 192944 to address that.
We will keep you posted about the progress of the development.
Best regards,Martin PavlovInfragistics, Inc.
Thank you!
Your development issue has been addressed in our latest service release which is available for download.
Please let me know if you come across any further issues with the new service release or if you have any further questions.