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...