analys and increase performance for mysql database
$30-250 USD
In Progress
Posted over 11 years ago
$30-250 USD
Paid on delivery
i have a database , i want to analys it and increase performance
i don,t know alot about mysql databases , but i have issues in my query , some take 10 seconds or more for result .
I'm experienced Linux system and database administrator. I can find a source of your performance issues and suggest best solution that will fit your needs.
No problem,sir.
Pleasure to see this work and ska ip-The Administrator removed this message for containing contact details which breaches our Terms of Service...i can guarantee quality .
Thanks and regard
The most common causes of slow query/stored proc execution are poor query design and/or poor database structure. Enhanced performance can usually be provided without major changes to the database structure through temp table creation or simply refining the query structure. My bid is centered on these issues and can be refined with more information. Depending on the size and structure of the database my bid would cover (table indexing review, primary/foreign key analysis, normalization analysis and refinement of the query/stored procs in question.
Thank you for your time and consideration.
Hi, I can help you
Currently I am working on a database in mySql with more than 2 million entries and executing queries in matter of seconds.
Max time for any query is 1 or 2 second.