Hi,
I have a GI that shows about 400,000 records. After I add same tables join to show first invoice of customer. The result show that data is too huge to load.
Please advise me how to fix this situation.
Best answer by sweta68
View originalERROR - Can't show all record because of huge data - Generic inquiry
Hi
Below forum link will help you.
System was not able to get record count message when running GI | Community (acumatica.com)
As per
Add filters or criteria to your GI to limit the number of records displayed initially. For example, you can filter records by date range, specific customers, or other relevant criteria. This reduces the data volume and makes it more manageable.
Regards,
Sweta
Userlevel 7
+12
Hi
Could you please share the Error screenshot and GI,
if it is related to GI count then we need to follow below suggestions
“calculate the count and display the results, the system needs to run two queries. To ensure responsiveness of the application, the Generic Inquiry system will wait for a predetermined amount of time (a few seconds). If the count of records is not returned in the allotted time, the query is canceled and the GI will only display the records.
More than likely, this means that the GI has a complex join expression or condition that requires full table scans instead of faster clustered index operations. '
1. Analysis of the SQL Query Execution plan through SQL Management Studio is recommended in such cases. In some cases it can simply be because you’re missing a field in the relationship (ex: joining by OrderNbr instead of OrderType,OrderNbr).
2. One way to optimize a Primary List is by reducing the number of fields that have "Use in quick search" enabled (highlighted)
3. Check the tables in the GI, if there are any that are not necessary we recommend removing them (obsolete tables)
4. Another, suggestion would be to enter a value for "export top" field if the client is not exporting all the values and the first few only”
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.