We're going to be adding some advertisements to the forums! If you notice any weirdness around this or spot bad/inappropriate ads, please make a thread in the bugs forum.

Speed Demon...

ÄlphämönkëyÄlphämönkëy Registered User regular
Im begining a series of optimizations for the forum here. I just implemented the first one tonight, Let me know if you guys feel the difference or start seeing weird errors.

Älphämönkëy on

Posts

  • FerryFerry Registered User
    edited February 2004
    And here I was all excited thinking that the post timer was being reduced.

    Ferry on
    ferrysigrn4.gif
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    I, for one, would like to know what optimizations you're doing. Since quite a few of us run phpBB boards, maybe we could implement your ideas into our own and/or help you fine-tune yours.

    Unknown User on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    Well, the change I made tonight was changing mySQL to use pconnect. This should have been active, I think it was just an oversight. As to the other stuff, as HomeLAN is mySQL only I will be removing the other database functionality (mssql, oracle, access, pgsql) from phpBB and using some of the specific mySQL commands (joins and such). I will be using the fast and furious mod from phpBB hacks as a good source of inspiration, and, I will probably end up either spliting guest sessions into their own heap table, or removing them all together.

    There are more, but this is just preliminary.

    Älphämönkëy on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    I using pconnect really a wise thing? I mean, I can see the advantages, but I can also see the disadvantages. And, to me, it just seems that the bad outweighs the good.

    I guess this is why you were 'promoted' and I was not. :)

    Unknown User on
  • OrthancOrthanc Death Lite, Only 1 Calorie Registered User, ClubPA regular
    edited February 2004
    I using pconnect really a wise thing? I mean, I can see the advantages, but I can also see the disadvantages. And, to me, it just seems that the bad outweighs the good.

    I guess this is why you were 'promoted' and I was not. :)

    Using pconnect is almost always good except in the situations where php can't take advantage of it (not using modPHP), in those situations it will cause a slowdown.

    Connecting to the DB can take a decent fraction of the page loading time if you're not using pconnect.

    Orthanc on
    orthanc
  • DeusfauxDeusfaux Registered User regular
    edited February 2004
    Orthanc wrote:
    jib-jab


    It's the new Rasputin, whispering advice to secretly control the masses from a position of unofficial power.

    Rah! Rah! Rasputin!
    Lover of the phpeen!

    Deusfaux on
  • Raijin QuickfootRaijin Quickfoot I'm your Huckleberry YOU'RE NO DAISYRegistered User, ClubPA regular
    edited February 2004
    It does seem to be running faster, but that could be due to the lack of traffic at 2am.

    Raijin Quickfoot on
    HEY SATAN! HERE'S MY WISHLIST! GO NUTS YOU DEVIL!

    https://www.amazon.com/gp/registry/wishlist/1JI9WWSRW1YJI
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    In essence, the pros outweigh the cons.
    Pro : Cuts down on load time (and server demand) by a significant ammount
    Con : Possibility of weirdness if mySQL server crashes.

    Persistent Database Connections PHP.net Page

    Since we do not use transactional querries or locks we dont have to worry about the major warning
    Warning

    There are a couple of additional caveats to keep in mind when using persistent connections. One is that when using table locking on a persistent connection, if the script for whatever reason cannot release the lock, then subsequent scripts using the same connection will block indefinitely and may require that you either restart the httpd server or the database server. Another is that when using transactions, a transaction block will also carry over to the next script which uses that connection if script execution ends before the transaction block does. In either case, you can use register_shutdown_function() to register a simple cleanup function to unlock your tables or roll back your transactions. Better yet, avoid the problem entirely by not using persistent connections in scripts which use table locks or transactions (you can still use them elsewhere).

    Älphämönkëy on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    In essence, the pros outweigh the cons.
    Pro : Cuts down on load time (and server demand) by a significant ammount
    Con : Possibility of weirdness if mySQL server crashes.

    It just seems to me that, of late, I've come into a LOT more "Cannot connect to the database" errors than I've ever seen. With the size of the active memberbase and the limited number of connections MySQL is set to handle, it just seems like it would cause more harm than good.

    But, once again, you know far more about this than I, and I'm just throwin' shit out there. :)

    Unknown User on
  • LegacyLegacy SCP Of The Digital Frontier The Grid(Seattle)Registered User, ClubPA regular
    edited February 2004
    They seem to be going rather slow at the moment...

    I got a phpBB error earlier...

    And now it's going sluggish.

    Legacy on
    Can we get the chemicals in. 'Cause anything's better than this.
  • SnowconeSnowcone Registered User regular
    edited February 2004
    I am getting this about every other time I click a link in the forums right now:
    phpBB : Critical Error

    Could not connect to the database

    Edit: I got about 25 of them trying to post and edit this message.

    Snowcone on
  • ExoVarkExoVark Registered User
    edited February 2004
    Well, the change I made tonight was changing mySQL to use pconnect. This should have been active, I think it was just an oversight. As to the other stuff, as HomeLAN is mySQL only I will be removing the other database functionality (mssql, oracle, access, pgsql) from phpBB and using some of the specific mySQL commands (joins and such). I will be using the fast and furious mod from phpBB hacks as a good source of inspiration, and, I will probably end up either spliting guest sessions into their own heap table, or removing them all together.

    There are more, but this is just preliminary.

    Can't say I like that idea.

    ExoVark on
  • bone daddybone daddy Registered User, ClubPA regular
    edited February 2004
    Snowcone wrote:
    I am getting this about every other time I click a link in the forums right now:
    phpBB : Critical Error

    Could not connect to the database

    Edit: I got about 25 of them trying to post and edit this message.

    I, too, am getting insane numbers of these messages while just navigating the forums.

    bone daddy on
    Rogue helicopter?
    Ecoterrorism is actually the single largest terrorist threat at the moment. They don't usually kill people, but they blow up or set on fire very expensive things.
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    bone daddy wrote:
    Snowcone wrote:
    I am getting this about every other time I click a link in the forums right now:
    phpBB : Critical Error

    Could not connect to the database

    Edit: I got about 25 of them trying to post and edit this message.

    I, too, am getting insane numbers of these messages while just navigating the forums.
    That is my fault. It was not an oversight on Ramius' part, but instead not using pconnect was a wise choice. The cluster is setup in a way that this would not be safe in high traffic times. Im still getting aquinted with the cluster and Im sure it will be a while before I figure out all of the peculirarities of it.

    I went into this knowing the potential gain and loss were high, this is a black and white issue, it works, or it doesnt, simple as that- I knew that going in. It doesnt work here. I didnt know that going in.

    Älphämönkëy on
  • incognitoincognito Registered User
    edited February 2004
    If you want to see real speed....
    ...turn off the waiting between post times :)

    incognito on
    My art thread.
    Janson: Listen bitches, just shut up and get back to licking my floor clean.
    I'm not dealing with your kind of crap today.
  • SzechuanosaurusSzechuanosaurus Registered User, ClubPA regular
    edited February 2004
    Man, I wanted to post the quote from when the first british motorway was opened and the guy was talking about how extreme speeds could wqarp peoples perceptions of reality and stuff but I couldn't find it.

    So I'll just post this instead.

    fast.jpg

    Tsk, how low brow of me :roll:

    Szechuanosaurus on
  • Texas Carnie RoadshowTexas Carnie Roadshow Registered User
    edited February 2004
    this whole thread makes me wish I'd learned tech-speak

    Texas Carnie Roadshow on
    oderint dum metuant
Sign In or Register to comment.