AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Store (https://forums.alliedmods.net/forumdisplay.php?f=157)
-   -   Purging inactive players from store database. (https://forums.alliedmods.net/showthread.php?t=231656)

vodka00 12-17-2013 21:30

Purging inactive players from store database.
 
I don't know about everyone else, but having near 13,000 users in my database it seems to bog down the server.

I think there should be a feature, a sql script or anything to purge inactive players. I think it would be of much help.

Groger 12-18-2013 06:51

Re: Purging inactive players from store database.
 
That shouldn't slow down the server, if its coded correctly. Deleting users is a bad idea imo. What sympthons do you get? Slow map loading or slow website?

vodka00 03-08-2014 21:38

Re: Purging inactive players from store database.
 
When I try to view the users page of my store webpanel, my browser just shits itself and dies. cannot do anything on that page, there are just too many users being displayed.
Tried accessing the users page on chrome and firefox with same results; both browsers shitting themselves to death. That page is inoperable for me due to the amount of users and it is very crucial for me to use that page.

I refuse to believe that I am the only one that is having this problem.

I propose couple of changes that should solve this nasty issue.

1. Add pagination to the users page, display 100 results per page or maybe let users pick how many they want to display.. 10, 50, 100, 500, etc.
2. Let us search people by their steam IDs and Auth IDs..

Problem solved.

JZServices 03-11-2014 05:17

Re: Purging inactive players from store database.
 
Quote:

Originally Posted by vodka00 (Post 2109464)
When I try to view the users page of my store webpanel, my browser just shits itself and dies. cannot do anything on that page, there are just too many users being displayed.
Tried accessing the users page on chrome and firefox with same results; both browsers shitting themselves to death. That page is inoperable for me due to the amount of users and it is very crucial for me to use that page.

I refuse to believe that I am the only one that is having this problem.

I propose couple of changes that should solve this nasty issue.

1. Add pagination to the users page, display 100 results per page or maybe let users pick how many they want to display.. 10, 50, 100, 500, etc.
2. Let us search people by their steam IDs and Auth IDs..

Problem solved.

This is the reason i stopped using this a long time back. Takes too long to read the db. I made a special plugin that will read and list. Also allows adding with pre-filled fields (or partial) for speed of adding.

LtDoomY 03-13-2014 20:30

Re: Purging inactive players from store database.
 
I just go into phpmyadmin every month and delete all users with under 10 credits. Makes everything load a lot faster. :D

Arrow768 03-16-2014 15:31

Re: Purging inactive players from store database.
 
I will add pagination to the webpanel as soon as I have time for it.

The best way to implement a auto purging option would be to add a last_seen filed at the users table and the option to delete users that have not been on the server for a certain amount of time.

vodka00 03-16-2014 19:16

Re: Purging inactive players from store database.
 
Quote:

Originally Posted by Arrow768 (Post 2112371)
I will add pagination to the webpanel as soon as I have time for it.

The best way to implement a auto purging option would be to add a last_seen filed at the users table and the option to delete users that have not been on the server for a certain amount of time.

Your reply was all that I wanted. Thank you :3


All times are GMT -4. The time now is 13:37.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.