DelphiFAQ Home Search:

InterBase, MS-SQL, mysql, Oracle
C#, C++, Delphi, Java,
JavaScript, perl, php, Visual Basic, VBScript
Apache, Network, Shell
Web Publishing
JavaScript, perl CGI, VBScript, Web Hosting
Apache, File Types, Internet Explorer,
Network, Printing, Processes
Outside the Cube
Auto, Computer Hardware,
Finances, Dating Scams,
Household, Male Dating Scammers,
Other Scams, Travel

Featured Article

How much does MTS improve connect times?


I've heard MTS Pooling can improve second and subsequent connect times to
Oracle and MSSQL. Can you tell me more about the speed improvements?


In small tests the following has been measured for second a subsequent connects:

Oracle 8, MTS ON,Average Connect Time: .13 seconds
MSSQL, MTS ON, Average Connect Time: .13 seconds

Oracle 8, MTS OFF, Average Connect Time: .45 seconds
MSSQL, MTS OFF, Average Connect Time: .65 seconds

Generated 16:02:06 on Apr 8, 2020