How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
(See all)
Not-to-hard Perl project
By bootymcnugget on Jul 30
Max Bid: $25


Scan Files Database
By CFC on Jul 30
Max Bid: Open to fair suggestions


Complete Customized Auction Site
By rc_baker on Jul 30
Max Bid: Open to fair suggestions


Online Store Project
By Kaspuur on Jul 30
Max Bid: Open to fair suggestions


Build installation package for current application
By kpalmer on Jul 30
Max Bid: Open to fair suggestions


Company Logo
By seanne1 on Jul 30
Max Bid: Open to fair suggestions

(Screen Shot)

Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(163 open)
   Access 
(62 open)
   MySQL 
(92 open)
   Oracle 
(12 open)
   SQL Server 
(74 open)
   Other DB 
(24 open)
Documentation / Tech Writing 
(28 open)
   Language (Human) Translations 
(3 open)
Data Entry 
(22 open)
Game Development 
(21 open)
Graphics / Art / Music 
(69 open)
   Graphics 
(79 open)
     Adobe AfterEffects 
(8 open)
     Adobe Photoshop 
(34 open)
     Adobe Premiere 
(5 open)
     3d Animation 
(13 open)
   Art (Misc.) 
(28 open)
   Music 
(14 open)
   Photography 
(4 open)
   3d Modeling 
(8 open)
Language Specific 
(120 open)
   ASP 
(67 open)
   ASP .NET 
(50 open)
   C# 
(44 open)
   C++ / C 
(143 open)
   Carbon (Mac OS) 
(3 open)
   Cocoa / Obj-C 
(2 open)
   Cold Fusion 
(14 open)
   Delphi 
(52 open)
   Java 
(75 open)
   JSP 
(11 open)
   Perl 
(37 open)
   PHP 
(89 open)
   XML/XSL 
(37 open)
   Visual Basic 
(151 open)
   Visual Basic .Net 
(81 open)
   Other 
(69 open)
Misc 
(32 open)
   CAD 
(3 open)
MultiMedia 
(36 open)
   Video Editing 
(7 open)
Network 
(46 open)
   Network Design 
(10 open)
   Network Implementation 
(17 open)
Platforms 
(68 open)
   Windows 
(178 open)
     MS Exchange 
(6 open)
     MS Office 
(19 open)
     Other 
(8 open)
   Internet Browser 
(42 open)
   Linux 
(57 open)
   UNIX 
(26 open)
   Hand Held/PDA Programming 
(12 open)
Requirements 
(14 open)
Security 
(39 open)
Testing / Quality Assurance 
(18 open)
Web 
(178 open)
   Page Design 
(95 open)
   Flash 
(54 open)
   Web Services 
(75 open)
   Web (Other) 
(73 open)
Training 
(14 open)
   Computer Based 
(10 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

JDBC/mySQL performance problem
Bid Request Id: 72728
Bookmark in my 'To Do' list
Posted by: demosfen (2 ratings)
(Software buyer rating 10)
Non-action Ratio: Above Average - 33.33%
Buyer Security Verifications: Good
Approved on: Jul 11, 2003
11:46:51 PM EDT
Bidding Closes: Jul 25, 2003
11:17:51 PM EDT
Viewed (by coders): 203 times
Deadline: 7/22/2003 1:41:45 PM
(10 days after 7/12/2003 1:41:45 PM)
Phase:
100% of work was accepted by buyer. Coder account has been credited.
Max Accepted Bid: Bidding is closed
Project Type: Very Small Business Project: under $100 (USD)
Bidding Type: Open Auction
Categories: Database, Java, MySQL
Enter chat room for this bid request
(2 active users at Jul 30, 2003 7:38:38 PM EDT)

Description:
I have some Java code that reads 40000 records from tab-delimited file and inserts/update into mySQL database. It's very slow - takes many hours to execute. The delay appears to be during database transaction. Any way it can be done fast?

The database table has roughly 100 000 records, but I want to put another 500 000 or more in it.
There are no indexes except for primary key field. Processor is 2.2 GHz, There is no load on the system.
SELECTs are fine, but INSERT/UPDATE is very slow.

I am attaching 2 programs, one that UPDATEs records, and the other one that INSERTs. Both take many hours to complete.
I will be happy if it takes a few hours (hopefully minutes of course) on a database of about 500 000 records.

I am looking for somebody who can suggest a solution and implement it.
If my requirements or price are not reasonable, please tell me. I have no idea how difficult or expensive it is to do, but I need it to be done in any case.

Attached:

1. Source code for 2 programs, one that INSERTs and the other one that UPDATEs.
2. Database format, provided as a CREATE TABLE statement so that you can re-create database on your system.
3. two files with data that you'll need to test the code. They are accessed by the programs.

See explaination.txt for details.

Deliverables:
1) My main concern is that the attached program Sup7onhand.java can be executed in a few hours at most, when run on a database of 500 000 records.
Complete source code of all work done, if coding is
involved, or necessary explainations to achieve desired performance if no coding involved.
3) Complete ownership and distribution copyrights to all work purchased.



Platform:
Windows XP
mySQL 4.0.13
Java 1.4

Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.



Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
 
Bidding/Comments:
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)
Name   Bid Amount 
 
Date   Coder Rating  
This bid was accepted by the buyer!
D Alexander
(1 ratings)
in London, London
United Kingdom
Bid id: 782,298
 
$75 (USD) Jul 12, 2003
7:00:32 AM EDT
 10
(Excellent)
   
Hello Demosfen,

As a professional Java developer, this would be a straightforward job for me.

I have experience working on enterprise level applications in a corporate environment where database performance is critical.

I can therefore offer you a fully optimized solution.

Why choose me?

+ I am a professional developer with over five years experience.
+ I can meet the deadline.
+ I always test thoroughly.
+ I provide a three-month bug-fix guarantee.

If you want, I could complete this within 24 hours of you accepting my bid.

Hope to hear from you.

Regards,
Derek
 
 
 
 
  See 3 private reply(ies)
to/from D Alexander.
 




Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Anuj Gakhar
Rated a 9.96 on 104 jobs 
Securenext
Rated a 9.96 on 114 jobs 
Buddies
Rated a 9.83 on 81 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
Codman
Rated a 9.97 on 150 jobs 
Michael Sharp
Rated a 9.98 on 182 jobs 
D-N-S
Rated a 9.93 on 37 jobs 
markesh
Rated a 10 on 22 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
Maxnet Technologi es Private Limited
Rated a 9.92 on 74 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.