The SQL Anywhere .NET Data Provider supports connection pooling. The documentation says: "...it checks the pool for an existing connection that uses the same connection parameters you have specified"
What means in this case same connection parameters, will the CON= parameter count too? If the application requests a new connection with a different CON parameter, but the rest is the same, will the pooled connection be reused and if so will the connection name change?
What about the APP parameter, it contains information about the executing thread will this be seen as different connection parameters, if just the calling thread is a different one?

asked 25 Jun '10, 10:55

Martin's gravatar image

Martin
8.6k119152237
accept rate: 14%


I have confirmed with the Provider team that the connection string must match exactly in order for a pooled connection to get used. As a result, the con parameter counts.

permanent link

answered 09 Jul '10, 13:17

Karim%20Khamis's gravatar image

Karim Khamis
5.6k53870
accept rate: 40%

Regarding the APP parameter Ian McHardy provided this usefull information:

The generated portion of the AppInfo string is ignored when determining if two connection strings are the same for connection pooling. If a user specified AppInfo parameter is specified, that is included in the comparison

permanent link

answered 15 Nov '11, 11:37

Martin's gravatar image

Martin
8.6k119152237
accept rate: 14%

IMHO I think that CON parameter counts too.

permanent link

answered 25 Jun '10, 11:56

Zote's gravatar image

Zote
1.7k364050
accept rate: 43%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×134
×35
×13

question asked: 25 Jun '10, 10:55

question was seen: 1,725 times

last updated: 15 Nov '11, 11:37