Hi,

A program is written in C that uses database. It calculates interest of 1 crore accounts and updates the tables in the database. It does lot of validations before calculating interest of an account.e..g It does not calculate interst of dormant account. This job is taking 3 days for execution. What are the alternates to improve the performance.

i. Can I write a shell script to do this job? Will be there any performance improvement?
ii. Can I write a store procedure instead of C.

Pl suggest various effectie alternatives.