TanguyOrtegat / esx_jb_eden_garage2

41 stars 50 forks source link

Lot of MS used #38

Closed Rubylium closed 4 years ago

Rubylium commented 5 years ago

Soo, after doing some research on my server hitch time warning, i found out that i got 2 ressource eating up my server load, and one is yours image

TanguyOrtegat commented 5 years ago

you are using version 1 or 2? (thanks for reporting)

and are you using sql command to reset vehicles entries at each reboot ?

Rubylium commented 5 years ago

i'm using version 2 And if it's not in the script by default, i didn't create any command to do that, and if it's in the script, well i never used it befor 🤔

TanguyOrtegat commented 5 years ago

hmmm weird, i ll look into it when i am back from vacation

ElPumpo commented 5 years ago

for example @TanguyOrtegat:

https://github.com/TanguyOrtegat/esx_jb_eden_garage2/blob/master/esx_jb_eden_garage2_sv.lua#L44

you select * and use vehicle props but instead you could use the plate column.

oumuamuax commented 5 years ago

fixed?

TanguyOrtegat commented 5 years ago

fixed?

tried to fix it, should be better now but idk if it is really fixed @Rubylium could you give us an update ?

iSentrie commented 5 years ago

Just start ft_libs after garage, no issues that way

Rubylium commented 4 years ago

Forgot about this sorry. After some search i found out that this is mainly due to SQL Sync request, exemple : MySQL.Sync.execute("UPDATE owned_vehicles SET stored=true WHERE stored=false", {})

It's way better to use Async SQL request to prevent high MS usage :)

TanguyOrtegat commented 4 years ago

oh great :)