176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Fix MySQL Slow Queries from Email Marketer by Interspire
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

Job awarded.

Feb 23, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, Feb 14, 2013
  • 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
  • Hourly Rate: $10 - $15 / hr
  • Hrs/wk: Not Sure | Duration: 3-4 weeks
  • Work View™ Payment Protection
  • U.S. freelancers must have W9
Sign in to view client's details

The Email Marketer application is taking 130-180 seconds to complete, and seems to be running every second.

Here is one of the slow queries:

MySQL Sloq Query:
# User@Host: reia[reia] @ shell1.modwest.com [204.11.245.156]
# Query_time: 197 Lock_time: 0 Rows_sent: 0 Rows_examined: 491360
SELECT
ls.emailaddress
FROM
email_jobs AS j,
email_jobs_lists AS jl,
email_list_subscribers AS ls
WHERE
j.ownerid = 1 AND
j.approved != 0 AND
j.jobtype = 'send' AND
j.jobstatus != 'c' AND
jl.jobid = j.jobid AND
ls.listid = jl.listid
GROUP BY
ls.emailaddress;

Sign in or Register to see more

Desired Skills
MySQL Administration, PHP
Job ID: 37892074
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United Kingdom  |  
BSc. Computer Science with 15 years of software development, business analysis and project management experience. Key skill set includes Business...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38012576  |  Submitted: Feb 18, 2013 10:25 ET 
Proposal SEALED

smartData Enterprises      
One or more team members at  are verified.  Learn More
 India  |  
INVITED
smartData is a business consulting organization with experience in building high end database driven applications for customers from small to...
17
  |  
 4.7   |  Private   |  291 Jobs   |  3 verified credential(s)
Bid ID: 37993984  |  Submitted: Feb 18, 2013 01:06 ET 
Proposal SEALED

 United States  |  
IDS has been developing focused, web based applications since 1994. Our forte is rapid application development. Timelines run days, not weeks or...
7
  |  
 5.0   |  $33,877 Earnings   |  6 Jobs
Bid ID: 37926826  |  Submitted: Feb 15, 2013 13:19 ET 
Proposal SEALED

 Greece  |  
SQL expert, database and query optimizations
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37923985  |  Submitted: Feb 15, 2013 11:58 ET 
Proposal SEALED

 India  |  
I am working for a leading IT company as a software Development. I am having good exprince in SQL and T-SQL. I am very good with architecture design.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37922600  |  Submitted: Feb 15, 2013 11:19 ET 
Proposal SEALED

 India  |  
Winner
We are a small business on IT Development. We have worked with clients in USA and Malaysia. We do offshore development and maintenance work. We...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37909914  |  Submitted: Feb 15, 2013 04:05 ET 
$12.50/hr

 India  |  
Three plus years of experience in software cum web development. Created real-time web applications, complex back-end management systems including...
5
  |  
 5.0   |  Private   |  5 Jobs
Bid ID: 37905228  |  Submitted: Feb 15, 2013 00:54 ET 
Proposal SEALED

 Canada
Software Developer with expertise in development large scale applications, including n-tier applications and SaaS, networking and hardware. Hands...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37903440  |  Submitted: Feb 14, 2013 23:40 ET 
Proposal SEALED

 Ukraine  |  
We are here to help you cut the cost and challenges of the web development, security auditing, supporting your hardware, network environment and...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37899228  |  Submitted: Feb 14, 2013 19:28 ET 
Proposal SEALED

 Korea, Republic of  |  
I've many experience troubleshooting to MySQL AND MySQL Performance Tuning ( Schema design, index design) AND HA for MySQL
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37897852  |  Submitted: Feb 14, 2013 18:12 ET 
Proposal SEALED

 Argentina  |  
I combine the best technologies for make powerful apps. I focus on clean design, readable code and conscientious test coverage. I'm currently...
3
  |  
 0.0   |  $1,166 Earnings   |  0 Jobs
Bid ID: 37895957  |  Submitted: Feb 14, 2013 16:45 ET 
Proposal SEALED

Eriglen Gani      
Eriglen Gani's identity has been verified.  Learn More
 Albania  |  
Experienced Oracle Administration Experienced Real Application Cluster (RAC) Experienced Relational Databases (Oracle, Sql Server, MySQL) ...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37894845  |  Submitted: Feb 14, 2013 16:02 ET 
Proposal SEALED

 Turkey  |  
We are experienced java,c#,asp.net. We developed web application and image viewing application. DICOM,IHE,HL7,PACS experts.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37893190  |  Submitted: Feb 14, 2013 15:02 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 »