使用sql server模式进行asp.net会话。

时间:2023-01-16 09:29:49

I am using a ASP.net session in SQL Server mode. I have created the necessary tables and stored procs in a custome db

我正在SQL Server模式下使用ASP.net会话。我已经创建了必要的表,并在custome db中存储了procs

My question is: Can I use this database to serve more than one application / web site ? Is there anything to take into consideration having multiple websites use the same db for their session store

我的问题是:我可以使用这个数据库来服务多个应用程序/网站吗?是否需要考虑让多个网站在他们的会话存储中使用相同的db

cheers

干杯

2 个解决方案

#1


2  

Yes you can use this database to server more than one site. The session provider will take care of the semantics of that.

是的,您可以使用这个数据库来服务多个站点。会话提供程序将负责它的语义。

#2


1  

It would make the profiling more difficult if there is a performance problem. Why not create a second state db for the second application? It's not much to do, simple with a different name and specify the different db in your session configuration.

如果存在性能问题,将使分析更加困难。为什么不为第二个应用程序创建第二个状态db ?这没什么可做的,只需使用不同的名称并在会话配置中指定不同的db即可。

The short answer though is you can use the same session database and each session should be fine, though I wonder if anyone has any comments on colliding sessionIds between the two applications.

简短的回答是,您可以使用相同的会话数据库,每个会话都应该没问题,尽管我想知道是否有人对两个应用程序之间的会话冲突有任何意见。

#1


2  

Yes you can use this database to server more than one site. The session provider will take care of the semantics of that.

是的,您可以使用这个数据库来服务多个站点。会话提供程序将负责它的语义。

#2


1  

It would make the profiling more difficult if there is a performance problem. Why not create a second state db for the second application? It's not much to do, simple with a different name and specify the different db in your session configuration.

如果存在性能问题,将使分析更加困难。为什么不为第二个应用程序创建第二个状态db ?这没什么可做的,只需使用不同的名称并在会话配置中指定不同的db即可。

The short answer though is you can use the same session database and each session should be fine, though I wonder if anyone has any comments on colliding sessionIds between the two applications.

简短的回答是,您可以使用相同的会话数据库,每个会话都应该没问题,尽管我想知道是否有人对两个应用程序之间的会话冲突有任何意见。