Results 1 to 7 of 7

Thread: Tweaked the database this evening

  1. #1
    HEXUS webmaster Steve's Avatar
    Join Date
    Nov 2003
    Posts
    14,275
    Thanks
    291
    Thanked
    837 times in 473 posts

    Tweaked the database this evening

    Now, this will probably make no difference whatsoever, but the way in which database traffic is distributed is a little more sensible now, without sacrificing robustness.

    This should improve ad server and forum database performance.

    Do let me know if you perceive any difference
    PHP Code:
    $s = new signature();
    $s->sarcasm()->intellect()->font('Courier New')->display(); 

  2. Received thanks from:

    blueball (27-11-2011)

  3. #2
    Senior Moment blueball's Avatar
    Join Date
    Aug 2005
    Location
    Edinburgh
    Posts
    2,426
    Thanks
    846
    Thanked
    379 times in 294 posts
    • blueball's system
      • Motherboard:
      • Gigabyte Z270 - HD3P
      • CPU:
      • i7-7700K (4 x 4.2GHz plus HT)
      • Memory:
      • Team Group Vulcan T-Force 32GB (2x16GB) DDR4 PC4-19200C14 2400MHz
      • Storage:
      • 1TB Samsung 960 EVO NVMe PCIE M.2 plus Samsung 860 EVO 4TB SSD
      • Graphics card(s):
      • ASUS RTX 2080 Ti ROG Strix OC
      • PSU:
      • Corsair HX850 850 W Full Modular 80 Plus Platinum
      • Case:
      • Corsair Carbide 330R Ultra Silent Midi Tower
      • Operating System:
      • Win 7 Ultimate x64 (using wufuc to allow Win7 to run on this CPU)
      • Monitor(s):
      • BenQ GW2765HT LED IPS 27 inch 2560x1440
      • Internet:
      • Virgin Media 380Mb

    Re: Tweaked the database this evening

    forum is definitely much snappier. Well done.
    Rgds,

    BB
    Hexus Trust here and here

  4. #3
    DILLIGAF GoNz0's Avatar
    Join Date
    Jun 2006
    Location
    Derby
    Posts
    10,872
    Thanks
    632
    Thanked
    1,192 times in 945 posts
    • GoNz0's system
      • Motherboard:
      • Asus Rampage V Extreme
      • CPU:
      • i7 something X99 based
      • Memory:
      • 16gb GSkill
      • Storage:
      • 4 SSD's + WD Red
      • Graphics card(s):
      • GTX980 Strix WC
      • PSU:
      • Enermax Galaxy 1250 (9 years and counting)
      • Case:
      • Corsair 900D
      • Operating System:
      • win10 64bit
      • Monitor(s):
      • Dell 24"
      • Internet:
      • 220mb Cable

    Re: Tweaked the database this evening

    faster, not quite there but about 5 times faster loading pages, 3-4 times faster than this and it will be on par with a few other forums i frequent, ones got about 50x the traffic of hexus and is fast as hell,

    if you can get it as fast as this site http://www.talkphotography.co.uk/forums considering how much more busy it is than hexus you will be on a winner

    Capitalization is the difference between helping your Uncle Jack
    off a horse and helping your uncle jack off a horse.

  5. Received thanks from:

    blueball (27-11-2011)

  6. #4
    Hooning about Hoonigan's Avatar
    Join Date
    Sep 2011
    Posts
    2,269
    Thanks
    161
    Thanked
    432 times in 306 posts
    • Hoonigan's system
      • Motherboard:
      • MSI MEG X570 ACE
      • CPU:
      • AMD Ryzen 7 3800X
      • Memory:
      • 32GB Corsair Dominator Platinum RGB
      • Storage:
      • 2x 2TB Gigabyte NVMe 4.0
      • Graphics card(s):
      • MSI NVIDIA GeForce RTX 2080 VENTUS OC
      • PSU:
      • be quiet! Straight Power 11 Platinum 750W
      • Case:
      • Corsair Crystal Series 680X
      • Operating System:
      • Windows 10 x64
      • Monitor(s):
      • Acer Predator Z35P + ASUS ROG PG279Q + ASUS ROG VG279
      • Internet:
      • Virgin Media Vivid 350

    Re: Tweaked the database this evening

    Holy crap Gonzo! That website is fast!!

  7. #5
    DILLIGAF GoNz0's Avatar
    Join Date
    Jun 2006
    Location
    Derby
    Posts
    10,872
    Thanks
    632
    Thanked
    1,192 times in 945 posts
    • GoNz0's system
      • Motherboard:
      • Asus Rampage V Extreme
      • CPU:
      • i7 something X99 based
      • Memory:
      • 16gb GSkill
      • Storage:
      • 4 SSD's + WD Red
      • Graphics card(s):
      • GTX980 Strix WC
      • PSU:
      • Enermax Galaxy 1250 (9 years and counting)
      • Case:
      • Corsair 900D
      • Operating System:
      • win10 64bit
      • Monitor(s):
      • Dell 24"
      • Internet:
      • 220mb Cable

    Re: Tweaked the database this evening

    i know, its as fast as my clan site, (my own rack server in londons docklands) and thats got about 30 people a day and about 10 posts with most trawl bots banned from looking!

    Capitalization is the difference between helping your Uncle Jack
    off a horse and helping your uncle jack off a horse.

  8. #6
    Senior Moment blueball's Avatar
    Join Date
    Aug 2005
    Location
    Edinburgh
    Posts
    2,426
    Thanks
    846
    Thanked
    379 times in 294 posts
    • blueball's system
      • Motherboard:
      • Gigabyte Z270 - HD3P
      • CPU:
      • i7-7700K (4 x 4.2GHz plus HT)
      • Memory:
      • Team Group Vulcan T-Force 32GB (2x16GB) DDR4 PC4-19200C14 2400MHz
      • Storage:
      • 1TB Samsung 960 EVO NVMe PCIE M.2 plus Samsung 860 EVO 4TB SSD
      • Graphics card(s):
      • ASUS RTX 2080 Ti ROG Strix OC
      • PSU:
      • Corsair HX850 850 W Full Modular 80 Plus Platinum
      • Case:
      • Corsair Carbide 330R Ultra Silent Midi Tower
      • Operating System:
      • Win 7 Ultimate x64 (using wufuc to allow Win7 to run on this CPU)
      • Monitor(s):
      • BenQ GW2765HT LED IPS 27 inch 2560x1440
      • Internet:
      • Virgin Media 380Mb

    Re: Tweaked the database this evening

    Quote Originally Posted by GoNz0 View Post
    if you can get it as fast as this site http://www.talkphotography.co.uk/forums considering how much more busy it is than hexus you will be on a winner
    Cheers, just signed up for that one
    Rgds,

    BB
    Hexus Trust here and here

  9. #7
    HEXUS webmaster Steve's Avatar
    Join Date
    Nov 2003
    Posts
    14,275
    Thanks
    291
    Thanked
    837 times in 473 posts

    Re: Tweaked the database this evening

    Hmmm, we've got the hardware. But we might struggle to get as fast as that site, seeing as it looks like we have more plugins installed.

    That said I'm not afraid to nuke/fix any that slow things down. If there's a good profiler for vbulletin let me know. Otherwise I might write one.
    PHP Code:
    $s = new signature();
    $s->sarcasm()->intellect()->font('Courier New')->display(); 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •