Name: Performance Optimization using SQL Procedure (Caching / parallelism )
Start: 2026-09-01T17:30:00-0700
End: 2026-09-01T18:20:00-0700

You will be able to validate your attendance (Check-In to sessions) using your personal schedule.

Performance Optimization using SQL Procedure (Caching / parallelism )

Tuesday September 1, 2026 5:30pm - 6:20pm PDT

TBA

When modernizing CA 2E models to CA Plex, the same business logic can be preserved, but the execution cost can change dramatically when native RPG is replaced by Plex-generated Java. A row-by-row access pattern that was inexpensive with native IBM i I/O can become costly when every lookup becomes a JDBC round trip. This session examines a practical approach to modernizing these performance bottlenecks. We will identify repeated database access and shared computations and transform row-by-row processing into set-based SQL and stored procedures. We will also discuss alternative approaches, including caching and parallelism.

Speakers

Borys Vulgarin

CM First Group

By day, Borys supports and develops CA Plex solutions for CM First Group customers, helping organizations maintain, modernize, and enhance their mission-critical applications.

Eric Giron

CM First Group

Eric has been working with CA Plex for 17+ years developing specialized solutions for multiples companies in the Americas. He works as a Senior consultan at CMFirst as lead developer for CM MatchPoint and lead support engineer for CM MatchPoint and CM Webclient.

Tuesday September 1, 2026 5:30pm - 6:20pm PDT
TBA

Technology

Company CM First Group

15th CA 2E / CA Plex Conference

Borys Vulgarin

Eric Giron

Get help with the event

15th CA 2E / CA Plex Conference

Borys Vulgarin

Eric Giron

Sign up or log in to save this to your schedule, view media, check-in, leave feedback and see who's attending!

Get help with the event