Flex2SQL Indexes in the Backend

[fa icon="calendar'] Feb 25, 2008 5:57:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

When you add a segment to table with our drivers there is a representation of those in the backend (MS SQL, Oracle, MySQL and PostgreSQL).

Read More [fa icon="long-arrow-right"]

Some Flex2SQL Assumptions

[fa icon="calendar'] Feb 25, 2008 5:12:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

This is common list of assumptions we have for all drivers:

1. Indexed columns are created as NOT NULL and should have a default value assigned to.

2. Tables are created with the table names with uppercase letters in Flex2SQL, ORAFlex and DB2Flex.

Read More [fa icon="long-arrow-right"]

MySQL License Terms

[fa icon="calendar'] Feb 25, 2008 4:27:00 PM / by Mertech Data Systems, Inc. posted in Databases

MySQL has two different types of licensing agreements.


Open Source license (GNU) and the other more applicable to developers is their Commercial license. Below are excerpts from the MySQL documentation.


NOTE: Since Mertech’s drivers are not open source; anyone using our drivers along with MySQL must purchase a Commercial license.

Read More [fa icon="long-arrow-right"]

User Information from MySQL

[fa icon="calendar'] Feb 25, 2008 3:50:00 PM / by Mertech Data Systems, Inc. posted in Databases

This example returns user information from MySQL:

Read More [fa icon="long-arrow-right"]

Using StatsPack to monitor Oracle performance

[fa icon="calendar'] Feb 25, 2008 3:43:00 PM / by Mertech Data Systems, Inc. posted in Databases

StatsPack is an Oracle package for monitoring performance statistics.

Read More [fa icon="long-arrow-right"]

Rollback Segment Size in Oracle

[fa icon="calendar'] Feb 25, 2008 3:42:00 PM / by Mertech Data Systems, Inc. posted in Databases

Rollback segment size refers to needing an accurate minimum number of bytes required by the rollback segment for any single given transaction or for the most important of these. There are differences between the kind of transactions (INSERTS, UPDATES and DELETES). 

Read More [fa icon="long-arrow-right"]

Results Cache in Oracle

[fa icon="calendar'] Feb 25, 2008 3:41:00 PM / by Mertech Data Systems, Inc. posted in Databases

Oracle 11g has a new hint telling data to persist in cache for x number of minutes.


The syntax is:

Read More [fa icon="long-arrow-right"]

Database Object Fragmentation in Oracle

[fa icon="calendar'] Feb 25, 2008 3:40:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

If a table or index becomes fragmented (not continuous on disk) performance can decrease. You can see which objects have over 10 extents with:

Read More [fa icon="long-arrow-right"]

Query Access Plan in Oracle

[fa icon="calendar'] Feb 25, 2008 3:09:00 PM / by Mertech Data Systems, Inc. posted in Databases

A lot of developers use embedded SQL, or other tools to access their data. If a query is not optimized it can cause problems.

Read More [fa icon="long-arrow-right"]

Simplified Memory Management in Oracle

[fa icon="calendar'] Feb 25, 2008 2:53:00 PM / by Mertech Data Systems, Inc. posted in Databases

In Oracle 11g we have the memory_max_target parameter which governs the total maximum RAM for both the PGA and SGA regions and the new memory_target parameter which governs the existing sizes. This allows RAM to be de-allocated from the SGA and transferred to the PGA.

Read More [fa icon="long-arrow-right"]

Subscribe to Email Updates