When maintaining session through Sql server, what is the
impact of Read and Write operation on Session objects? will
performance degrade..

Answers were Sorted based on User's Feedback



When maintaining session through Sql server, what is the impact of Read and Write operation on Sess..

Answer / sarath

yes. performance degrades compare to inprocess.but its use
ful when information store is large and long term
maintainence.

Is This Answer Correct ?    4 Yes 1 No

When maintaining session through Sql server, what is the impact of Read and Write operation on Sess..

Answer / nanda

SQL server session Using not for Large and long term
maintaninence.

When your application is in a web farm model , then u have
two option State server and other database server option. U
can use Either SQL or ORACLE in DB option.

Is This Answer Correct ?    1 Yes 0 No

When maintaining session through Sql server, what is the impact of Read and Write operation on Sess..

Answer / guest

Yes it will make overhead to the Process to writh the data
in tyhe sql on every this

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

Difference between DataView and DataTable

4 Answers  


Does C# support static class?Is Static class be inherited by any class?

2 Answers  


Can we handle the error and redirect to some pages using web.config?

1 Answers   BirlaSoft,


what are the sitemap providers in Asp.net 2.0?

2 Answers  


What is the sequence in which ASP.NET events are processed?

0 Answers  


If 200 is for all successful operation then why do we have 201 response codes?

0 Answers  


Do you know using sql cache invalidation?

0 Answers  


What are the different types of sessions in asp.net?

0 Answers  


What is shared and private assembly?

1 Answers   Accenture,


What is an imagemap in asp.net?

0 Answers  


How do cookies work? Give an example of their abuse.

0 Answers  


What is the use of the tag in the web.config file?

0 Answers   MindCracker,


Categories