#10 – Learn how to Speed up Database Access

Looking for a good reason to attend DireXions 2017?  Well if you are like many other PxPlus developers and are accessing a relational database with PxPlus, then look no further.  We have one of the best reasons you can think of to attend DireXions 2017;

We can show you how to improve access performance two, three, or even tenfold through the new SQL Select logic we have added to PxPlus 2017.

The key to improving existing systems is finding ways to be more efficient in what you do.  This is at the core of one the main enhancements to our Relational Database interfaces in PxPlus 2017.

Many of our clients are moving towards or have already moved to using relational databases as their data storage method of choice.  Whether that is Microsoft SQL Server, MySQL, Oracle, or other databases, for many, external databases have become their de-facto standard for storing application information and data.

PxPlus has long provided a built-in PxPlus file emulation for relational databases that allows applications to run either our native file structure or to utilize a relational database.  PxPlus 2017 includes some significant improvements to these interfaces.

At the DireXions 2017, you will learn about how these changes drastically reduce the overhead encountered when using relational databases and how you can take advantage of them.

Two major feature improvements that we will review:

  • Enhanced SELECT WHERE processing

The SELECT directive in PxPlus provides an easy and highly flexible method of extracting data from tables and files.  The WHERE clause used to filter the resultant data was somewhat limited in that it was only able to operate AFTER the data was extracted from the table/database.

With PxPlus 2017 we have enhanced the WHERE clause processing for relational databases so that it now passes the filter to the server on the SQL SELECT statement thereby minimizing the amount of data that the server sends to the application.  This change can result in potentially HUGE reductions in data exchanges between the server and workstation and thus HUGE performance gains.

  • Selective column updates

Previously, when updating database records, all columns were being modified regardless of which columns actually changed.  This hindered performance due to the potential of having to send additional information to the servers and in some cases caused the servers to rebuild table indices unnecessarily.

PxPlus 2017 now checks which columns have actually been changed by your application and will construct more precise and better-optimized SQL statements.

Let us show you how you can tap into these new enhancements so that you can significantly improve application performance when using relational databases.

Bookmark the permalink.

Comments are closed.