EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Bugs (https://www.eqemulator.org/forums/forumdisplay.php?f=622)
-   -   A Thought (https://www.eqemulator.org/forums/showthread.php?t=1175)

_OZZY_ 04-15-2002 12:16 AM

A Thought
 
This is probably not gonna happen anytime in the near future for any server except GotFrags, but....

Over time, with people logging in to a server and setting up accounts, your database is gonna be chock full of stale accounts. People who have'nt logged in in months, yet you have no idea who's who. My suggestion is to put some sort of "Last Accessed" field in the login_accounts table. The admin tools can then (after being coded to) purge all accounts that are too old.

Just an idea I had...

Shortlived 04-15-2002 01:48 PM

Just curious. Do these "old accounts" create lag?
also how much space do they take up?

devn00b 04-15-2002 01:50 PM

I wouldnt say they would create lag but they could create pauses during the username/password lookup if you had alot (seeing as it has to search the DB for your un/pwd)

They shouldnt take up much space the contain verry basic info.

Lurker_005 04-15-2002 02:45 PM

For now I would think 6 months to a year would be often enough to keep it from having any impact on things. In a year that may change though :D

_OZZY_ 04-15-2002 03:37 PM

Agreed. Right now it is not a concern of mine. But eventually it will be.


All times are GMT -4. The time now is 12:53 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.