Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-14-2006, 01:52 PM
Ueguvil
Hill Giant
 
Join Date: Mar 2004
Posts: 139
Default Two questions (regarding MySQL and AAs)

1. (Really noob question, but...) Does the size of my database affect the performance of my server? There's many populated zones I never use, or plan on using, and will my server run faster if I wipe them out entirely?

2. I'm messing around with AAs, and I was wondering where my database is pulling the 'ability' in 'aa_levels' from? I've searched through AA.cpp and AA.h, but with no luck.

I'm on 6.0DR3 by the way, using the PEQ database. Thanks.
Reply With Quote
  #2  
Old 01-14-2006, 04:01 PM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default

Well. . . Technically, yes. A smaller database will allow the system to run faster in certain areas (basically anywhere where the server has to request info from the DB).

However, with the speed of today's computers and the power and scalability of MySQL, you're not going to have a noticable decrease in performance until your DB is very, very large. And by very, very large, I mean with hundreds of millions to hundreds of billions of records and poor maintenance.

Practically speaking, unless you're running an EQEmu server on a system that is just barely able to do so, trying to "clean up" your DB won't help. And even then, you're talking a barely noticable change.

Dunno about the AA question though.
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #3  
Old 01-14-2006, 06:58 PM
fathernitwit
Developer
 
Join Date: Jul 2004
Posts: 773
Default

AAs are a mess right now. If you wanna try to work on fixing up AAs, drop by IRC and talk to me.
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 11:35 AM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3