Sql updating multiple tables simultaneously

Current versions of Btrieve support system transactions and user transactions, where system transactions are a bundle of non-transactional operations and/or user transactions, whereas user transactions are transactions that work on actual data in the database.System transactions were developed to allow multiple transactions to be done in a batch and to make data recovery easier.

After some reorganization within Novell, it was decided in 1994 to spin off the product and technology to Doug and Nancy Woodward along with Ron Harris, to be developed by a new company known as Btrieve Technologies, Inc. Btrieve was modularized starting with version 6.15 and became one of two database front-ends that plugged into a standard software interface called the Micro-Kernel Database Engine.

The Btrieve front-end supported the Btrieve API and the other front-end was called Scalable SQL, a relational database product based upon the MKDE that used its own variety of Structured Query Language, otherwise known as SQL.

After gaining market share and popularity, it was acquired from Doug and Nancy Woodward by Novell in 1987, for integration into their Netware operating system in addition to continuing with the MS-DOS version.

The product gained significant market share as a database embedded in mid-market applications in addition to being embedded in every copy of Net Ware 2.x, 3.x and 4.x since it was available on every Net Ware network.

Simply including the existing state of the SET clause can result in a huger performance improvement for UPDATE statements: As more people adopt 64-bit servers with giant data buffers, we see a delay caused by the database writer process having to scan through giant data buffers seeking dirty blocks.

Many shops are replacing their platter-style disks with solid-state disks, and creating a very small data buffer, just for the updates.

Btrieve was written by Doug Woodward and Nancy Woodward and initial funding was provided in part by Doug's brother Loyd Woodward.

Around the same time as the release of the first IBM PCs, Doug received 50% of the company as a wedding gift and later purchased the remainder from his brother.

They have a committed and loyal developer-base and according to company literature, they remain fully committed to the product.


  1. Fusion101 is a 100 percent totally free dating site for finding single born again believers.

Comments are closed.