Join CSV files and sort them in PHP, to look like it's result from query in Database
- or -
Post a project like this$30
- Posted:
- Proposals: 8
- Remote
- #1724244
- Expired
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: PHP scripting
Description of requirements/functionality: I have MySQL database, and i run sql query on that database with joins and where clause, lets say query will look like
SELECT a.value1,
a.value2,
b.value3,
c.value4
FROM table1 a
LEFT JOIN table2 b ON a.some_value=b.some_value
LEFT JOIN table3 c ON a.some_value=c.some_value
WHERE a.some_value = 'some_text';
and i run query 1000times from PHP to get average time needed for this query on database with 4.5milions records.After that, i export these 3 tables in CSV files.
Now, i need some programmer who can load these CSV files in PHP and to create script that will JOIN these CSV files and filter with some where clause, and to get result to look similar like sql query in database.
Also, it's needed to go through 1.000 times and measure each time of execution to get average time.
First i want to know someone if someone is able to do this kind of job, as fast as it possible, after that, i will provide csv files for job.
Feel free to contact me if you have any questions.
Best regards
Specific technologies required: PHP
OS requirements: Windows
Extra notes:
Description of requirements/functionality: I have MySQL database, and i run sql query on that database with joins and where clause, lets say query will look like
SELECT a.value1,
a.value2,
b.value3,
c.value4
FROM table1 a
LEFT JOIN table2 b ON a.some_value=b.some_value
LEFT JOIN table3 c ON a.some_value=c.some_value
WHERE a.some_value = 'some_text';
and i run query 1000times from PHP to get average time needed for this query on database with 4.5milions records.After that, i export these 3 tables in CSV files.
Now, i need some programmer who can load these CSV files in PHP and to create script that will JOIN these CSV files and filter with some where clause, and to get result to look similar like sql query in database.
Also, it's needed to go through 1.000 times and measure each time of execution to get average time.
First i want to know someone if someone is able to do this kind of job, as fast as it possible, after that, i will provide csv files for job.
Feel free to contact me if you have any questions.
Best regards
Specific technologies required: PHP
OS requirements: Windows
Extra notes:
Milica P.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
5 May 2024
Serbia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies