SQLAnywhere Performance Problem
Posted on 1998-08-05
We have an application that has been live for the past 4 months. Last month creating invoice records (getting arrears, Debits and Credits) took 5 hours to run. This month the same program took 40 Hours (Yes that is forty!!) to run. Invoice records consist of two files, header and detail. The header file contains from 4000 - 4500 records and the detail consists of 2-3 times as many records. There were no changes to any of these programs in the past month. The only thing I add were two view over the detail records to capture tax and usage records. The header record has 3 views over it and the detail has the two new views previously described. If anyone can help with this I would greatly appreciate it. if you need any more information please let me know.
Thanks for any response ahead of time!!