Hello,
i am did indexing in the Store PROCEDURE so when i am export to excel it is speed fast 2 min 3 sec
but when i deployed in production server when 12 user login then export to excel then it will take 15 min .
and 5 user is success file export but other 7 user stopped process automatically.
how can i increase the speed of my website and how can allocated session to particular user .
how can allow multiple user at same time login speed the process.
i m using membership and sqldatasoucre
Please help how can increases speed when multiple user login at same time
can i used max pool and min pool size
Vaikesh K PPosted Sep 24, 2015, 4:56 AM
You can use locks in your store procedure.
For more info on lock please refer
http://www.sqlteam.com/article/introduction-to-locking-in-sql-server
http://technet.microsoft.com/en-us/library/ms175519(v=sql.105).aspx
http://technet.microsoft.com/en-us/library/aa213039(v=sql.80).aspx