Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-250561 - Search Screen - Enabling the 'Show Totals' check box is requesting the same set of query twice in SQ|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-250561]
Search Screen - Enabling the 'Show Totals' check box is requesting the same set of query twice in SQL
Steps:
# Go to MFG -> Inventory View
# It will load the Search screen with data
# Once the data is loaded, Click the 'Show Totals'
# It takes more time to fetch the data with totals for 6 quantity columns.
# Actually it is requesting the same set of queries twice in sql server
!pastedImage_d143700_0.png|height=505,width=1210!
Issue Explanation:
# There are totally 6 columns which should show the total in that first Search tab
# Currently Framework is constructing 6 individual queries to fetch the total data for those 6 columns in SQL server
# Enabled the SQL Server Profiler and verified the query
# Instead of 6 queries to fetch the total data for those 6 columns, it is requesting 12 queries in the sql server
# Basically it is requesting the same set of queries twice in sql server
!pastedImage_d143700_1.png|height=503,width=1275!
Expectation:
* It should make only 6 individual queries to fetch the total data for those 6 columns in SQL server. Basically it should not make the same request multiple times in sql server
FYI: The same issue happened in all the search screens when you enable 'Show Totals'
|