|
|
Posted by Simon Hayes on 10/01/72 11:26
<matt@fruitsalad.org> wrote in message
news:1126360634.762880.315890@g43g2000cwa.googlegroups.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
Navigation:
[Reply to this message]
|