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

cr8 2 datatables into one dataset DYNAMICALLY (no backend database used like sql,etc.,) with following columns 1st datatable with columns studentNo studentName Deptno 2nd datatable with columns Deptno DeptName DeptAddress add data to both the tables Dynamically and merge these tables into one table and display it in Grid view as studentNo studentName Deptno DeptName DeptAddress

1 Answers   SQL Star,


Explain what are delegates?

0 Answers  


Which methods validate all the controls on a page?

0 Answers  


What is a web api? Which protocol is used in a web api?

0 Answers  


which scripting is used browser by server when we use validation controls. 1.javascript 2.vbscript 3.jscript 4.perl

8 Answers   Satyam,






difference between Trace and Debug ?

2 Answers   Accenture, HCL, Patni,


can sn.exe can be used before gacutil.exe

2 Answers   Accenture,


What is the sequence of operation takes place when a page is loaded ?

1 Answers  


Describe a bubbled event and how it is used ?

0 Answers   Siebel,


What are session state modes in asp.net?

0 Answers  


What is the maximum amount of memory any single process on windows can address?

0 Answers  


What is the use of data set in asp.net?

0 Answers  


Categories