View source for IBX.MtsPool Sample

__TOC__

This sample shows the use of object pooling. The application measures the amount of time needed to open and close a database connection a number of times. The "MTS Pooling checkbox" enables and disables the database objects pooling. There is a difference in elapsed time when running the test with and without MTS Pooling enabled.

This sample requires InterBase to be installed on the machine or to connect to a remote server. Make sure that the server is running before you run the example. 

==Location==

You can find the '''MtsPool''' project at:
* {{SamplesMenu}} and then navigate to either:
** '''Object Pascal\DataBase\IBX\MtsPool'''
** '''CPP\Database\IBX\mstPool'''
* '''Subversion Repository:'''
** You can find Delphi and C++ code samples in {{CodeSamplesRepositories}}. Search by name into the samples repositories according to your RAD Studio version.

==Description==

This sample shows the elapsed time for a defined number of consecutive connections to a database. Enabling the '''MTS Pooling''' sets the "MTS POOLING" Registry key to '''TRUE''' in [HKEY_LOCAL_MACHINE\Software\Borland\Database Engine\Settings\SYSTEM\INIT].

==How to Use the Sample==

# Navigate to the location given above and open:
#* {{Delphi}}: '''mtspool.dproj'''
#* C++: '''mstpool.cbproj'''
# Press '''F9''' or choose {{menu | Run &gt; Run}}. 
# Edit '''Open/Close Count''' with the number of connections you want to test. 
# Select '''MTS Pooling''' to activate the setting.
# Click '''Test Pooling''' to start and stop the timer in order to calculate the elapsed time.

==Files==

{| border="1" frame="hsides" rules="rows" frame="hsides" rules="rows"
! ''' File in {{Delphi}}
! ''' File in C++
! ''' Contains '''
|-
| align="left" valign="top" |
'''mtspool.dproj'''
| align="left" valign="top" |
'''mstpool.cbproj'''
| align="left" valign="top" |
The project itself.
|- 
| align="left" valign="top" |
'''Pooling.pas/dfm'''
| align="left" valign="top" |
'''Pooling.cpp/dfm'''
| align="left" valign="top" |
The main form and the code to turn on the MTS Pooling setting.
|-
| align="left" valign="top" |
'''mtspool_Icon.ico'''
| align="left" valign="top" |

| align="left" valign="top" |
The favicon of the application.
|-
| align="left" valign="top" |
'''Readme.html''' 
| align="left" valign="top" |

| align="left" valign="top" |
Basic information about this sample.
|}

==Implementation==

This sample implements a method to turn on the MTS Pooling setting when selecting the '''MTS Pooling''' option.

It uses [[lib_en:IBX.IBDatabase.TIBDatabase | TIBDatabase]]  to specify the database. In this case: {{DataSamplesPath}}\EMPLOYEE.GDB. The location to the database is specified in the '''DatabaseName''' property.

It uses [[lib_en:IBX.IBQuery.TIBQuery | TIBQuery]] to define the SQL Query. Right-clicking on the visual component and click '''Edit SQL''' to open the '''CommandText Editor''' where the SQL sentence is defined.

==Uses==

* [[lib_en:IBX.IBDatabase.TIBTransaction | IBX.IBDatabase.TIBTransaction]]
* [[lib_en:IBX.IBDatabase.TIBDatabase | IBX.IBDatabase.TIBDatabase]] 
* [[lib_en:IBX.IBQuery.TIBQuery | IBX.IBQuery.TIBQuery]]

==See Also==
* [[rad_en:Getting Started with InterBase Express | Getting Started with InterBase Express]]
* [[rad_en:View Various Tables (IBX General Tutorial) | View Various Tables (IBX General Tutorial)]]
* [[rad_en:Add a Data Module (IBX General Tutorial) | Add a Data Module (IBX General Tutorial)]]
* [[rad_en:Add Database Components (IBX No Code Tutorial) | Add Database Components (IBX No Code Tutorial)]]
* [[IBX.AdminTool Sample]]
* [[IBX.IBMastApp Sample]]

[[Category:C++]]
[[Category:Delphi]]
[[Category:Sample]]
[[Category:XE6]]