App Architecture: move load from app memory to MySQL

Замовник: AI | Опубліковано: 27.02.2026
Бюджет: 750 $

Our Laravel application relies on a straight-forward relational model, yet the most common complaint from users (and my dev team) is slow performance, CORS errors and out of memory problems... Too much processing lives in PHP memory; too little happens inside MySQL where it belongs. Over the next week—roughly fifteen hours of your time—I want to sit down with someone who immediately asks: • “What’s the data model?” • “What’s the cardinality?” • “What’s the growth curve?” • “Can we aggregate this in SQL?” • “What are the indexes?” You’ll review our existing schema, study out of memory issues, walk the team through moving processing from laravel/memory to the database. Expect to touch Laravel’s Eloquent layer only long enough to show how to push heavy lifting into properly indexed, well-written SQL. We need straight, simple architecture guidance "here is a problem.... that won't work at scale - ever..... you need to do xyz..." Just sharp, actionable advice that shifts processing to the db and clears up the performance issues.