United Arab Emirates
Posted - 02/04/2013 : 05:20:12
| Hi there,
I have some one requirement in my stored procedure please help me.
I want to calculate rates for all product.there are some scenarios to calculate.
1.I want to calculate day wise(eg:- offers applicable some
days be some days)
2.I have different offers like 1 day free or 10% discount or both etc...
3.i have to check availability of product.
4.I have to check day wise stop sale.
I want to calculate this all product rates with in 3-5 seconds.
currently it is taking 40-60 seconds.
Please help me on this.