VO2Oracle v2.01 Released

VO2OracleT is a high performance CA-Visual Objects class library designed to simplify Oracle database connectivity issues, reduce ongoing technical support costs and dramatically improve Oracle related data processing speeds.

Release 2.01 corrects some minor errors, and adds support for CA-Visual Objects v2.5a. A free evaluation version is available from www.electricpeople.com.

Fast, Faster, Fastest...

Designed and built by one of Canada's leading software development companies, CPAS Systems Inc. and distributed by Electric People International, VO2OracleT is sure to make your Oracle SQL applications fly, retrieving and processing Oracle database activities up to 11 times faster then VO's native SQL Classes library!

Compare these results for retrieving approximately 55,000 rows (450 Mhz PII PC, 256MB RAM, Oracle 8.0.4):

VO's native SQL Classes Library: 18.2 seconds VO2Oracle: 1.6 seconds

Unlike VO's native SQL Classes library which rely on slow ODBC connections in order to communicate with SQL data, VO2OracleT talks natively to Oracle using OCI (Oracle Call Interface). This eliminates the overhead and time delays associated with using ODBC which substantailly improves application performance while at the same time providing improved program stability and reduced implementation and configuration problems.

Speed improvements are made through improved buffering and optimized use of OCI functions that otherwise are ignored by most ODBC solutions. For example, the majority of ODBC drivers use an OCI function called oFetch() to retrieve individual rows. This works fine, but limits Oracle to returning one row at a time.

VO2Oracle uses oFetch() only when appropriate and uses another function called oFen() to retrieve multiple rows simultaneously (typically up to 512 rows but, if desired, you can specify an optimimum amount on a case by case basis). For most applications, this significantly reduces both program overhead and the amount of work required by your Oracle server.

Piecewise Parameter Passing, Simplified ASynchonous Processing

VO2Oracle also includes other features that can dramatically improve processing speed. For example, VO2Oracle supports Piecewise Parameter Passing. This is the abililty to pass an array of values as a parameter to one statement. This allows Oracle to automatically execute the passed statement multiple times, once for each element in the array. This is much faster than programmatically requesting Oracle to execute modified versions of the same statement over and over again.

VO2Oracle also supports both synchronous and asynchronous communication (which dramatically simplifies batch processing activities), and also supports Oracle's RowID, allowing generic updates without a Primary Key constraint.

Simplifying Installation and Support

Anyone who has worked with ODBC knows that technical support of ODBC configurations can be a nightmare. If your programs use ODBC then you must ensure that each workstation has the correct version of ODBC installed and the correct ODBC drivers configured.

Once installation is complete the calls don't stop. Someone replaces a computer, implements new software or performs some other upgrade and suddenly your program stops working, simply because a different version of ODBC was installed or some system configuration setting was changed.

With VO2Oracle, these problems all but disappear and you need only to ensure that the required Oracle drivers are installed on the clients computer. Since your programs no longer use ODBC, you no longer care if the wrong version of an ODBC driver is installed or a configuration change affecting ODBC is made.

Supports VO 2.0, VO 2.5

VO2Oracle is shipped to you with two versions in one package, one version for use with CA-Visual Objects 2.0 and the other for use with CA-Visual Objects 2.5. Both versions are functionally identical, so if you are currently programming in VO 2.0 you easily move applications to VO 2.5 when you are ready.

VO2Oracle requires Oracle 7.3.4 or later and Oracle Client (or Personal Oracle) on individual end-user workstations. Received on Wed Mar 01 2000 - 00:00:00 CST