Dear Support Team,
About 15 months ago a collegue created a new mvc application.
This application serves as a separate module for our main mvc application.
Due to growth of our company we had to put further development on hold.
This new mvc application is now being reviewed by me.
Main parts of this new mvc application are:
- End User Reporting
- End User Dashboard
For the End User Reporting I found out that a few different methods are used to connect to the database.
I spend today to investigate all the different ways these methods are used.
I have 1 question at this moment.
When one creates a report, you have assigned a datasource to it.
And the datasource can hace multiple data members.
I tested how the data is retrieved from our sql servers with SQL Server Profiler, and saw some 'strange' behaviour.
I have a datasource with 8 data members.
And when I use just 1 field of 1 of these data members, there are 8 queries firing on the server.
I expected just 1 query with the selection of the 1 field I used.
Then I tested the use of parameters.
The report showed correctly just 1 record, but according to SQL Server Profiler the same queries were executed.
So again all the data is retrieved.
Is this how it is supposed to work?
John van de Pol
The behavior you observe on your side is a known issue that we have already fixed in the latest version of our components. See the "SqlDataSource - Execute Required Queries" entry on the What's New in v19.1 page.
If you have any questions or concerns regarding updating your application, or ifyou'd like to know about possible solutions in the version you're using, please let us know. I'll be happy to follow up with you.