Almost time to crash .org again... Mwahahaha

[derobert]

Let's see what needs optimizing the most...

Code: Select all

select page, sum(time) as ttl, sum(time)/count(time) as avg, count(time) as n from page_loads group by page order by ttl desc limit 20;
+----------------------------------------------+------------------+------------------+------+
| page                                         | ttl              | avg              | n    |
+----------------------------------------------+------------------+------------------+------+
| /legacy/search/anime.php                     | 71421.7105458975 |  12.363114167543 | 5777 |
| /legacy/search/member.php                    | 7764.15886259088 |  21.994784313289 |  353 |
| /legacy/allopinions.php                      | 5893.32610893247 |  24.555525453885 |  240 |
| /members/members_main.php                    | 5220.57235515118 |  2.0577738885105 | 2537 |
| /home/home.php                               | 4041.01166045666 | 0.40983891079682 | 9860 |
| /legacy/search/supersearch.php               |  1723.5731317997 |  1.3700899298885 | 1258 |
| /legacy/search/newvids.php                   | 1088.45057106018 |  1.3225401835482 |  823 |
| /legacy/search/newdowns.php                  | 1053.26805210114 |  1.2644274334948 |  833 |
| /members/members_myprofile.php?user_id=8     | 851.492107033734 |  4.2362791394713 |  201 |
| /members/members_myprofile.php               | 820.891502022743 |  2.5180720920943 |  326 |
| /members/members_myprofile.php?user_id=6853  | 688.116059541701 |  3.2612135523303 |  211 |
| /members/members_myprofile.php?user_id=38674 | 560.704231142997 |  2.7485501526618 |  204 |
| /members/members_myprofile.php?user_id=3846  | 348.184516310693 |  3.0812789054044 |  113 |
| /legacy/video.php?v=4492                     | 327.832368969914 |  23.416597783565 |   14 |
| /legacy/search/participation.php             | 273.541882038112 |  2.5095585508084 |  109 |
| /members/members_myprofile.php?user_id=43429 | 227.979695439338 | 0.45055275778525 |  506 |
| /members/members_editvideo_step3.php         |  218.84402012825 |  13.677751258016 |   16 |
| /members/members_myprofile.php?user_id=19771 | 206.365385890007 | 0.90511134162284 |  228 |
| /members/members_myprofile.php?user_id=8760  | 189.656656861305 |  5.4187616246087 |   35 |
| /login.php                                   |  189.18082845211 | 0.37760644401619 |  501 |
+----------------------------------------------+------------------+------------------+------+

Hmmm, anime.php, by an order of magnitude. 90% of the time in 10% of the code holds true, once again...

(Burry stuff in 'All About Me', and no one will find my evil plans)

[RadicalEd0]

:O! U death moose! how could u even think of sucking at all of our amusement like that and forcing us all to go re-read megatokyo until the forums are fixed?
how?
blasphemer
feel the wrath of spam

[derobert]

until the forums are fixed?

Break the forums?! But that'd be a net good. I only break useful things, like searching for videos. Or your main page.

But the forums?! They're great, they keep people busy! And away from porn sites, leaving more bandwidth for me! Wait... did I say that.... you didn't hear anything! Nothing at all.

[fyrtenheimer]

dude WHAT THE HELL is ur avatar?

[derobert]

dude WHAT THE HELL is ur avatar?

A scientificly-engineered set of pixels designed to induce total, unquestioning obedience in all who view it

[Angel_Killer_777]

I think you got ripped off.

[fyrtenheimer]

(lmao)

[derobert]

I think you got ripped off.

Don't worry, 'twas done by slave labor, so it's rather hard to get ripped off. But judging by the size of my legions, it seems effective.

[jonmartensen]

My legions are bigger than your legions

Oh wait, you meant followers.

[derobert]

My legions are bigger than your legions

That sounds painful.