LAMP based website bug fix & performance optimization

Kuwaitlocal is web based application, which you can access through website and from both android and Iphone apps 1. Business Search -User can search any business in Kuwait, which would retrieve, Address, Contact No's, Email, Gallery, Business Social Links, Directions to the Business, Ratings, sending enquiry to Business. (This is accessible Through Website and App) 2. Classifieds – User can post ad through website or mobile app Each Classified would contain Classified Information, Directions, Images.( This is Accessible through website and App) 3. Forum – User can access forum through website only 4. Blogs – User can access blog through website only 5. Affiliate Module – affiliate model is developed for our employees, where they can add business in a bulk using excel from website. And mobile app Skills to be known 1. Linux 2. Apache 3. MYsql 4. PHP 5. Cake PHP 6. Html 7. CSS 8. Jquery 9. Javascript 10. Ajax 11. JSON 12. Angular JS 13. UML Present Issues we are Facing 1. Throughout the website the performance Is very slow 2. Business Search Queries, Classified Search Queries, Forum Search Queries and Blog Search Queries taking Long time. 3. Its taking long time while posting a business or classified etc 4. To open any page its taking long time to load 5. Any task done on website the cpu usage is very high, when database is accessed the cpu usage is more than 50% MYSQL Database 1. data base modeling. 2. data base relationships. 3. data base query optimization. Targets to Be Reached 1. Any Search Query Should Not take Place more than 1 Sec, either it is business , classifieds, forums or blogs 2. Any link on the website to be opened not more than a second. 3. Application should be able to handle 2,00,000 business information 4. Application should be able to handle unlimited classifieds data 5. Application should be able to handle unlimited forums and blogs 6. Application should be able to handle at least 200 concurrent users 7. When user search for anything, results should be proper by retrieving all the details, there should be no index problem, Searching should be done perfectly without any bugs, means what the data having in the database must be displayed at the user end. 8. Application should pass Load Testing, Performance Testing. 9. Data in the data base must not be disturbed. 10. Whether key constraints should be declared at code level or data base level (which will be advantage). 11. No task should use more than 10 % of cpu 12. All the issues to be fixed Website Performance Optimization - Following is just for suggestion 1. CSS Optimization 2. JavaScript Optimization 3. Images Optimization 4. Content Delivery Network 5. Server Side Optimization 6. MYSQL Database Optimizations 7. Minimizing HTTP requests 8. Use CSS instead of images where ever possible 1. Reduce Server Response time(should be less than 200 ms) 2. Enable Compression (Gzip) 3. Enable Browser Caching 4. Remove Unwanted Code 5. Optimize Images 6. Optimize CSS 7. Reduce redirects Who can BID 1. We will speaking to the resources who would be working on this project 2. We need resumes also 3. When you bid , you have to mention Bid Amount and time 4. Proper communication must Note 1. If targets are not reached or project is not done in given time , payment would not be done 2. OUR php developer will help you incase if anything required, and he should get the day to day updates and KT.