[FreeTDS] connection pool

Xiaobiao Yin <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <KL1PR02MB12851115455CA1AF34CFBAE4E8E30@KL1PR02MB1285.apcprd02.prod.outlook.com>
Hi Experts


    I use FreeTDS (linux) to communicate with a SQL server 2005 in Windows,

and tried to use [dbcmd() and dbsqlexec()]  100 times to insert 1 item to database tables.

   The performance is that one insert statement consumes about 2~3ms.


    I know there is a so called Connection pool, but it only support TDS 4.2 while SQL server need TDS 7.2.


   So in order to optimize the performance, I may need to open 2 or more connections, it is a little hard to

control these connections.


   My question is that are there some ways to optimize the performace.

The target should be 1ms per 1 insert statement.


Any suggetions are welcome.


Thanks

Eric
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.