Welcome, Guest. Please login or register.
Did you miss your activation email?
February 18, 2018, 02:58:09 AM
1,514,165 Posts in 45,341 Topics by 1,070 Members
Latest Member: zelmarl69
Boyah Forums  |  Important  |  Announcements  |  Yet another PM Purge 0 Members and 1 Guest are viewing this topic. « previous next »
Pages:  1 2 [3]
Author Topic: Yet another PM Purge  (Read 4505 times)
Lifetrends
Director
*


Eager Beaver
Offline Korea, Democratic People's Republic of

infinitefluxury

Posts: 9,499
Quota: 0%
Doodthingocity: 42
Lüts: 171087.00

Mac OS X

Chrome 20.0.1132.47


« Reply #30 on: August 13, 2012, 06:09:16 AM »

I don't think it requires a great deal of server resources for mysql to count, no
Recent Track: IntroMercury's Odyssey - FloFilz
The Olympians
Logged


HARD AS ROCK COLD AS ICE AHHHH
Khadafi
Baphomet
Director
*


Solve et Coagula
Offline Male

JMV

Posts: 69,602
Quota: 1.11%
Doodthingocity: 53
Lüts: 182047.01

Android

Webkit


« Reply #31 on: August 13, 2012, 01:05:35 PM »

delete them already
I was waiting for everyone one to finish their videos for no excuses.  I've been out of state without a computer so I can't do it yet

Don't remind them


Although, wouldn't it be doing that anyway even if people had zero PMs? Or does it make a greater difference if a user has high numbers vs low numbers?
think of scrolling through 16000 entries on page load to count a user's pms versus doing so for 1000.

realistically its not a huge difference in time taken (eg 5 vs 30ms ) but when its busy while the database is slow it is a large factor
Recent Track: Can't Pin Me Down - Marina & the Diamonds
Logged

donʼt letʼs
Spectre of Dreams
Secret Muslim



Lowercase People
Offline United States Male

LiveOnTheEdge

Posts: 22,749
Quota: 0.89%
Doodthingocity: 15
Lüts: 9381.10

Windows Vista

Chrome 22.0.1221.0



Ignore
« Reply #32 on: August 13, 2012, 01:23:14 PM »

I was waiting for everyone one to finish their videos for no excuses.  I've been out of state without a computer so I can't do it yet
think of scrolling through 16000 entries on page load to count a user's pms versus doing so for 1000.

realistically its not a huge difference in time taken (eg 5 vs 30ms ) but when its busy while the database is slow it is a large factor

Shouldn't it have a more effective way of doing that sort of thing though?
Logged

PLEASEHELP1991
Yellow Halo
Dog in a Suit



Why?
Offline United States Male

felt

Posts: 11,767
Quota: 0%
Doodthingocity: 10
Lüts: 6740.00

Mac OS X

Safari



Ignore
« Reply #33 on: August 13, 2012, 03:10:48 PM »

Although, wouldn't it be doing that anyway even if people had zero PMs? Or does it make a greater difference if a user has high numbers vs low numbers?
POTY
Recent Track: Blue Wine - Nao
Logged

I love Guest
Lifetrends
Director
*


Eager Beaver
Offline Korea, Democratic People's Republic of

infinitefluxury

Posts: 9,499
Quota: 0%
Doodthingocity: 42
Lüts: 171087.00

Mac OS X

Chrome 20.0.1132.47


« Reply #34 on: August 13, 2012, 03:14:34 PM »



1,218,957 Posts in 38,313 Topics by 926 Members

a call to the post table is required for this.


post purge??
Recent Track: IntroMercury's Odyssey - FloFilz
The Olympians
Logged


HARD AS ROCK COLD AS ICE AHHHH
Snowy
Disorderly Avoidant



Offline Russian Federation Female

Snowy620

Posts: 27,874
Quota: 3.11%
Doodthingocity: 40
Lüts: 78556.00

Windows 7

Chrome 21.0.1180.75



Ignore
« Reply #35 on: August 13, 2012, 03:39:28 PM »

no because I got the 1 millionth post and I intend to keep it that way
Recent Track: Touch Me - The Doors
Logged

Khadafi
Baphomet
Director
*


Solve et Coagula
Offline Male

JMV

Posts: 69,602
Quota: 1.11%
Doodthingocity: 53
Lüts: 182047.01

Android

Webkit


« Reply #36 on: August 13, 2012, 04:20:13 PM »


1,218,957 Posts in 38,313 Topics by 926 Members

a call to the post table is required for this.


post purge??
that only calls how large the table is OUTSIDER

The pm one requires adding a "where member='Id';" and returning the number of results

and like I said its only for when database be slow
Recent Track: Can't Pin Me Down - Marina & the Diamonds
Logged

Nyerp
nyerpian proletariat (s c)
Christman



Offline United States Male

Nyerp

Posts: 46,863
Quota: 2%
Doodthingocity: -192
Lüts: 245898.42

Windows 7

Opera 9.80



Ignore
« Reply #37 on: August 13, 2012, 04:49:46 PM »

i think an admin purge is in order
Logged

Snowy
Disorderly Avoidant



Offline Russian Federation Female

Snowy620

Posts: 27,874
Quota: 3.11%
Doodthingocity: 40
Lüts: 78556.00

Windows 7

Chrome 21.0.1180.75



Ignore
« Reply #38 on: August 13, 2012, 04:52:03 PM »

i think an admin purge is in order
Recent Track: Touch Me - The Doors
Logged

Lifetrends
Director
*


Eager Beaver
Offline Korea, Democratic People's Republic of

infinitefluxury

Posts: 9,499
Quota: 0%
Doodthingocity: 42
Lüts: 171087.00

Mac OS X

Chrome 20.0.1132.47


« Reply #39 on: August 13, 2012, 04:52:50 PM »

that only calls how large the table is OUTSIDER

The pm one requires adding a "where member='Id';" and returning the number of results

and like I said its only for when database be slow

the point is these aren't the best places to improve efficiency spam

i'll install Litespeed on dis bitch and you'll never complain again
Recent Track: IntroMercury's Odyssey - FloFilz
The Olympians
Logged


HARD AS ROCK COLD AS ICE AHHHH
Khadafi
Baphomet
Director
*


Solve et Coagula
Offline Male

JMV

Posts: 69,602
Quota: 1.11%
Doodthingocity: 53
Lüts: 182047.01

Mac OS X

Chrome 20.0.1132.57


« Reply #40 on: August 13, 2012, 09:33:47 PM »

lightspeed isn't fast enough you faguoren. Sad

WE NEED TACHYON SPEED
Recent Track: Can't Pin Me Down - Marina & the Diamonds
Logged

Pages:  1 2 [3]
Boyah Forums  |  Important  |  Announcements  |  Yet another PM Purge « previous next »
    Jump to: