Hi ...
i'm using Nop 2.2....
and my database contains 20,000 products....
now i've added 15,000 more products using some(custom) stored procedures...
and entered appropriate value in particular table....
My problem is that....when i connect my old database means contains 20,000 products ....it works perfectly....
but when i connect new database means contains 35,000(20,000+15,000) products ...
suddenly SQL server taking 90 to 95% of cpu usage.....
so What could be the reason behind this....????
Thank You...