March 28, 2024, 10:54:48 AM

1,531,609 Posts in 46,729 Topics by 1,523 Members
› View the most recent posts on the forum.


Yet another PM Purge

Started by Daddy, July 12, 2012, 04:19:45 PM

previous topic - next topic

0 Members and 1 Guest are viewing this topic.

Go Down

snoorkel

I don't think it requires a great deal of server resources for mysql to count, no

Daddy

Quote from: Fuck on August 13, 2012, 01:43:14 AM
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

Quote from: Far Beyond Repair on August 13, 2012, 02:16:33 AM
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

don't let's

Quote from: Khadafi on August 13, 2012, 10:05:35 AM
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?

PLEASEHELP1991

Quote from: Far Beyond Repair on August 13, 2012, 02:16:33 AM
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
I love [you]

snoorkel



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

a call to the post table is required for this.


post purge??

Snowy

no because I got the 1 millionth post and I intend to keep it that way

Daddy

Quote from: lifetrends on August 13, 2012, 12: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??
that only calls how large the table is akudood;

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

Nyerp

i think an admin purge is in order

Snowy


snoorkel

Quote from: Khadafi on August 13, 2012, 01:20:13 PM
that only calls how large the table is akudood;

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

Daddy

lightspeed isn't fast enough you faguoren. :(

WE NEED TACHYON SPEED

Go Up