Make HUGE cities- With NO load times, Network usage, or processor taken.

[EmuGod]

-----------------------------------------------------
HOW TO MAKE A CITY AS LARGE AS YOU WANT WITH NO LOAD TIME WHEN YOU GET THERE.
---------------------------------------------------------

** So, you just made this completely L33T city, and it's looking sweet, everything is lined up perfectly, and it's the size of Storm wind. But, what's this. It's taking 20 MINUTES to load, is hogging your processor, and ram, and is lagging your server to high hell. How can you fix this? Simple...Read below, and follow the steps.

------------------------------------------------------------
1. You will HAVE to have database access to do this, and will NOT need anything else (except being able to spawn in game...that normally helps if you're worried about this kind of thing :P.)

2. Open your your servers WORLD DATABASE with whatever gui program that you have.

3. Open the Gameobject_spawns table, and sort the column labeled "ID" to be sorted ASCENDING.

4. Scroll to the bottom, and jot down the LAST 'ID' number. Jot this down in notepad for referencing later.

5. Close all of your database Gui programs application windows.

6. Go in game, and spawn whatever you want to your hearts content.

7. Once done, go BACK to the servers WORLD DATABASE and open Gameobject_spawns again.

8. Sort in ascending order again.

9. Scroll down to the number you recorded into notepad to be your last.

10. Copy every line below it. You can do this by clicking the first one underneath it, then while holding 'SHIFT' click on the VERY LAST one by using your scroll wheel to get to the bottom. You can also click th 'DOWN ARROW' and hit space per line as well, but, the shift trick is easier.

11. Make sure that you copy the data structure, not just the information. To do this. (I only know how to in Navicat) right click beside the 'ID' Number Column to the right (where the red circle is) and then select 'COPY.'


12. (DO NOT DELETE THE INFORMATION IN THE LINES FROM GAMEOBJECT_SPAWNS)Once you have copied all of the lines you need from Gameobject_spawns close it out, then go to Gameobject_staticspawns.

13. You will NOT need to sort this one at all as 99% of the time, ppl do not use it. If you DO have it used, just sort is ASCENDING, and scroll to the bottom.

14. Using the same method you did to COPY the information. You're now going to PASTE the information.

15. Once you click 'Paste' a confirmation window will pop up (in navicat...not sure about others) asking you "ARE YOU SURE YOU WANT TO PASTE THESE RECORDS?" Cick 'OK'.

16. Congratulations. Just restart your server, and go to the last area that you spawned all of the game objects at.

You'll notice that now, the MASSIVE city construct that you've built does not take up ANY load times, and only uses an incredibly slight fraction of your processor VS the (up to) 50% that it could. [and that's not mentioning the R.A.M, and lag it can cause on a network.]

I've tested this, and it works. I've also been able to prove (by spawning over 50000 go's) that this takes little to NO extra processor, network usage, OR eventual memory usage. It's a static map...just like the games.. So, it's data in incredibly small.

**EDIT** I also had someone ask if it's possible to perform this method with existing game objects. The answer is yes, you can do it with things (cities, and such) that you've made before. Just find the first, and last id of the go's that you spawned.

Hope you guys like my Guide. I know it saved me a TON of creation timing and efforts. hope it does you all as well.
Dracconus

TO THE SCEPTICS LIKE>>>BALLWINKLE
here are pictures taken before the Game master went to the area with cpu usage included for not ONE, but TWO servers, and a website(plus all of xp's crap)

----------------------------
BEFORE


After
---------------------------


Look at the chat logs, and processor log...it'll tell you everything you need to know. THIS DOES WORK.

[Ballwinkle]

this still will use more cpu usage..

[EmuGod]

Actually ...it doesn't. Read the post. I tried it with over 5000 go's bro. It'll use a VERY little bi of proc, but, it won't result in mega large load times, or a ton being used up at once.
All it will do is turn THIS...into this

[OMGPWN]

It workes! LOL! I tryed it with a whole bunch of random spawns and evrything stayed good my CPU and all. Thanks At first I thought this was saying how to put a mall into a SQL script and share with friends :P But this is just as good Thanks man so much! btw Ballwinkle it works..

Have to spread rep first

[EmuGod]

I'm not worried about Peoples opinions. I posted this for the people that want their server to lag less, not for the ones that want to be skeptics of stuff they haven't tried. :P JK JK. seriously. Yes, this does work. It's not a scam, or anything special. Just something I thought about, tried, and did.

[Gastricpenguin]

Excellent guide!
Next time, post it in the correct section :P
+rep nonetheless

[EmuGod]

Yeah, I made a copy, and requested a soft delete when I noticed what I did. Soz
Maybe it'd be possible to sticky this somwhere if ppl want, cuz it is a pretty l33t find. *not asking for personal gain. This will help a LOT of ppl. That's why I'm asking.

[OMGPWN]

Think this is true it does deserve a sticky because it isent a rev that comes and goes this can help evryone with there server management.. This is insane

[Cursed]

Awesome rep 3x

[djkajabaxd]

lol men this works very fine for me men i will rep you men, so much thanks =P

[Arrakis]

Insert into Gameobject_staticspawns select * from Gameobject_spawns where id > "max id from Gameobject_spawns step 4";

This would replace a few steps, and works in any DB-tool

[Xeneth]

I'm using this for my arena, works perfectly, Thisneeds to be pinned

[EmuGod]

That's just too much typing when I can just hit copy and paste bro...But, yeah, that works.

[Arrakis]

Hehe ... you gotto love the gui generation ....
Sorry ... old-school here ... i use a keyboard ....

Not only that, you can save the query and reuse it another time ... without having to repeat the more error-sensitive copy/paste/clipboard/slow mouseclicks

[EmuGod]

Well, I kinda get used to using the advantage of gui. I build websites, take care of my server, market my server, make videos, and assist others with their servers all day, so i can't have the glory that I'd like to to do it old fashioned. And, as far as querying the servers tables. Yes, I agree. That's a very good idea.