create MySQL queries for speed improvement

Hi, I'm a Linux sysadmin with 14 years of experience managing LAMP servers and would love to help you with this problem. According to my experience, I'd say that there are some parameters on MySQL that need to be tuned and that probably there are queries that have indexes missing, which can lead to performance problems. First place to look out would be the slow queries log and the [login to view URL] configuration file, in order to check what changes could be made to improve the performance. Would be really glad to help you with this situation. Best regards, Marco Ramos

Expert here can help you on this. so let me know from you. PHP/MYSQL programmer here. can finish it today itself.

Hi, I'm interested to work on your project. Please let me know if you require any detailed information. Waiting for your reply Thanks Dev

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 MySql Query for speedy result Let's take it to the next step and start on this ASAP. Thanks, Techmart Team

What kind of queries do you use? Do you use caching for query results?

hello dear sir i m good with mysql u can chk my profile i will do ur work on time thanks sir ============================================================================================================================================================

I am mysql DBA having more then 5 yrs of experience

Hello, Your system should be built in such a way that you should not need to check couple times every hour, only when the user accesses your system. Best regards, AccuPro.

we are working in php development since 2010 and having skills to optimize your queries for faster execution.

Hi.I am a Software Engineer and programmer. I have about 2 years of programming experience and developed 52 project .Project are both web based and desktop based application. I am ready to start your project right now. If you have any questions you may ask .Thankx

Hello. I had worked in your project some times ago. I need more details to set real time and price - for example: where is stored users period? Regards. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MCSA SQL 2012 Microsoft Certified Solution Associate. MCTS 70-515 WebApplications Development with Microsoft .net Framework 4 I am certified professional and able to complete your work within time frame of 1 hour and need to see the current db structure so plz come for freelance chat thanks

Hello Dear Sir/Madam, We are having a Company of 25 members and we are new to freelancer and we are here to get big projects as per requirement of client and we have the ability to work anything on our skills such as we can do anything in PHP MAGENTO CSS WORDPRESS PLUGIN DEVELOPMENT EXTENSION THEME SOAP API AWS HTML HTML5 CSS3 JAVASCRIPT JQUERY SEO API DEVELOPMENT AND MANY MORE NOW WE ARE HERE TO PROVIDE OUR SERVICES. LOOKING FOR YOUR RESPONSE AND WE ARE HERE TO DISCUSS EVERYTHING ON OUR PROJECTS AND FEEL FREE TO ASK IF YOU NEED ANY SUGGESTION. Thanks

Send me something and I will show my skills in Mysql ----------------------------------------- --------

I have done 4 types of projects like this before. i.e., I had created subscription for certain users. I have an innovative thinking of creating websites and i will give u a perspective design for your need And i am doing it in PHP and MySQL . So that it will access at high speed. If u need any clarification call me at +91-9843562666

A proposal has not yet been provided

About ME: ------------- Solution Architect having 11 years of Java/JEE development experience in all phases of SDLC - analysis, proof of concept, prototype, design, development, testing, implementation, post implementation support and maintenance. Workflow and Initial Solution Thoughts: ------------------------------------------------ Solution 1: ------------- - Normalize 'Usage' table into relational chunks... - Performance improvements on indexing, etc. - Create another table 'Usage_Quota_Near_Complete' to hold data calculated by fortnight batch job to have the Users who's usage is going to be completed like users '499' in an month / '1999' in an year...So instead of hitting actual live tables we can hit the calculated process tables to get scalable and performance. Solution 2: ------------- Scale Up/Out the database infrastructure/ clustering Solution 3: -------------- Having database update trigger upon data query Please feel free to reach me to discuss about the requirement, workflow and solution approach. Thanks RK