SQL Query Optimization

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

Hi SQLers!

I have a very complex SQL query for one of my programs, and I am trying to see if there is anyone who can optimize the speed. Currently, the query takes 3 minutes, and the total execution time I have to complete my processing is 5 minutes (the overall process is on a 5 minute cron job, so the SQL query takes the majority of the time).

The query is very long so I have posted it in a GIST here: [url removed, login to view]

You'll see there are a lot of "OR symbol = 'mysymbol'" WHERE clauses, and perhaps that might be the cause. I'm not sure, thats why I'm here.

I own the server, and the DB, so I'm happy to provide access to the winning bidder.

I am using Azure SQL if it matters...

Azure Microsoft Access MySQL PostgreSQL SQL

ID Проекту: #15370932

Про проект

2 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

Доручено:

TakeReal

Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I have checked your SQL. I can help you to speed up it. I need access to your Azure database to run my tests. Relevant Skills and Experience 1. " Більше

$50 USD за 1 день
(1070 відгуків(-и))
7.4

2 фрілансерів(-и) готові виконати цю роботу у середньому за $38

ZDAROB

HELLO This is the very first time I've ever made a bid on this platform. so I haven't any rewiew,therefore I 'll do my best for ur project. Hire me,and then u'll get more than u think. Relevant Skills and Experience A Більше

$25 USD за 1 день
(0 відгуків(и))
0.0