Canada Presentations

Several delivered processes run for a long time simply because the calculations they do are complex. In PeopleSoft Campus Solutions, this includes Tuition Calc, FA Term and Credit History. One option is to submit the same process multiple times with different run control parameters so that they process in parallel.

Since the often issue millions of SQL statements, little can be done to improve performance because the SQL are all very efficient. However, it is sometimes possible to run them in parallel to increase throughput. With modern hardware, it is often possible to run 20 or more in parallel. So, if a full tuition calc takes 20 hours to process. Running 20 parallel processes should run in about an hour. Running 50 in parallel and it could run in under ½ hour. Unfortunately, building and maintaining the run controls is a often difficult task.

In this session, you’ll learn how to create App Engines that build the run controls automatically to make the job simple. For scheduling, you schedule the one app engine and it does the rest.