Speeding up your Server 101 (Windows)

MoravianLion · 2018-11-07T23:53:18.137Z

This is interesting! Thank you for posting!

I understand the basics of coding and trying (and successfully) to optimize a primitive code when I see one from other sources.

I don’t see any hitch warning on my server atm, so, my question is, does this worth the effort for me? Will the difference visible to me and others, when I am not in real need of changing things in this direction? I’ve found this topic by accident, rly.

Don’t get me bad, I just don’t wanna touch anything that is not broken…

Beardlife · 2018-11-18T17:06:04.854Z

I’m assuming this looks quite bad:

hitches1620×204 20.6 KB

Anyone know why is the duration so high or how would I go about fixing it. All of those resources are up-to-date except MySQL-aSync which was but I downgraded it to test if that is causing it. Happened also with that.

zr0iq · 2018-11-27T17:16:03.132Z

Either reporting to the github esx-drugs repo, or fixing it yourself and doing a PR. Some part of the code is just inefficient.

zeusx-dev · 2018-12-25T17:39:11.455Z

After adding indexes MySQL Slow Query still appears.

Shyricaus · 2018-12-26T11:11:12.462Z

it seems like yes, I did the test here that when I starto a smaller amount of scripts do not give

DTPL · 2018-12-30T22:34:19.262Z

Hey, i got problem with etwpackage…
No files are created so i cant read records…
end of message says “System cant find specified file”.
unknown%20(20)

Ludvig_Bartholdsson · 2019-02-23T09:44:11.952Z

Hey, nice tutorial! <3

I have done this; https://gyazo.com/88e7b5d9a816d48b8d93c70188e8245d
But… I get this "error"after it too. Any1 know?

Patrick_Jane · 2019-04-20T17:28:46.902Z

Hi! this is great, but how would i go about doing this in a linux server?

Thanks in advanced.

d0p3t · 2019-04-21T22:02:08.259Z

Unfortunately it’s not possible

Ponduzn · 2019-05-20T00:24:42.690Z

When i try to open the trace, WPA instantly shuts down again. any idea why ?
Edit:
Fixed it by reinstalling WADK, and repairing .NET framework

EpreeeN · 2019-06-03T19:44:02.461Z

[MariaDB:10.1.40-MariaDB] [esplugin_mysql] [48ms] UPDATE users SET bank=10200
how can I make fast it?

RyuShin · 2019-07-04T00:10:31.725Z

when I right click on the traces to open it, it close itself after 2seconds

Rubylium · 2019-08-02T14:10:39.064Z

Hey ! I’m not sure how to do the new index > green key on phpmyadmin, i can only connect to my BDD using PhpMyAdmin so if someone know, that will help me

image1307×290 51.3 KB

JasonO · 2019-08-06T01:23:07.690Z

See + Indexes at the bottom? There

Rubylium · 2019-08-06T08:33:46.381Z

Got it!
If I did understand well ( Probably not because I’m french but I did my best).
I can index all columns that do not move? For exemple, an column “Identifier” where the steam ID of the player is in it should never be changed, can I index that?

lyrics · 2019-08-19T06:24:35.048Z

any idea what could cause this? our indexes were fixed already

performance_badstuff

BathalaVault · 2019-10-04T15:34:59.051Z

help

Already indexed but still giving warning of 1000ms

snakez · 2020-04-20T14:26:17.121Z

is this good?

image1430×465 93.4 KB

because i have this warning

image575×519 22.5 KB

let me know how can i fix please

FastLearn · 2020-07-19T09:16:44.106Z

Guys when a player joins the server, I get hitch warnings. Only once though every time the server starts. Has anyone have a fix for this?

Vleaugs · 2020-08-02T12:24:15.788Z

Hello everyone, I’m getting a pretty diferrent problem, my connectors get a lot more duration.
And If I’ve no one logged into the server and continue receiving hitchs. I really don’t know what to do right now, I was with some problems with async, but now I fixed it.

Please someone help me ! Thanks !

problem duration ms ticks420×519 11.2 KB