PHP Performance - Speed up your PHP application - 2 of 7

[foneyop]

what are you talking about at 7:50 ? Also persistent connections is problematic for high traffic web sites since it keeps about .5k - 1k open connections per web server, you quickly eat up all of your available connections and memory on your DB. This is compounded for each slave db.

@8:50. That's insane. I think you got stories mixed up. @9:10 OSI.

[omesorg]

1. You want to avoid doing a table scan at all cost!! (well almost...) And even a tenfold decrease from 30 to 3 seconds is not good enough! 3 seconds here is just for the query, then add application execution time, network delay that he's touching later in the video and then finally client side execution. (in case of web) Even with query caching this practice tends to make your users angry.

2. around 9:15 he says he doesn't remember the name of what he's describing - it's the OSI model.