With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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