Transoft Developers

DBPronto v3.00

DBPronto v3.00 is currently in QA and will be released later this month.

One of the big enhancements is the implementation of configurable table caching.

To give you an indication of the benefits, the table below shows the time taken by a program using U/FOS data access to read 8000 records from a  U/FOS database compared with the same program reading from a SQL Server database via DBPronto with a variety of configuration options:

This demonstrates the fact that DBPronto performance can be improved using a range of configuration options which are designed to be applicable in different situations depending on the data structures used and the type of processing.

Another option is to use DBSQLCMD and DBFETCH commands to access the data using specific SQL. This can be very helpful in the very few cases where existing program logic doesn’t map well onto RDBMS data access and the problem is difficult to solve using DBPronto configuration alone.