Quote:
|
Originally Posted by cannon
When you say optimize the database. I was reading where the gaps in numbers cause for memory loss (dont quote me on this) or something to that effect. Would you suggest sourcing any new info in the open spaces? (example the spawn2 entries that jump from 5000 to 30000 with nothing in between) or does this not matter? Also is there only certain tables that this would effect? I was just wondering if say you had all of the mobs from one zone together in the database in sequence so to say almost like defragmenting a hard drive would this effect the memory usage. I have 1024 ram and dont have much issues at this time. But I would like to be building up the database with all intentions of doing it the most effective way. Guess im getting into a long story that should have been short. Any insight would be helpful. Thanks again for all your help.
|
What happens is, your DB becomes a big memory hog and eats up a lot of memory - it probably slows down too.
I explained how I optimzed my database here;
http://www.eqemulator.net/forums/sho...455#post125455
and here;
http://www.eqemulator.net/forums/sho...462#post125462
These are just examples of what you need to do - If you can understand what I did, you will have no problem optimizing your DB.