[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