I use SQL Profiler i see Transaction a lot for load one page
Why one page load used sql transaction a lot?
How to customize Used sql 1 transaction?
I'm Using NOP V2.3
Pictrue
http://www.coconutplaza.com/download/sql.png

Please tell me about How to tunning performance.
and I have 50K products