We currently have an EC2 and RDS instance with Amazon Web Services. Our site is written in PHP, and the database is mySQL. We're running into slow queries on some pages and want to figure out alternatives to resolving the issues. The queries involve joins of two tables that have about 3 million records each, and a third table that has about 40,000 records. We've managed to improve our query time somewhat by experimenting with the queries, but it was still far too slow. We then tried experimenting with the parameter settings in RDS, but there wasn't any noticeable improvement, and in some cases it was worse. We're on a somewhat limited budget at the moment, and so upgrading our RDS instance is a last-resort option. However, if that's our only option at this point for marked improvement that still meets our business needs, we'd like to verify that as well. So, we're looking for someone who can help us with the following:
1) If possible at the outset, confirm whether our issues would require an upgrade of our instance or other fundamental platform changes to be improved.
2) Examine our queries to see if they can be optimized further
3) Examine our parameter group settings and recommend changes
4) If neither 2) or 3) resolve the issue, recommend changes to the data structure that could improve performance
5) Revisit question of fundamental platform changes
We're also looking for someone who can advise us on how to avoid slowdown of the site while our product import is running, but ability to help with this part of the project will not be necessary in order to be awarded the contract.
Because of the open-ended nature of this project, we would be paying by the hour, but we would have a cap on the number of hours spent on the project that could be extended by mutual agreement. The initial cap would be four hours of work. The data model will be provided once we have selected a contractor.
This project was awarded to
Overall, working with LeadConcept was a great experience. YK and his team are extremely professional, friendly, and dedicated. They took on my huge project (which a previous company had failed at) and completed it to my satisfaction. If this team could improve one thing, however, it would be testing/quality assurance. To be honest, I was frustrated at some points throughout the project because of the large number of bugs that could have been easily avoided by thorough simple testing prior to sending the build to me. However, the company is very attentive to its clients' needs, so I am sure that, based on my feedback, they will improve this area of their services. They were extremely dedicated to my project even when I had high standards and maintained regular communication with me via email and IM. They always worked with me until the site worked as I wanted it to. I believe that I got excellent value for the services that I paid for, and I would definitely recommend this company.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
I am a Expert MySQL DBA with 5 plus year of experience on MySQL / MariaDB servers. I have helped many startup to scale well in MySQL . Have a lot interest to in MySQL servers . Have entered this freelancer for challenging activities.
Colombo, Sri Lanka
I am a Software Engineer who works in a reputed company for the last 6 years in .net technologies especially in Amazon Web Services, vb.net, c#.net, Zebra label printer ETL and also MySQL, MS SQL Server Programmings.In the meanwhile I am working on Amazon API, Excel Add In for Amazon and Amazon Crawling scraping (AWS & MWS) which is to produce a csv at the end. I have developed many automation bots for forum, social, feed and article sites for automatic posting.Other than that I also have good experience in SQL Server, MySQL and SQL functions. I have some web experience too in Wordpress, PHP and HTML etc I am very friendly character. Very dynamic and flexible personality in reality
Expert Village Media is a professional Shopify Ecommerce Web design, Custom Web Development and Mobile Application Development Company. We provide complete web design and internet marketing solutions. We work on Amazon Webstore, Shopify Apps, Shopify Theme Design, Magento, Bigcommerce, Drupal, Wordpress Responsive web design, Volusion store design, wordpress plugin development, iphone application development and android application development. Facts and Figures - - We have done more than 700 websites so far - We have been approved by Amazon Webstore as their implementation providers - We have more than 500 clients from USA, UK, Australia and all over the world - Our wordpress plugins and mobile apps have reached more than 4000 users so far
I've 13+ years of experience in the web application development on various topics. My expertise includes Java/J2EE, web scraping, wordpress and Magento technologies. I always try to ensure that there is excellence in my delivered work. I will even provide support, after completion of the project, for a short span. So, you're assured that you get the best when you choose me.
La Plata - City Bell, Argentina
A través de todos estos años hemos sumado y capitalizado la experiencia en el establecimiento, diseño y desarrollo de soluciones integrales de negocio. Analizamos el entorno del problema de negocio e incorporamos los procesos y la tecnología para brindar una solución completa. Ofrecemos el servicio de consultoría y asesoramiento a empresas ayudando a reducir costos de implementación y mantenimiento como así también la maximización de los recursos disponibles. Consultoria Linux Consultoria Oracle Consultoria Open Source Servicio Técnico Especializado 7x24
London, United Kingdom
Zeus is an app development studio managed by old mature tech-pros and young technology addicted geeks. Established in 2006. From the very begging we worked on establishment of trustful and fruitful win-win relations with serial entrepreneurs/agencies/startups from across of globe (the USA, Australia, Canada, Western Europe, Eastern Europe, Israel and Far East). Combination of old-gurus' expertise with young energy and talent let us to provide full-cycle mobile & web apps development services. We strive to think different in almost any corner of our service delivery model. Unlike most outsourcing companies we are not working as faceless body-shops or annoying proposal spammers. Our communication model and approach let our clients to move their focus to most essential product related questions such as marketing, and strategy. At that time we are providing to our clients transparent development/QA process combined with our free-of-charge consulting/advices of our clients about possible ways of product improvement and launch strategies. Our international expertise let us to be able to grow together with a client from ground to multimillion sky products.
Custom software products and applications development | Web and UI design and coding | Managed services and support | Outsourcing, outstaffing | Consulting | Quality assurance and Application testing
Prakash Software Solutions Pvt. Ltd. is a software development company based in India specialized in Custom Application Development, Quality Check, Analysis and IT consulting. Services: • Cloud based Systems - Architecting, Build, Development, Implementation, Cloud Infra Management • Web Application Design and Development • Microsoft Public Cloud Architect, Design, Build and Deploy. – includes Office365 SharePoint Online, Skype for Business, Exchange Online, Yammer, Delve, Power BI, Visio and Project Online • Office 365 Migration Services for SharePoint • SharePoint Architecting, Design, Development and Implementation. • Microsoft Enterprise Project Management (EPM) Solutions • SharePoint Migration • SharePoint Business Intelligence • SharePoint Branding • SharePoint Work Flow • SharePoint Web Parts • Migration and Re-engineering • Rich Internet Application Development • CMS Development • E-Commerce application development • Mobile Application Development
I am expert in Software and IT consultancy. I have got 10+ years of experience in technology.