Presentation: 3.4 Million page views per day, 92 million per month, one server and Drupal

Hello,

Excellent presentation.

In your presentation there was something, a fix about slow queries. Where do I make the following changes? On the server? or On a particular place in Drupal template? if yes where?

● 84% of slow queries were:
– SELECT COUNT(*) FROM sessions WHERE uid = 
0 AND unix_timestamp() ­ timestamp < 
(60*15)
– 3.6 seconds!
● Changed to 
– SELECT COUNT(*) FROM sessions WHERE 
uid = 0 AND timestamp > 
(unix_timestamp() ­ (60*15))
– 30 milliseconds!

Often some of these presentations are recorded and placed online (web archive, for example). Was a recording done of this presentation and is it available online somewhere if so? This one would be great to see!