Speed up my PHP/MySQL Laravel API
£20-250 GBP
Pagado a la entrega
I have a laravel API running on a VPS, using NGINX, MySQL and PHP. It's a very basic setup, but it's running quite slowly. Most queries take around 1200s or longer to be returned. I would like you to quote for getting all queries return in <500ms. The database is small, with 5 tables and around 200 total entries.
Here are some details about the API:
- almost all endpoints are a single MySQL query, and return no more than 10 records and are <100kb
- POST endpoints are simple UPDATE queries, updating a single row by ID
- All queries are sent with a Firebase JWT token which is decoded on the VPS (no call to Firebase required) and used to get user details
- The VPS is the cheapest one at [login to view URL] I would be open to upgrading the VPS if it will make a meaningful difference to speed.
- I have attached a Postman for testing. You will need the token at the end of this description (which will expire in 1 hour)
Please quote for getting all endpoints down to <0.5s. Partial release for getting some of the endpoints down to that speed is not a problem, but small improvements will not result in payment.
Thanks very much,
Rob
eyJhbGciOiJSUzI1NiIsImtpZCI6IjBkMGU4NmJkNjQ3NDBjYWQyNDc1NjI4ZGEyZWM0OTZkZjUyYWRiNWQiLCJ0eXAiOiJKV1QifQ.eyJuYW1lIjoiUm9iIiwiaXNzIjoiaHR0cHM6Ly9zZWN1cmV0b2tlbi5nb29nbGUuY29tL2xlYXJuYW55dGhpbmctMTg3YzQiLCJhdWQiOiJsZWFybmFueXRoaW5nLTE4N2M0IiwiYXV0aF90aW1lIjoxNjk3ODEyMzkyLCJ1c2VyX2lkIjoiZk1wVEhma3M2RU5BQkR3MlFEcnRlOG9sQU1KMyIsInN1YiI6ImZNcFRIZmtzNkVOQUJEdzJRRHJ0ZThvbEFNSjMiLCJpYXQiOjE2OTgzMjk3MjMsImV4cCI6MTY5ODMzMzMyMywiZW1haWwiOiJhc2RmQGFzZGYuY29tIiwiZW1haWxfdmVyaWZpZWQiOmZhbHNlLCJmaXJlYmFzZSI6eyJpZGVudGl0aWVzIjp7ImVtYWlsIjpbImFzZGZAYXNkZi5jb20iXX0sInNpZ25faW5fcHJvdmlkZXIiOiJwYXNzd29yZCJ9fQ.NQynVZPAjCn2OAtyD6iy_WxM27Y1hzzNAurrGSxUHYKHaJWwze4NUaqVbwOFAfIUFx8rP3Iw0yyPdz7fWBwEGxnXivEznQTP-ARmSCnEZljHV8kF5p0akI5hQEUdi4yzCBnfuEu_AMPUl2giTa2Ul7zoVcIxKOjgsJYYx5JS7R09l2qQxzILBZpE0Y6qyfOCS9s5q48vF6bE0jcNHU81a33xzPhyPMjObdLUFTs6Cr8ZOV5XONuqlzhu1Cack8RvMGLdZMak77JrPb476nCWw7YlNWyff3EZyxoX15fZiDKklEJolEX3_mKBx-4RmggLjf_B-cio4GcNZKYSLQZDEA
Nº del proyecto: #37358398
Sobre el proyecto
48 freelancers están ofertando un promedio de £154 por este trabajo
I'm ready to optimize your site Now & give you a 80+ Score on Google Page Speed, A+ Grade on Google insight with <2 seconds maximum loading time for permanent. I'm a professional Website optimizer and have more than 1 Más
HI Rob. I can review the code and can optimize it as db is not that big i am sure it can be done. Can you please come on chat so we can discuss more details? Regards Shahbaz Khan
Hello, my name is Rahul Raman Sharma and I am a passionate full-stack developer with 8 years of experience in creating innovative and robust web applications. I specialize in bridging the gap between design and functio Más
I am ready to start work right now. I'll optimize your Laravel API on the VPS with NGINX, MySQL, and PHP. I'll ensure that all queries return in <500ms. My focus will be on speeding up the API without any compromise. T Más
HI! I am an expert web programmer. I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, React Native, and MySQL. I can start right away. I want to discuss this proj Más
Hi Rob, I hope you're doing well. I noticed that your laravel API running on a VPS is experiencing slow performance, with queries taking around 1200s or longer to be returned. I'd like to propose a solution to optimiz Más
Hello, Robert. I have rich experience in building backend APIs using Laravel(PHP/MySQL) on Nginx Linux server. Also I am very familiar with troubleshooting and speed up APIs. So I am sure I can complete this projec Más
Hi,Hope you're doing blissful! I've Gone through with the requirements you've shared for your project. And I'm sure I can provide you best on this with my skills and experience. Lets have chat on this.
"Are you looking for a Laravel developer who can speed up the laravel api now?" Hi! This is Amr, a Laravel expert who has acquired various and perfect skills in building Laravel websites by using CSRF token, middleware Más
Hello, my name is Praveen and I am a experienced PHP Developer with good knowledge in MySQL. I have worked as a PHP Developer for many years and have good experience in the area. I am confident that I could provide yo Más
Hello there! I'm PHP/SQL developer with many years of experience. I'm sure I'll be able to help you with optimising such queries and any other projects in the future :) Also I might have an idea for you how to get BETT Más
Hi! I am an expert laravel programmer. I am good at Laravel and I have a lot of work experiences in Apache, Linux, System Admin, MySQL and PHP. I can start right away. I want to discuss for this project in detail. Pl Más
Hello! Hope you're well. I'm a Senior Developer with 20 years of experience. I'm expert on Laravel, MySQL, Nginx. I can start with your project today. Best regards
Hello, I have worked professionally on optimizing database and connections for Ad Server reporting with 50mil+ daily records and OpenRTB spec which requires sum 10ms response times. I think i can help optimize your qu Más
Hi, there! I have researched your json file and found what you met now. As a well-based Laravel expert, I have good knowledge of Laravel structure and core features. Laravel supports a lot of user-friendly and well-st Más