Maximizing Performance with New-Look DBPs
Dr. Wojtek Rappak, first presented at CA-World 2004 in Las Vegas, May 25, 2004

This presentation will look at two important features recently introduced in Advantage Ingres DB procedures.  We can now pass a temporary table--a data set--as a DBP argument.  We can also return a set of rows through row producing procedures. These features can be used to enhance performance through set-based processing and our benchmarks show that the improvements can be dramatic. We will look at ESQL/C, OpenROAD and Java code examples showing how such DBPs can be invoked.

The presentation has 57 Microsoft PowerPoint 2000 slides, zipped to 200Kb and inflating to 469Kb.

Topics

>> Set processing delivers performance benefits
>> Previous Ingres DBPs were inadequate
>> New-style DBPs provide set-processing tools
>> Comparison with row-at-a-time processing
>> Performance benefits with new DBPs
>> ESQL/C, OpenROAD and Java code examples