I developed a custom session state store for .Net 2.0 using PostgresSql (driver is Npgsql). The custom store run well but we face with a serious problem: PERFOMANCE.
If not using custom state, in rush hour, CPU utilization is only 10% but with the custom store, CPU utilization is about 100%. We change to use free version of Devart for Postgres, the problem is the same.
There are about 2000 request per second to our webservice from about 1000 sessions (one person can open several browser tab using our webpage). Each session store only a bool, a string and an integer in Session at session created time only.
I am using stored procedure in Postgres to interact with DB.
If I change the config file to remove custom session, the problem is solved
(
Any one using custom session store face with performance problem?
Is there any performance problem in Npgsql (I am using the latest)?
Please help!
If not using custom state, in rush hour, CPU utilization is only 10% but with the custom store, CPU utilization is about 100%. We change to use free version of Devart for Postgres, the problem is the same.
There are about 2000 request per second to our webservice from about 1000 sessions (one person can open several browser tab using our webpage). Each session store only a bool, a string and an integer in Session at session created time only.
I am using stored procedure in Postgres to interact with DB.
If I change the config file to remove custom session, the problem is solved
(Any one using custom session store face with performance problem?
Is there any performance problem in Npgsql (I am using the latest)?
Please help!