176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Need a MySQL Query(ies) Constructed
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Aug 08, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need some quick mysql queries that will be part of a cron job. I have a very large database of information (in excess of 800MM rows). Each "chunk" of data, as defined by the station id, is about 1/2 million rows. I have a procedure that copies each chunk by station id to a temporary database, then runs computations, then stores the result of that computation in a summary table.

The challenge is I have a very inefficient mysql set of queries that I believe I can reduce down to one or two queries. Looking for speed and efficiency on the query, and, most important, notes on the query so I can learn how it was done.

I have uploaded a sample table of one station (attached to this) and a describe table.


Here is what I need the MySQL query to do:
-- Limit the query by station ID (station_id)
-- Group the results by month and day - 365 unique records per station_id as a result (366 for leap year)
-- Count the number of unique years computed (database runs from 1995 to present, so sho...

Sign in or Register to see more

Job ID: 32586563
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
I am here to use Elance as a tool to market myself to those individuals and businesses that find my talent useful and my skills needy! I provide...
3
  |  
 4.7   |  Private   |  3 Jobs
Bid ID: 32733039  |  Submitted: Aug 14, 2012 13:19 ET 
Proposal SEALED

 India  |  
We are experts in databases and financial software. We have worked with the biggest investment banks in the world. We have a wealth of experience...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32686668  |  Submitted: Aug 13, 2012 02:18 ET 
Proposal SEALED

 Canada  |  
I am a seasoned web site and application developer with experience in building database driven websites and applications for customers from small...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32684044  |  Submitted: Aug 12, 2012 23:48 ET 
Proposal SEALED

 Greece  |  
SQL expert, database and query optimizations
1
  |  
 5.0   |  $440 Earnings   |  1 Jobs
Bid ID: 32658290  |  Submitted: Aug 11, 2012 08:39 ET 
Proposal SEALED

 India  |  
perl unix linux mysql oracle c c++ php management
Skills: Perl, Linux, C++
3
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 32655093  |  Submitted: Aug 11, 2012 04:03 ET 
Proposal SEALED

 India  |  
I am a programmer with 8 years of experience in Perl, SQL, Sybase, MySQL , MS SQL Server,Postgres, Unix Shell Scripting, sed/awk and Regex. I have...
6
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 32652417  |  Submitted: Aug 11, 2012 00:43 ET 
Proposal SEALED

 Russia  |  
Diligent. Motivated. Experienced. Organized. Accurate. The small team from Russia who closes projects with a thorough respect to details and...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32642458  |  Submitted: Aug 10, 2012 13:31 ET 
Proposal SEALED

 India  |  
Expertise in PHP, ASP, Mysql, Bug-fixing, API, XML, Webservices for the past 10 years on Elance alone . Completely Committed to the project and...
7
  |  
 4.9   |  $2,636 Earnings   |  11 Jobs
Bid ID: 32638494  |  Submitted: Aug 10, 2012 10:38 ET 
Proposal SEALED

 Hungary  |  
I am a programmer experienced in interfacing, GUI designing and data managing in various development environment.I worked for 4 years at the IT...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32623397  |  Submitted: Aug 9, 2012 19:45 ET 
Proposal SEALED

 New Zealand  |  
Vision: Over 20 years experience in IT, 15 of them in software development. I would be very happy to show you my skills and I am confident you...
6
  |  
 5.0   |  Private   |  7 Jobs   |  6 verified credential(s)
Bid ID: 32609082  |  Submitted: Aug 9, 2012 08:44 ET 
Proposal SEALED

 Romania  |  
I can help you, I know PHP, MYSQL, Javascript, HTML, CSS, jQuery, Java, C++/C, Oracle SQL.
3
  |  
 4.6   |  Private   |  2 Jobs
Bid ID: 32604362  |  Submitted: Aug 9, 2012 04:48 ET 
Proposal SEALED

 Russia  |  
I'm programing on C/C++, Perl scripting on Linux system.
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32603915  |  Submitted: Aug 9, 2012 04:24 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »