Optimize an sql stored procedure that takes too long to run

$30-250 USD

Tamamlandı

İlan edilme:

9 yıldan fazla önce

$30-250 USD

Teslimde ödenir

I have a sql stored procedure that takes a long time to run. I need someone to help me optimize it so it runs faster. The stored procedure is part of CataLooK which is a DotNetNuke e-commerce module. I have attached the stored procedure so you can take a look at it, feel free to ask questions if you need more info about this project.

Database Administration

Proje No: 6405307

Proje hakkında

4 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 10 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@brainwithstorm

Can you please send me file so i can look at SP. I can look at your SP immediately and can probably optimize it so it runs very quickly. Thnx

$55 USD 3 gün içinde

4,9

(3 değerlendirme)

2,3

4 freelancer bu proje için ortalama $60 USD teklif veriyor

@mpalgeo

Hi I will take a look and make my proposal. Are you using any table variables ? cursors ? all these have serious drawbacks to the performance. Also we must be sure that any search in DB is been doing with the proper keys. You must attach the Procedure.

$45 USD 2 gün içinde

5,0

(1 değerlendirme)

1,0

@contact2phpsl

Hello.. !!! We have read and understood the Project Requirements of your posted Project giving attention to each and every aspect of it. I would highly Appreciate if we could discuss this in detail. I can Assure you that it will be done in a very effective way and I am a firm believer of Quality & Complete Client Satisfaction I would be waiting for a Response from you. Let me know your thoughts. We are ready to get started right away. Regards, Ritesh

$105 USD 3 gün içinde

0,0

(0 değerlendirme)

0,0

@hamzasaleem2

I am an experienced database developer and administrator. Holds experience of more than 6 years. I cannot see any attached stored procedure. Kindly give details on what issues are you facing.

$35 USD 1 gün içinde