vahdani
23rd November 2005, 14:21
Hi everyone!
Has anyone noticed or better solved the problem of slow queries when using Crystal XI against ERP LN and Baan IV? We need XI as this is the only version which can connent to LN.
Problem:
-A simple report (a list of countries from tcmcs010) took originally 6 Minutes to run!!! The same report in Crystal 10 takes a few secounds!
-After setting registry setting "Query Exec Mode" to 1 as suggested by Crystal Hotline the report runs for 2 Minutes the first time. subsequent refreshes take a fraction of a secound. This is still unacceptable
Has anyone noticed or better solved the problem of slow queries when using Crystal XI against ERP LN and Baan IV? We need XI as this is the only version which can connent to LN.
Problem:
-A simple report (a list of countries from tcmcs010) took originally 6 Minutes to run!!! The same report in Crystal 10 takes a few secounds!
-After setting registry setting "Query Exec Mode" to 1 as suggested by Crystal Hotline the report runs for 2 Minutes the first time. subsequent refreshes take a fraction of a secound. This is still unacceptable