• Leigh Stoller's avatar
    Speed up the instantiate page response time, it was taking forever! · af8cc34f
    Leigh Stoller authored
    1. Okay, 10-15 seconds for me, which is the same as forever.
    
    2. Do not sort in PHP, sort in javascript, let the client burn those
       cycles instead of poor overworked boss.
    
    3. Store global lastused/usecount in the apt_profiles table so that we
       do not have to compute it every time for profile.
    
    4. Compute the user's lastused/usecount for each profile in a single
       query and create local array. Cuts out 100s of queries.
    af8cc34f
instance_defs.php 31.9 KB