ElevateDB 2.28 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The breaking changes and new features for the ElevateDB VCL/LCL, DAC, and PHP products are below. In addition, this release contains several bug fixes, which are detailed here.

2.28 Breaking Changes for VCL/LCL Products

---

The following are breaking changes in 2.28:

• Large file support is now enabled by default in ElevateDB. Along with this change, the TEDBEngine LargeFileSupport and TEDBSession LocalLargeFileSupport properties have been removed.
  
  These are published properties, so please be sure to open, ignore any warnings about these properties being absent, and re-save any forms or data modules that use the TEDBEngine or TEDBSession components to ensure that you do not see any runtime missing property errors in your application(s).
  
  
   If you are using local ElevateDB sessions to directly access shared databases on a file server, you need to make sure that all client applications that are accessing the data are either updated to 2.28 or have their pre-2.28 TDBISAMEngine LargeFileSupport and/or LocalLargeFileSupport properties set to True. Failure to do so can cause the local ElevateDB sessions to not see each other's locks, which can lead to database corruption.



• The TEDBEngine ExclusiveFileAccess property has been removed and replaced with the TEDBEngine BufferedFileIO property. Please see the new features in 2.28 section below for more information on the new buffered file I/O functionality in ElevateDB.

2.28 New Features for VCL/LCL Products

---

The following are the new features in 2.28:

• ElevateDB now includes new global buffered file I/O functionality. There are new TEDBEngine BufferedFileIO, BufferedFileIOSettings, and BufferedFileIOFlushInterval properties for configuring the buffered file I/O in the engine. Please see the Buffering and Caching topic in the SQL manual for more information.



• ElevateDB now includes new SQL statement and function/procedure caching functionality. There are new TEDBSession SQLStmtCacheSize and FuncProcCacheSize properties for configuring the caching, as well as the TEDBSession FreeCachedSQLStmts and FreeCachedFuncProcs methods for freeing cached SQL statements and functions/procedures. Please see the Buffering and Caching topic in the SQL manual for more information.



• There are two new system information tables, the FileIOStatistics table, and the SessionStatistics Table table.



• There is a new CURRENT_SESSIONID function for returning the current session ID in SQL/PSM routines.

2.28 Breaking Changes for DAC Products

---

The following are breaking changes in 2.28:

• Large file support is now enabled by default in ElevateDB. Along with this change, the LARGEFILESUPPORT connection attribute has been removed.
  
  
   If you are using local ElevateDB sessions to directly access shared databases on a file server, you need to make sure that all client applications that are accessing the data are either updated to 2.28 or have their pre-2.28 LARGEFILESUPPORT connection attributes set to True. Failure to do so can cause the local ElevateDB sessions to not see each other's locks, which can lead to database corruption.

2.28 New Features for DAC Products

---

The following are the new features in 2.28:

• ElevateDB now includes new global buffered file I/O functionality. Please see the Buffering and Caching topic in the SQL manual for more information.



• ElevateDB now includes new SQL statement and function/procedure caching functionality. There are new STMTCACHESIZE and PROCCACHESIZE connection attributes for configuring the caching, as well as the EDBConnection FreeCachedStatements and FreeCachedProcedures methods for freeing cached SQL statements and functions/procedures in the ElevateDB .NET Data Provider (there are no equivalents for the ElevateDB ODBC Driver. Please see the Buffering and Caching topic in the SQL manual for more information.



• There are two new system information tables, the FileIOStatistics table, and the SessionStatistics Table table.



• There is a new CURRENT_SESSIONID function for returning the current session ID in SQL/PSM routines.

2.28 Breaking Changes for PHP Products

---

The following are breaking changes in 2.28:

• Large file support is now enabled by default in ElevateDB. Along with this change, the LARGEFILESUPPORT connection attribute has been removed.
  
  
   If you are using local ElevateDB sessions to directly access shared databases on a file server, you need to make sure that all client applications that are accessing the data are either updated to 2.28 or have their pre-2.28 LARGEFILESUPPORT connection attributes set to True. Failure to do so can cause the local ElevateDB sessions to not see each other's locks, which can lead to database corruption.

2.28 New Features for PHP Products

---

The following are the new features in 2.28:

• ElevateDB now includes new global buffered file I/O functionality. Please see the Buffering and Caching topic in the SQL manual for more information.



• ElevateDB now includes new SQL statement and function/procedure caching functionality. There are new STMTCACHESIZE and PROCCACHESIZE connection attributes for configuring the caching, as well as the edb_freecachedstmts and edb_freecachedprocs functions for freeing cached SQL statements and functions/procedures. Please see the Buffering and Caching topic in the SQL manual for more information.



• There are two new system information tables, the FileIOStatistics table, and the SessionStatistics Table table.



• There is a new CURRENT_SESSIONID function for returning the current session ID in SQL/PSM routines.

---

Tags: ElevateDB, New Releases

Permanent Link

Comments (0)	You must be logged in to comment