I need some assistance please.
We use IDS 7.3 tc7 on an NT 4 platform as the main database to our manufacturing ERP system Baan. Our knowledge of Informix is very limited, and hence we need some assisitance.
We use a lot of complex ODBC linked Crystal reports in our company, and as data has built up in the Informix tables, the speed of reporting has deteriorated quite badly in some of the complexly linked reports. We have reviewed the reports and redesigned them wherever possible to get the best joins, and use of sub reports. Any future improvements in that area would be limited.
We are limited in what we can do with IDS, because the slightest change to the environment seems to upset our ERP system, and we cannot upgrade to either level 2 drivers or newer versions of Informix.
whist reading through the Crystal forum on Tek-Tips I read of people using stored procedures to improve reporting speed dramatically.
Bearing in mind our very limited knowledge of Informix, is it reasonable for us to be able to write some procedures to improve efficiency. Are there any risks involved, and can some kind soul please provide the basics to a novice on how to achieve this.
TIA
We use IDS 7.3 tc7 on an NT 4 platform as the main database to our manufacturing ERP system Baan. Our knowledge of Informix is very limited, and hence we need some assisitance.
We use a lot of complex ODBC linked Crystal reports in our company, and as data has built up in the Informix tables, the speed of reporting has deteriorated quite badly in some of the complexly linked reports. We have reviewed the reports and redesigned them wherever possible to get the best joins, and use of sub reports. Any future improvements in that area would be limited.
We are limited in what we can do with IDS, because the slightest change to the environment seems to upset our ERP system, and we cannot upgrade to either level 2 drivers or newer versions of Informix.
whist reading through the Crystal forum on Tek-Tips I read of people using stored procedures to improve reporting speed dramatically.
Bearing in mind our very limited knowledge of Informix, is it reasonable for us to be able to write some procedures to improve efficiency. Are there any risks involved, and can some kind soul please provide the basics to a novice on how to achieve this.
TIA