Logical Dbase Performance
hi fellow programmers..
i developed a payroll program which work fine at the development server..
upon transport to QAS server..i noticed that the program is not performing well when dealing with large number of data..
i also tried running it with minimal data(2K records) at qas server and works fine since i applied most of the performance tunning guide...
is there any way to prevent this?when i debug it i found out that for 1-3k records the program is doing well, but upon reaching 4k records above, the program is running slow.
my plan is to divide the data by 2k so that from start of execution to finish, the program will run fast...
any other approach?or any suggestions?
thanks for reading..