Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

biggest vanilla install?

2

Comments

  • MinisweeperMinisweeper New
    wait, when you say migrated did you mean with my migrator? just curious...
  • ithcyithcy New
    no, i rolled my own :)
  • MinisweeperMinisweeper New
    ahh, fair enough, which forum were you moving from? I'm assuming from your comments vanilla is considerably quicker?
  • MarkMark Vanilla Staff
    I would actually classify his version as pretty slow - but we've got some indexes on it now that are helping quite a bit. we'll post the results when finished.
  • MinisweeperMinisweeper New
    but if its slow is it still quicker than it was on the previous software?
  • MarkMark Vanilla Staff
    Oh, I don't know. They've got whispers enabled, so that definitely slows things down on the discussion list. When they turned whispers off it sped up like nobody's business - but they really like whispers, so they turned it back on.
  • ithcyithcy New
    right now it's slower than the old software, but there are a lot of other factors that have changed, so there can't be an apples:apples comaprison. the other software was a lot less feature-complex than vanilla and i think it was on a different host. what host did you use, denied?
  • DeniedDenied New
    edited August 2005
    the idea of tw with whispers makes my head feel funny. that's actually quite frightening...

    and the old code was super lightweight, so vanilla probably won't ever get faster than it (based on a similar server set-up, that is. on a honking dedicated box, that's a different question). but i'm not giving up the old tw code, so they're shit outta luck!

    but, really, it's better for them to be on vanilla.
  • DeniedDenied New
    tw was on dreamhost.
  • ithcyithcy New
    that's where it is now.
  • orangeguruorangeguru
    @ithcy Very impressive! Thanks your your message on my board.
  • ChrisGwynneChrisGwynne ✭
    60,000 plus comments 3,000 plus discussions... doing fine. =)
  • DeniedDenied New
    itchy - jonezy was an active member on tw, not like the bastard ever went there, or anything, but you can let him into the new one.

    and, really, that much jibber jabber (almost half a million posts) in about 13-14 months by a heavily active user base of, say, 50 people and then a further 80, or so less frequent users who weren't banned is something of a marvel.
  • franklin_mintfranklin_mint New
    denied, you ignorant slut. :)

    Hmm. If someone gives me a dataset, I'll hook the thing up to DTrace on Solaris and tell you exactly where the thing is spending its time, whether it be in PHP functions, MySQL, or something else.
  • MarkMark Vanilla Staff
    That would be swell - would the data from this community site be enough, or would you really need a big hunk of data like ithcy's dealing with to get some good results?
  • dwcliftondwclifton
    edited August 2005

    Another good way to index your tables when you have an existing system like this is to turn on query logging, let it run for awhile, then look at the most frequent queries. Now place indexes on the columns you search on (where w=x and y=z). If you do a lot of searching on tables that become large, this can help tremendously.

  • MarkMark Vanilla Staff
    edited August 2005
    Just talked to franklinmint, and he's going on holidays for the next five days - back next Monday. So, unless anyone else wants to do some DTrace-ing... we'll have to wait and see on this one. Interestingly enough, I just got an email from a guy using Vanilla who says that when there are >= 50 ppl using his installation of Vanilla, he see's his apache usage go up 10 - 15% and it's slowing everything else down. I haven't been witness to anything like that at all - anyone else?
  • ithcyithcy New
    mod_php?
  • lechlech ✭
    apache 1.x or 2.x? if it's 2.x, there's a whole shitload of weirdness under that version.
  • MarkMark Vanilla Staff
    dunno - I pointed him in the direction of this thread. Hopefully he checks it out...
This discussion has been closed.