|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
I upgraded a client to the latest version of Kartris last week and started to get problems with Admin/_Default.aspx taking ages to load (the admin page). I have tracked this down to a long execution time for queries made against vKartrisProductsVersions. In this case the calls were being made from [_spKartrisDB_GetTaskList].
It's not an issue with the queries, they themselves are fine. What I have found is that if you request all columns from the view it returns very quickly, if you request just V_ID then it hangs up. You also get a delay when trying a Count(*). The problem is the execution plan that SQL Server 2008R2 was producing. I have resolved this with appending OPTION (FORCE ORDER) to the two calls to vKartrisProductsVersions from inside [_spKartrisDB_GetTaskList].
Hopefully this helps anyone else who has the same problem.
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|