Find Jobs
Hire Freelancers

Alter and Optimize sql query

$10-30 USD

完了済み
投稿日: 10年以上前

$10-30 USD

完了時にお支払い
I need someone to please change this SQL query to NOT use sub-query with IN, I need for this query to work faster. Attached find the data table we are working with. About 7 million rows. SELECT `MovieID`, COUNT(*) AS `Count` FROM `download` WHERE `UserID` IN ( SELECT `UserID` FROM `download` WHERE `MovieID` = 995 ) GROUP BY `MovieID` ORDER BY `Count` DESC if the freelancer can solve this on the spot it would be great
プロジェクト ID: 5214866

プロジェクトについて

38個の提案
リモートプロジェクト
アクティブ 10年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hi I'm very interested helping you optimizing your sql query like I did before when we work together, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please award me the project and send me all other details about your query, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$30 USD 0日以内
4.6 (38 レビュー)
5.5
5.5
この仕事に38人のフリーランサーが、平均$22 USDで入札しています
ユーザーアバター
Hi ready to start i had more than 5 year experience in the php , mysql , jquery etc,, so let me know your view Thanks
$33 USD 3日以内
4.8 (236 レビュー)
7.6
7.6
ユーザーアバター
Hi, This is Janos from Hungary - I'd like to help. Assuming you can run teamviewer I'm quite happy to connect up and do the modification in front of you while I talk you through it on skype. Also I'm happy to take a look at indexing and see if performance can be further improved in any way - although this may be something you've already been through. thanks & regards, Janos
$34 USD 2日以内
5.0 (80 レビュー)
7.6
7.6
ユーザーアバター
Hi, I can compact this query by using inner join instead of using embedded select. But I think that the real problem is the group by and order by. The columns that u group by, order by or put after the "where" must be indexed.
$14 USD 3日以内
5.0 (21 レビュー)
6.9
6.9
ユーザーアバター
hello,Ready to start from now.i will complete this job in 1 hour..contact asap me to start wrok from now
$10 USD 1日以内
4.8 (28 レビュー)
6.3
6.3
ユーザーアバター
More then 7 years of working experience in Telerik Open Access ORM, Entity FrameWork using Code First, Database First Approaches, ASP.NET, Window Service, Web Service, MVC 3.0, MVC 4.0, C#, VB.NET, SQL Server, Access, JQUERY, Fluent/UnObtrusive and JQuery Validation. I have good experience in trouble shooting Front End issues and Performance tuning of Sql Server Database
$10 USD 0日以内
4.9 (31 レビュー)
6.4
6.4
ユーザーアバター
Hi, You may make it 2 separate queries instead of sub query. Let me know in which language it is written. Thanks.
$25 USD 0日以内
4.8 (108 レビュー)
6.1
6.1
ユーザーアバター
Hi, I can help you improved performance to your sql command. It's very easy for me to fix. Please contact me and provide me the connection, then I will edit and you see result.. All regards
$25 USD 0日以内
5.0 (12 レビュー)
5.3
5.3
ユーザーアバター
SELECT `MovieID`, COUNT(*) AS `Count` FROM `download` D1 INNER JOIN `download` D2 ON D1.`UserID` = D2.`UserID` AND D2.`MovieID` = 995 GROUP BY `MovieID` ORDER BY `Count` DESC Regards, Owner of http://sqlhint.com.
$14 USD 3日以内
5.0 (78 レビュー)
5.3
5.3
ユーザーアバター
Hello, I have experience in MySQL Query. i can try to optimize query using t.e.a.m.v.i.e.w.e.r. thanks Kalpesh
$29 USD 1日以内
5.0 (27 レビュー)
5.1
5.1
ユーザーアバター
Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://www.freelancer.com/u/nibiranijum.html I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq
$30 USD 3日以内
4.9 (18 レビュー)
5.0
5.0
ユーザーアバター
Hi, Please try if the following work better. Because you did not attached your database so I could not test it myself SELECT `MovieID`, COUNT(UserID) AS `Count` FROM `download` left join `download` `filtered_download` on `download`.`UserID` = `filtered_download`.`UserID` and `filtered_download`.`MovieID` = 995 GROUP BY `MovieID` ORDER BY `Count` DES Regards,
$20 USD 3日以内
5.0 (9 レビュー)
5.0
5.0
ユーザーアバター
Hi. Here is redundant predikate with subquery (if you didn't mistake typing your query). Ready to help you with this project. Regards, Yuri.
$25 USD 1日以内
4.9 (32 レビュー)
4.5
4.5
ユーザーアバター
Hi this is bhargava. I am expert in sql and Pl/sql . your query is ready . can you please select my bid . i am ready to provide modified query .
$15 USD 0日以内
4.9 (29 レビュー)
4.2
4.2
ユーザーアバター
Hello, I quickly tried with a revised query (without subqueries) with a few test records and got the same results. I'll send you the query if you are OK with my bid. You can accept my proposal formally only if the query gives you the same results and is faster. I could not test the speed because it won't be much different with just a few test records. Please let me know. I tried it on SQL Server (I don't have mySQL) but there should not be much difference...you can give it a try. Please let me know. Regards, Swagata
$25 USD 0日以内
5.0 (5 レビュー)
3.2
3.2
ユーザーアバター
I already have solved your query to do not use sub query. Your query is to count how many copies of each movie was downloaded by each user that had downloaded this movie before? If that is correct, than I've done already. After initial milestone releasing I send you code to you test it in your application, then after your tests if everything is alright you release final milestone.
$30 USD 1日以内
5.0 (3 レビュー)
2.5
2.5
ユーザーアバター
Hello, i am very good in mysql and sql. I can do this job with ease. I can start solving immediately. I got one solution of it. Thanks.
$11 USD 0日以内
5.0 (4 レビュー)
1.3
1.3
ユーザーアバター
Think done write now. 3 years experienced developer with C#.Net , ASP.Net, PHP, MySQL, SQL and related web technologies. Thanks
$30 USD 1日以内
0.0 (0 レビュー)
2.8
2.8
ユーザーアバター
Hi Your query needs to changes 1. you are required to create index that update on cron so that query will no more require use of count 2. use inner or left join whichever is best suite to database design in query so that query will no more require use of subquery. Thanks Hitesh
$25 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
$10 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
SELECT query1.`MovieID`, COUNT(*) AS `Count` FROM `download` AS query1 INNER JOIN FROM `download` AS query2 ON query1.`UserID` = query2.`UserID` WHERE query2.`MovieID` = 995 GROUP BY query1.`MovieID` ORDER BY `Count` DESC
$10 USD 1日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

NEW ZEALANDのフラグ
Te Awamutu, New Zealand
5.0
102
お支払い方法確認済み
メンバー登録日:9月 9, 2012

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。