Long #repop and zone times after source upgrade

[Bohbo]

@Akka

I am setting up a fresh W8.1 Box on a XEON 4gb machine Let me know if there is anything outside of the normal windows server install setup guide you want me to do.

[Akkadius]

You've never really said anything about what your using for disks, since I got home and was able to check I could see my writes were happening like that because its DELETING and REPLACE INTO constantly which is kind of horrid.

I have a M.2 SSD so my read speads are up 1000MB + and latency is nuts, so my repop's are pretty quick.

But, since repops happen potentially hundreds of times during the developing process, I'm going to look at getting them sped up quite a bit by optimizing the database end. I think everyone would appreciate this as a quality of life enhancement.

[Akkadius]

I will also make note that if you are using windows and you have any logs to 'console' enabled for MYSQL queries, that will definitely slow things down. Same thing for Perl, outputting to windows console is really slow.

If you have a shit load of quest errors like you posted before, and they are going to windows console, that is your problem.

Everything that we have enabled by default going to console is usually used sparingly given the cost consideration of windows console being slow.

If you want to see quests errors, I would highly recommend using gmsay because that is going to be a much faster medium to see realtime than the console

[Bohbo]

Originally Posted by Akkadius

I will also make note that if you are using windows and you have any logs to 'console' enabled for MYSQL queries, that will definitely slow things down. Same thing for Perl, outputting to windows console is really slow.

If you have a shit load of quest errors like you posted before, and they are going to windows console, that is your problem.

Everything that we have enabled by default going to console is usually used sparingly given the cost consideration of windows console being slow.

If you want to see quests errors, I would highly recommend using gmsay because that is going to be a much faster medium to see realtime than the console

Did you make any changes? I recompiled this morning with latest source 8 files changed 169 insertions 101 deletions and repops seem to be a lot faster already

Zone with 30 mobs is like 1-2 sec CB with 200 is like 2-4 so really great job (i assume this was you)

[Akkadius]

Yep, was me. Have more changes to make too.

[Akkadius]

Did some work to get these cut down dramatically to pretty much instant, will submit them shortly. I'm sure many will love this.