Learn More
Resend Email
70
rantsauce
7y

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

rant

optimization mania

optimization
Favorite
Ranter
Comments
  • 4
    7y
    600 queries? Peanuts... I've seen pages running 10.000s of queries in less time 😂
  • 0
    7y
    @gintko have you ever heard about that magic word called index? 😂
  • 0
    7y
    Wow! That's too much!
  • 4
    7y
    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.
  • 5
    7y
    @superuser or change the weird business requirements.
  • 2
    7y
    621 is way too much for a page. Probably want to bring that down to 420 max. It'll be smokin' then.
  • 1
    7y
    I knew Chuck Norris had a devrant account!
  • 0
    7y
    I once optimized a page that would execute 8 queries per store on our site. Some of our users have over 10000 stores :/
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment