Alter and Optimize sql query

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

Hi ready to start i had more than 5 year experience in the php , mysql , jquery etc,, so let me know your view Thanks

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

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.

hello,Ready to start from now.i will complete this job in 1 hour..contact asap me to start wrok from now

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

Hi, You may make it 2 separate queries instead of sub query. Let me know in which language it is written. Thanks.

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

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.

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

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

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,

Hi. Here is redundant predikate with subquery (if you didn't mistake typing your query). Ready to help you with this project. Regards, Yuri.

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 .

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

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.

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.

Think done write now. 3 years experienced developer with C#.Net , ASP.Net, PHP, MySQL, SQL and related web technologies. Thanks

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

A proposal has not yet been provided

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