176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

mysql sql consult speed
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 19, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Feb 18, 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
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

hi! I have to speed up one sql consult that envolve two tables.
tables:
CREATE TABLE cuentas (id INTEGER AUTO_INCREMENT PRIMARY KEY,
                                         cuenta VARCHAR(50) NOT NULL UNIQUE,
                                         editable TINYINT(1) NOT NULL,
                                         lft INTEGER NOT NULL,
                                         rgt INTEGER NOT NULL) ENGINE=InnoDB;
CREATE TABLE movimientos (id INTEGER AUTO_INCREMENT PRIMARY KEY,
                                                asientoId INTEGER NOT NULL,
                                                cuentaId INTEGER NOT NULL,
                                                fecha DATE NOT NULL,
                                                debito DECIMAL(12,2) NOT NULL,
                                                credito DECIMAL(12,2) NOT NULL,
                                                FOREIGN KEY(asientoId) REFERENCES asientos(id),
                                   ...

Sign in or Register to see more

Desired Skills
MySQL Administration, SQL
Job ID: 38034454
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Greece  |  
Winner
SQL expert, database and query optimizations
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38060679  |  Submitted: Feb 19, 2013 10:49 ET 
Delivery
Within 1 day
$25.00

 India
Rich experience in SQL/Database development, performance optimization, administration in MSSQL, MySQL, Sybase ASE etc.Experience includes working...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 38056467  |  Submitted: Feb 19, 2013 09:01 ET 
Proposal SEALED

 India  |  
An enthusiast web designer-developer always excited to build better web apps. Designing: -Photoshop -HTML5 -CSS3 -Twitter Bootstrap -Responsive...
11
  |  
 5.0   |  Private   |  12 Jobs
Bid ID: 38039244  |  Submitted: Feb 19, 2013 00:41 ET 
Proposal SEALED

 United States  |  
I a skilled professional with 18 years of experience in software development and database design, development and optimization on MS SQL Server. I...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38035820  |  Submitted: Feb 18, 2013 22:52 ET 
Proposal SEALED

 Bulgaria
Programmer with 15+ years of experience. MSCD. Experienced in PHP, SQL, Flex, Flash, Actionscript, Javascript and much more.
6
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 38035603  |  Submitted: Feb 18, 2013 22:44 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 »