74

I once optimized a web page that performed 621 SQL queries and loaded in 21 seconds in a production app.

Comments
  • 6
    600 queries? Peanuts... I've seen pages running 10.000s of queries in less time 😂
  • 2
    @gintko have you ever heard about that magic word called index? 😂
  • 1
    Wow! That's too much!
  • 5
    If an app needs to run more than 10 queries in order to show up it means that you need to redesign your db.
    In my current job I did the same thing and the loading time from 30+ seconds dropped to ~50 ms.
  • 6
    @superuser or change the weird business requirements.
  • 3
    621 is way too much for a page. Probably want to bring that down to 420 max. It'll be smokin' then.
  • 2
    I knew Chuck Norris had a devrant account!
  • 1
    I once optimized a page that would execute 8 queries per store on our site. Some of our users have over 10000 stores :/
Add Comment