All oDesk Jobs » Search Results » Job Facts
 oDesk Verified
Payment Method
Flag as inappropriate
MySQL DB tuning
Open
Date Posted:November 6, 2009
Planned Start Date:November 6, 2009
Type:Hourly
Main Category:Networking & Information Systems
Sub Category:DBA - Database Administration
Skills: MySQL
Hibernate
Java
more
Estimated Workload:Part-time - 10-30 hrs/week
Estimated Duration:Less than 1 week
Last Buyer Activity:November 16, 2009
Candidates: 33 - average $20.02/hr
Interviews: 5 - average $15.76/hr
 
In Progress
Start Date: 
Hourly Rate: 
Last Date Worked: 
Hired Provider: 
Hours Worked: 
Offline Hours: 
Bonuses: 
Refunds: 
Completed
End Date: 
Feedback to Provider: 
Feedback to Buyer: 
 
Buyer Facts
Member Since:December 9, 2008
Country:United States (GMT-06)
City:Dahlonega
Jobs Posted:25
Jobs Filled:19
Jobs Not Yet Filled:1
Current Team size:6
Hours billed, last 30 days:168
Total oDesk Hours:1,249.17
Feedback Score: 4.77 (10)
 

I need someone to tune and index a small database to improve on performance.  The MySQL database is small with limited records. Currently with limited records the results are slow and time consuming.

We are using hibernate to create the SQL so the SQL is dynamically generated. We use Java to pull the data from the database.

Experience with a profiling tool would be very beneficial.

Buyer's Assignment History
Provider From/To Job Title Billed Feedback
359681 07/2009 - Present Re-factor Vendor data entry screen $3,628 (233 hrs @ $15.56/hr)
37163 07/2009 - Present Re-factor Vendor data entry screen $2,495 (150 hrs @ $16.67/hr)
219245 01/2009 - Present SVN Expert to help with setu $483 (34 hrs @ $14.43/hr)
476334 10/2009 - Present Admin Work $417 (38 hrs @ $11.11/hr)
246548 11/2009 - Present Admin Work $1,022 (84 hrs @ $12.22/hr)
91229 01/2009 - 08/2009 MySQL Database work. $357 (13 hrs @ $27.78/hr)
126228 04/2009 - 07/2009 Re-factor user data entry screen $1,168 (78 hrs @ $15.00/hr)
50044 12/2008 - 06/2009 Java Programming $1,500 (fixed-price)
101727 05/2009 - 06/2009 extJS Expert with Java backend experience to refactor a Purchase Order page. $1,306 (78 hrs @ $16.67/hr)
71456 06/2009 - 06/2009 Update CSS on site $50 (fixed-price)
246548 01/2009 - 05/2009 Phone receiptionest $5,040 (510 hrs @ $9.88/hr)
47418 02/2009 - 04/2009 Improve SEO on a website $542 (29 hrs @ $18.89/hr)
71456 02/2009 - 04/2009 Front End Java Website make over $67 (fixed-price)
28422 01/2009 - 01/2009 MySQL Expert to help setup database $89 (4.00 hrs @ $22.22/hr)
133580 12/2008 - 01/2009 JSP Web site template $122 (fixed-price)
28422 01/2009 - 01/2009 Update Java based website. $111 (fixed-price)
91229 01/2009 - 01/2009 Database Tables for Accounting Applicatoin $100 (fixed-price)
117918 12/2008 - 12/2008 Create Logo $83 (fixed-price)

Candidate List
Title Name Initiated By Date
PHP/MYSQL/JAVASCRIPT/JOOMLA/AJAX/CSS/HTML/FLASH/PHOTOSHOP Pawankumar Sharma Provider November 6, 2009
PHP/MySql Developer having more than 5 yrs of exp Paramjit S. Provider November 6, 2009
Project Manager MS ASP.NET/ASP/PHP Mark Smith Provider November 6, 2009
1400+ hours in oDesk. Senior VB.NET/C#/Delphi/Oracle/MS SQL Developer Denis Sever Provider November 6, 2009
Php===Jquery====Java===Gmap===ASM Seven H. Provider November 6, 2009
Web Developer--PHP/JAVA/JSP/JS/PLSQL/ORACLE Eric S. Provider November 6, 2009
PHP/Mysql/XML/XSL/C++/DELPHI Developer Kutner Kirill Provider November 6, 2009
Software Engineer - QA-Tester, C#,ASP,ASP.Net,VB.Net,SQL Server Muddsair Sharif Provider November 6, 2009
MySQL,Smarty,PHP,MVC,Ajax,JS,CSS - for Advanced Internet Application Bimal Poudel Provider November 6, 2009
€ = UNIX/Network × Sysad/Proger² Igor P. Provider November 6, 2009
  Prem Upadhyay Provider November 6, 2009
Expert In : Linux & Unix, LAMP, Windows, Cisco, Oracle, VOIP Geraint Jones Provider November 6, 2009
● System Admin 7yrs/Highload/Linux/PHP/MySQL/DBD/DBA/System analyst Alexandr S. Provider November 6, 2009
Php/MySql Web Designer, Flash banners Eduardo M. Provider November 6, 2009
Fedora/Centos Linux developer, experienced Linux admin. Itamar Reis Peixoto Provider November 7, 2009
DBA, Network/Server Admin Web apps developer, Project Manager Danny Sinang Provider November 7, 2009
MySQL certified DBA, Expert in MYSQL performance tuning Pradeep Chandru Provider November 7, 2009
WAK Afridi. Wajid K. Provider November 7, 2009
RIA (Adobe Flex|AIR|ActionScript 3|Flash), Streaming (FMS|Red5|Wowza) Cioclea Igor Provider November 7, 2009
PHP Certified, Joomla Rockstar, Expert Web Programmer Muhammad Talal Provider November 8, 2009
Java, J2EE, Spring, Hibernate, Struts, Apache, Tomcat Ankita Khandelwal Provider November 8, 2009
JAVA, PHP Programmer/Developer Aleh S. Provider November 9, 2009
Java/J2EE Architect / Senior Developer Olexiy O. Provider November 9, 2009
Qualified Consultant and Project Manager with 10 year of experience Alessandro T. Provider November 9, 2009
Expert in C# .net, SQL, PHP/mysql Kinjal P. Provider November 10, 2009
--=== SENIOR JAVA DEV ===--- Alexey N. Provider November 10, 2009
2+ years Ruby, and RoR Development, Data Scraping, 4+ years PHP MySQL Matthew L. Provider November 10, 2009
MCITP Certified SQL Server DBA/Developer and .NET Programmer Matthew S. Provider November 13, 2009
Senior Java Developer (J2EE/Struts/Spring/Hibernate/Jsp/JSF) Shambhu Kumar Provider November 13, 2009
Technical Consultant/ Project Manager Tung Nguyen Provider November 15, 2009
Oracle DBA/Developer, MySQL DBA; technical/creative writer Christa V. Provider November 16, 2009
web development (PHP, JAVA), Database administrator, QA tester, Muhammad K. Provider November 20, 2009
Aspire Software Consultancy Aspire Software Consultancy Provider November 20, 2009

Related Trends
MySQL Administrators
Java Developers
Database Modeling Consultants
Database Modeling Consultants