Linux Today: Linux News On Internet Time.

Borland.com: Internals of dbExpress [Kylix Data Access Layer]

Jul 19, 2000, 14:30 (2 Talkback[s])
(Other stories by Ramesh Theivendran)

[ Thanks for this link to Bob Swart, who adds: "Kylix is the codename of the Linux edition of Borland Delphi and C++Builder. For more information on Kylix, see Dr.Bob's Kylix Kicks website." ]

"dbExpress is capable of processing queries and stored procedures like the BDE (Borland Database Engine). BDE is a feature rich, bulkier client whereas dbExpress is simpler, easy to implement and best suits the MIDAS provider and resolver model."

"Database intensive applications should use queries or stored procedures to get to the data. Opening table through BDE not only consumes client resources but also locks up server resources. dbExpress eliminates the concept of opening tables, and clients are recommended to use SQL queries with better selectivity for optimized data-access."

"A statement handle for a connection must be allocated before any SQL statement can be processed. Most databases allow you to have more than one active statement per connection. On servers that don't, you may have to establish a separate connection to process multiple SQL statements simultaneously. You can also set and get statement level properties with a statement handle."

Complete Story

Related Stories: