Closed

Make my sql run faster. - open to bidding

We are currently developing a portal that will allow users to create custom reports with data stored on a mysql database. The data consists of about 500,000 rows in excel and each row contains about 15 columns of data.

You can take a look at the portal here:

[url removed, login to view]

I am looking for someone to take a look at the code written and make improvements on the performance. I need to make this much faster than it is right now. The data currently on the test site is very small, it is probably around 100,000 lines of data and the performance is already very slow.

If you are interested in working on this please let me know and I can send you more details.

Thanks

Skills: MySQL

See more: my sql create database, mysql to sql, excel to my sql, run faster, excel sql create, sql reports mysql, custom reports excel, mysql performance test, excel rows lines, php create reports database data, bidding mysql code, excel slow, faster php, create reports sql database, create mysql reports php, create php reports mysql, create reports php mysql database, create reports mysql database php, php mysql database create reports, custom reports mysql php, create mysql database reports, sql database portal, sql portal, send data sql, create custom reports mysql

About the Employer:
( 20 reviews ) Limassol, Cyprus

Project ID: #6685903

12 freelancers are bidding on average €39/hour for this job

leadconcept

Dear Sir, I have read your Project Description & very much interested to work with you on this project but do you have more detailed requirements, some reference/example website URL or can you drop me a message thru More

€37 EUR / hour
(42 Reviews)
8.3
techmartsol

Hello, We have gone through the scope of work and would be happy to provide complete solution on this and future support also if required. Scope of work includes - - Optimizing the DB and site performance - We More

€37 EUR / hour
(43 Reviews)
6.0
sprextech

----------------------------------------------------------Please Consider on My BID---------------------------------------------------Dear Sir/Madam, We are already read your project description & fully understand this More

€50 EUR / hour
(49 Reviews)
5.5
danale72

Hello Please consider me as a candidate for the project. See my projects history for references. As a start point I would like to have slow query log. Note that Mysql was designed for relatively simple querie More

€40 EUR / hour
(49 Reviews)
5.3
southerndev

Hello, I've several years of experience working with MySQL and queries I'll do my best to optimice the query. However still couild happen that your server is slow and all the proper optimization measures has been tak More

€40 EUR / hour
(63 Reviews)
5.2
forumizer

Hello. Please give more detailed description of the project. I've got really very big expirience is php/mysql software development and sure will solve your task quickly with the best quality

€40 EUR / hour
(2 Reviews)
3.8
GAnthonyMassie

Hello, MySQL should be able to handle 100,000 results (and even millions) with ease. Do you have any example mysql statements being made on the website for me to check out? Is there any other tables than the one? Ca More

€36 EUR / hour
(14 Reviews)
3.7
emilemilot

Hello, I really want to work on your project with technologies I like to work on. I am new on this freelance platform, and I am searching for good reviews. It could be a very good opportunity for you. I want to pr More

€37 EUR / hour
(1 Review)
0.8
covernal

Dear, client. I'm interested in your job. I have done SQL optimization before while working on some backend job. I have rich experience in building websites. I have built following websites by PHP [url removed, login to view] More

€42 EUR / hour
(0 Reviews)
0.0
artwebsolutions

Hallo, I have several years of experience in programming webbased applications with PHP and a MySQL backend. Im sure that i can help you speeding up your site. If you have any questions please don't hisetate t More

€40 EUR / hour
(0 Reviews)
0.0
diarselimi

i can help u in this project please contact me for further details.

€37 EUR / hour
(0 Reviews)
0.0
dmathai

More than tuning the sql you may need to add indexes in the DB. Please identify the most used columns in the "where" clause of the sql and add index for that. Probably this will solve your performance issue.

€36 EUR / hour
(0 Reviews)
0.0
paxpelus

I am an experienced Web Developer from Greece worked both in Front End & Back End. I have a lot experience with mysql and I think I can help you optimize the database and even propose some other solutions if needed. More

€36 EUR / hour
(0 Reviews)
0.0