August 21, 2018, 03:12:42 PM

1,526,559 Posts in 45,775 Topics by 1,031 Members
› View the most recent posts on the forum.


Yet another PM Purge

Started by Khadafi, July 12, 2012, 07:19:45 PM

previous topic - next topic

0 Members and 1 Guest are viewing this topic.

Go Down

Lifetrends

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




Khadafi

Quote from: Fuck on August 13, 2012, 04: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, 05: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, 01:05:35 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?

PLEASEHELP1991

Quote from: Far Beyond Repair on August 13, 2012, 05: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]

Lifetrends



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

Khadafi

Quote from: lifetrends 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??
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


Lifetrends

Quote from: Khadafi on August 13, 2012, 04: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




Khadafi

lightspeed isn't fast enough you faguoren. :(

WE NEED TACHYON SPEED

Go Up