SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Sql Server performance issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ratheeshpatakal
Starting Member

United Arab Emirates
1 Posts

Posted - 02/04/2013 :  05:20:12  Show Profile  Reply with Quote
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.

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

Regards,
Ratheesh.



visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 02/04/2013 :  05:41:46  Show Profile  Reply with Quote
show us what you've done so far and also some sample data from your tables.
Also explain how the offers etc are stored in the system and your additional rules if any for calculations.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000