Find Jobs
Hire Freelancers

Compare large data

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
Hi I need the fastest way to compare large file text (contain millions records) with mysql table (contain millions records) I need script can make this task in linux
Project ID: 11553193

About the project

21 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $119 USD for this job
User Avatar
I'm expert in data processing with HUNDREDS of completed projects that's why I'm sure you'll be impressed with my work. The main question is how big is your file (in gigabutes) and how much memory do you have. Thanks. Roman
$64 USD in 1 day
5.0 (419 reviews)
7.5
7.5
User Avatar
Hello I have an experience of 5 year in Linux platform and Mysql . I will setup a bash script to compare large data. PROFILE : Am a Redhat certified Engineer ( Cert ID : 120-202-320 )
$150 USD in 1 day
4.9 (410 reviews)
7.1
7.1
User Avatar
The fastest way - load all data in memory from mysql and do compare. So you need a lot of ram. May be possible split into parts if the text file sorted and mysql table have index on sorted (in text file) field. I can create such script in python.
$155 USD in 10 days
5.0 (68 reviews)
5.7
5.7
User Avatar
Hello To make this works the fastest I would suggest developing a Java application which would run locally at the server with the database. Please tell me more about the requirements. Best regards, Denis Poduzov
$88 USD in 1 day
5.0 (16 reviews)
5.2
5.2
User Avatar
Hello ! Can you please provide me with a sample text file and db structure/script ? What version of PHP and MySQL you have installed ? I am confident that I can 100% complete this job for you full satisfaction. Regards, Sheroz
$55 USD in 2 days
5.0 (22 reviews)
5.1
5.1
User Avatar
Hello! Would you be able to provide me with sample txt and mysql table schema? Basically i need some more details regarding the data structure to deliver most efficient solution. Any info you that you can give me will help. We could discuss the details via chat anytime. Please see my reviews for some references. Thank you.
$45 USD in 1 day
4.9 (60 reviews)
5.1
5.1
User Avatar
Hello. More 20 years programming experience. I need more details to set real time and price - fastest way will be small program on C, otherwise, python or perl script. Regards. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$100 USD in 3 days
4.8 (25 reviews)
4.9
4.9
User Avatar
Plz send me a example data
$150 USD in 3 days
5.0 (12 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$70 USD in 1 day
5.0 (2 reviews)
0.9
0.9
User Avatar
I have been using Linux for over 10 years. If you want to do a simple text comparison, then the fastest way would be to dump the database table to a file, and use a Linux file compare utility. I can write a script to do this.
$100 USD in 5 days
5.0 (1 review)
1.0
1.0
User Avatar
Hi i am a software engineer, i can help you doing that. since i am working o web development on linux environment.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am a hard working person and i will get this job done as soon as possible. Thank you! Ben
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
will create a script using bash and sql, inbox me if interested
$222 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, my day job requires me to conduct similar projects as yours where I need to compare data from various sources. Recently I processed 30GB text file using Java with 2 mins runtime, parsing the text file into format readable by the target system. Approach There are 2 ways to approach this issue. 1. Download the data from MySQL database to a text file in your Linux system, and then run comparison using a Unix script between the two text files. 2. Upload the text file to the MySQL database and run the comparison in MySQL database using outer joins. Next Step Please feel free to contact me to discuss further on your file size and I can advise the best way to run the comparison. You can also let me know what constraint you have for example you need the comparison to run in X mins etc.
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 15 years of experience using and administering Linux systems. Being an experienced programmer as well, I feel confident I can accomplish your project.
$64 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I worked as an electronic document interchange developer, and the team parsed documents and inserted them into the Web apps database.
$138 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
North Chesterfield, United States
5.0
36
Payment method verified
Member since Mar 22, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.