Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Bugs

Archive::Bugs Archive area for Bugs's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2002, 12:16 AM
_OZZY_
Hill Giant
 
Join Date: Jan 2002
Location: Shreveport, Louisiana, USA
Posts: 129
Default 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...
Reply With Quote
  #2  
Old 04-15-2002, 01:48 PM
Shortlived
Sarnak
 
Join Date: Apr 2002
Posts: 92
Default

Just curious. Do these "old accounts" create lag?
also how much space do they take up?
Reply With Quote
  #3  
Old 04-15-2002, 01:50 PM
devn00b's Avatar
devn00b
Demi-God
 
Join Date: Jan 2002
Posts: 15,658
Default

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.
__________________
(Former)Senior EQEMu Developer
GuildWars Co-Founder / World Builder.
World Builder and Co-Founder Zek [PVP/Guild Wars/City Takeovers]
Member of the "I hate devn00b" Club
Most Senior EQEMu Member.

Current Work: EverQuest 2 Emulator. Zeklabs Server
Reply With Quote
  #4  
Old 04-15-2002, 02:45 PM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

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
Reply With Quote
  #5  
Old 04-15-2002, 03:37 PM
_OZZY_
Hill Giant
 
Join Date: Jan 2002
Location: Shreveport, Louisiana, USA
Posts: 129
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:31 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3