Show Bid Request
JDBC/mySQL performance problem
Bid Request Id: 72728
|
|
|
|
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)
|
|
|
|
|
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!
|
$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 |
|
|
|
|
|
|