DelphiFAQ Home Search:



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

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

How much does MTS improve connect times?

Question:

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?

Answer:

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 12:05:48 on Aug 30, 2014