Devam Ediyor

SQL Query Optimization

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

Beceriler: Azure, Microsoft Access, MySQL, PostgreSQL, SQL

Daha fazlasını görün: sql optimization techniques, sql query optimization tips, query optimization techniques in sql server 2008 with example, sql query performance tuning tips, how to optimize sql query in oracle, sql query optimization tool, sql query optimization interview questions, how to optimize mysql query, sql query optimization, approach sql query optimization data mining environment, query optimization drupal, sqlite query optimization, query optimization oscommerce, project report query optimization, oscommerce database query optimization

İşveren Hakkında:
( 57 değerlendirme ) United States

Proje NO: #15370932

Seçilen:

TakeReal

Hello, My name is Sergey. I am Freelancer from [url removed, login to view], 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. " Daha fazlası

1 gün içinde 50$ USD
(1064 Değerlendirme)
7.4

2 freelancers are bidding on average $38 for this job

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 Daha fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0