Best practices for relational access in Pervasive.SQL

BANGALORE, INDIA: This paper provides suggestions and tips on how to obtain optimal performance when using relational (SQL) access with Pervasive.SQL.

To get the most out of relational performance, many things must be considered, from database design through application development and deployment. We will discuss in detail the many things that play a role in overall SQL performance of Pervasive.SQL.

This paper is intended for readers that have a working knowledge of database design, SQL, data types, queries, indexes, ODBC, data sources, Windows registry, and Pervasive.SQL.

The topics discussed can be easily implemented in applications currently under development or in applications going through major revision updates.

However, some techniques may be difficult or impossible to retrofit into legacy databases or into applications that are already deployed.

Click here to know more...!