Author Topic: Site is slow  (Read 1475 times)

Offline Phero

  • Forum Addict
  • *****
  • Posts: 6511
  • Neutral Evil
Site is slow
« on: May 11, 2012, 09:05:52 PM »
Been slow for a couple of days, are you guys working on it?
The clock is ticking, the heart is beating everyone insane.

Offline Dr_Grinch

  • Benevolent Dictator
  • Administrator
  • Forum Addict
  • *****
  • Posts: 6202
Re: Site is slow
« Reply #1 on: May 11, 2012, 10:51:11 PM »
Quote from: "Phero"
Been slow for a couple of days, are you guys working on it?


Yup ;)
I'll keep pratce

Offline Dr_Grinch

  • Benevolent Dictator
  • Administrator
  • Forum Addict
  • *****
  • Posts: 6202
Re: Site is slow
« Reply #2 on: May 11, 2012, 10:51:11 PM »
Quote from: "Phero"
Been slow for a couple of days, are you guys working on it?


Yup ;)
I'll keep pratce

Offline Gabriel

  • Forum Addict
  • *****
  • Posts: 1336
Site is slow
« Reply #3 on: May 13, 2012, 01:15:08 AM »
Site is fast now. You guys done? Keep us updated.

Offline Dr_Grinch

  • Benevolent Dictator
  • Administrator
  • Forum Addict
  • *****
  • Posts: 6202
Site is slow
« Reply #4 on: May 13, 2012, 03:36:27 AM »
Quote from: "Gabriel"
Site is fast now. You guys done? Keep us updated.


New site is live, but it looks like there's a nasty split in the DB around 2008... Not sure what Penguin will have to do next to import the remaining messages.
I'll keep pratce

Offline Penguin

  • Administrator
  • Forum Addict
  • *****
  • Posts: 1262
  • Your friendly neighborhood BOFH
    • http://www.dhcp.net
Site is slow
« Reply #5 on: May 14, 2012, 09:11:30 AM »
The import script dies at around the 1.6-1.8 million messages mark.

The gritty details are:

- I'm hacking into the database and scripts directly to make the import work (due to hidden corruption)
- The import takes about 24 hours, due to the insane amount of posts/topics in our old forum
To operate insert coin

  • Guest
Site is slow
« Reply #6 on: May 14, 2012, 09:58:30 AM »
2008 was the time Jelsoft started being dicks and it was decided to drop their shitty forum software?

Offline Penguin

  • Administrator
  • Forum Addict
  • *****
  • Posts: 1262
  • Your friendly neighborhood BOFH
    • http://www.dhcp.net
Site is slow
« Reply #7 on: May 14, 2012, 10:04:56 AM »
It's not really related... Everything was successfully converted to phpBB at the time. Biggest annoyance right now is the 'random moment of death' importing posts. Every time I have to restart it, it means another 24 hr. wait to see if the fix worked :)
To operate insert coin

Offline Shwaggy

  • Uncle Shwaggy
  • Administrator
  • Forum Addict
  • *****
  • Posts: 17734
  • Ambiguously Apathetic
Site is slow
« Reply #8 on: May 14, 2012, 03:33:15 PM »
Ouch. Well, thanks again for soldiering on penguin. Much appreciated.
Quote from: acme420
you guys have a lot  of complicated  thought processes that go into your decision  to fuck or not fuck a chick. all bitches have pussies and most of em get wet, pick one and fuck her.

  • Guest
Site is slow
« Reply #9 on: May 14, 2012, 04:58:34 PM »
That sounds like somewhat of a nightmare :/ Thanks for doing this Peng, I imagine it must be kind of annoying :)

Offline g

  • unlimited downloads
  • Forum Addict
  • *****
  • Posts: 5180
Site is slow
« Reply #10 on: May 14, 2012, 09:25:58 PM »
^^ agreed

that said. does this mean you\re changing the board software? i wasnt sure if this was the new site since i seem to recall a post saying otherwise

  • Guest
Site is slow
« Reply #11 on: May 15, 2012, 12:14:15 AM »
Quote from: "g"
^^ agreed

that said. does this mean you\re changing the board software? i wasnt sure if this was the new site since i seem to recall a post saying otherwise

That's the plan and I think we are switching to SMF, right Penguin?

Offline Penguin

  • Administrator
  • Forum Addict
  • *****
  • Posts: 1262
  • Your friendly neighborhood BOFH
    • http://www.dhcp.net
Site is slow
« Reply #12 on: May 15, 2012, 11:43:26 AM »
Ugh, this is starting to piss me off... It still keeps dying without any recognizable error. Starting the 4th attempt now :(

Yes, we intend to switch to SMF, as it's MUCH easier to administrate, secure and update.
To operate insert coin

Offline SkiLLz

  • Forum Addict
  • *****
  • Posts: 13416
    • http://www.tubgirl.com
Site is slow
« Reply #13 on: May 15, 2012, 03:35:00 PM »
Probably a stupid question, but can't you split the import into batches instead of trying to do it in one shot?
Efnet - #theshortbus for all your retard needs.

Quote from: MisterTurret
What pisses me off the most is when people use such huge words like EVERYONE AGREES or OUR CULTURE or some shit like that.

Offline Penguin

  • Administrator
  • Forum Addict
  • *****
  • Posts: 1262
  • Your friendly neighborhood BOFH
    • http://www.dhcp.net
Site is slow
« Reply #14 on: May 15, 2012, 03:56:08 PM »
Quote from: "SkiLLz"
Probably a stupid question, but can't you split the import into batches instead of trying to do it in one shot?


It's already being done in batches. That's how the convert script operates to prevent itself from overloading the site and/or database.

The problem is not so much with the batching, the problem is that the phpBB setup contains a lot of 'hidden corruption'. In technical terms, this means table contents that don't match the table type, table contents that cannot be converted to the target table type, etc.
To operate insert coin