Board index » delphi » TADOConnection question
David Freeman
Delphi Developer |
TADOConnection question2007-05-12 01:27:32 PM delphi126 Using Delphi 7 Professional... Currently I set myadoconnection.open at the start of my program and .close at the end of the program. This means that the user has the connection open all day. I have not had any problems with this and, at least with AS/400s, this has a huge performance benefit. However, I am now using SQL Server and read that this is not the best option. I read that I should open the adoconnection before each select and close it immediately after. (I assume that the open .. close should enclose a transaction?) My question: When using SQL Server 2005, should I have the adoconnection.open only for the brief periods where it is needed? Many thanks David |