Connection pooling and Windows authentication

Hello:
I am correct that if I use Windows authentication on SQL2000 I will loose
connection pooling ?
Thanks
Terry
Not exactly; connections will not be pooled between accounts, but I believe
that if two connections are made with the exact same security credentials,
pooling will work.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Support" <RemoveThis_Support@.mail.oci.state.ga.us> wrote in message
news:%23qgxFtKzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> Hello:
> I am correct that if I use Windows authentication on SQL2000 I will loose
> connection pooling ?
> Thanks
> Terry
>

Connection pooling and Windows authentication

Hello:
I am correct that if I use Windows authentication on SQL2000 I will loose
connection pooling ?
Thanks
TerryNot exactly; connections will not be pooled between accounts, but I believe
that if two connections are made with the exact same security credentials,
pooling will work.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Support" <RemoveThis_Support@.mail.oci.state.ga.us> wrote in message
news:%23qgxFtKzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> Hello:
> I am correct that if I use Windows authentication on SQL2000 I will loose
> connection pooling ?
> Thanks
> Terry
>sqlsql

connection based temp tables

Hello

I am developing a web based webshop with a ms sql back end, but I
cannot figure out how to do connection based temp tables, so that each
user gets their own temp table to hold the purchased items.

any ideas or hints would bery much appreciated

rgds

Matt<matt@.fruitsalad.org> wrote in message
news:1126360634.762880.315890@.g43g2000cwa.googlegr oups.com...
> Hello
> I am developing a web based webshop with a ms sql back end, but I
> cannot figure out how to do connection based temp tables, so that each
> user gets their own temp table to hold the purchased items.
> any ideas or hints would bery much appreciated
> rgds
> Matt

A better idea is probably to use a single table, with a customer ID or
session ID as part of the key. That way you can store items for some time
and you don't lose any information if the connection from your middle tier
is broken for some reason. You also have an easy way to view aggregate
information for all customers/sessions, and so on.

Since normal temp tables exist per connection and you probably won't have
one new client connection per customer from the middle tier to the database,
it's doubtful if temp tables would be a good solution for you.

Simon|||Dear Matt,
You'll have a tricky time with this approach to shopping carts I think.
Whilst you can create a temp table that persists for only as long as the
connection to database exists - you'd have to keep the database connected to
the webserver permanently and once for every user of the website. This would
be packed full of problems - not least of which would be that you'd run out
of connections pretty quickly.

You've got two main options.

1) Keep the shopping cart on the webserver not in the database - this has a
lot of advantages - 1) If you're choice of scripting language manages
sessions for you (like asp.net) then you're users shopping carts will
dissapear without you having to manage the process of cleaning them up. 2)
It'd be much faster - you wouldn't have to keep hitting the database to add
something into the cart, or to pull up the cart items. 3) You wouldn't hve
to clean up the database for abandoned order (your rate might be as high as
70-80% of orders that get abandoned).

2) Keep the cart in a
"pending orders" table - and keep track of the time that each item was
added, and group the items together either by a cart id or by a customer
number - then you could automate clean up.

Nick
<matt@.fruitsalad.org> wrote in message
news:1126360634.762880.315890@.g43g2000cwa.googlegr oups.com...
> Hello
> I am developing a web based webshop with a ms sql back end, but I
> cannot figure out how to do connection based temp tables, so that each
> user gets their own temp table to hold the purchased items.
> any ideas or hints would bery much appreciated
> rgds
> Matt