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.
12 freelancers están ofertando el promedio de €39/hora para este trabajo
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
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.