You need to provide a little bit more information for us to be able to help you out bud, this is just too little to actually help u.
If you have a few players, you will not suffer from 20 people
What do you need I can provide you
For you to talk some sence in the first place, please for the love of god.
What do YOU need help with, and provide more info on what you need help with.
The screenshot tells me jack shit its like… Hi i have a problem, but guess the problem for me!
Theres 100 things that could be causing this.
Can you please explain this to me
sorry my english is not good i don’t know how to explain it so I understand sever I only need to have 20 players to have this phenomenon on the blackboard
Please post a list of the resources you run on your server. Please do it as a hidden list:
like this
I suspect said list will be long.
177 pieces
How to paste in the list without being considered spam
start mapmanager
start chat
start spawnmanager
start sessionmanager
start fivem
start hardcap
start ■■■■■■■
start playernames
start baseevents
inserted trough ZAP ressourcesystem
#exec resources/vMenu/config/permissions.cfg
setr vmenu_bans_database_filepath "resources/vMenu/"
#start guidehud
#start trafficadjuster
start mysql-async
start essentialmode
start esplugin_mysql
start es_admin2
start FMODT
start hlabels
start npc_control
## From ESX Pack ##
start async
start cron
start es_extended
start esx_kashacters
start ShowOwnID
start Xmenkill
start CivLife-UberDelivery
#start lorraxs
#start AddOnPedSpawnMenu
start heli
start blackkey
##loading##
start guidehud
##map####
start lafa2k_modernhouse
##PED##
start cdvn
start csgt
start swat
start sheriff
#carnew#
start LamborghiniAventador
start monza
##donate##
start VettePD
start f11
start f1
start lambo
start wmfenyrcop
# Cars #
start H2R
start lx5701
start vip1
start vip4
#start vip5
#start police430
#start policevip
start lp770r
#start bc
start rmodmi8
start LC
start jes
start apollo
start divo
start exciter150
start bmwi8
start Audi
start p1gtr
#start polzonda
start polp1
##phone##
#start vdk_call
start esx_addons_gcphone
start gcphone
start instance
##MAP##
#start esx_swatjob
start esx_slots
#start vantruot
#start nightclubped
#start sawu_hookers
#start esx-qalle-sellvehicles
start eden_accesories
start skinchanger
start esx_accessories
start esx_addonaccount
start esx_addoninventory
start esx_inventoryhud
#start esx_phone
start esx_society
start esx_ambulancejob
start esx_animations
start esx_atm
start esx_bankerjob
start esx_barbershop
start esx_basicneeds
start esx_billing
#start esx_boat
start esx_boilerplate
start esx_clotheshop
start esx_datastore
start esx_dmvschool
start esx_drugs
start esx_scoreboard
start esx_bitcoinEN
#start esx_cuopFBI
start esx_vanchuyenmatuy
#start burglary
#start esx_burglary
start esx_holdup
start esx_identity
start esx_joblisting
start esx_jobs
start esx_license
start esx_lscustom
start esx_mechanicjob
start esx_menu_default
start esx_menu_dialog
start esx_menu_list
start esx_migrate
start esx_optionalneeds
start esx_policejob
start esx_property
start chat-theme-civlifechat
start esx_rpchat
start esx_service
start esx_shops
start esx_sit
start esx_skin
start esx_status
start esx_taxijob
start esx_vehicleshop
start esx_carthief
start utk_ornateprops
start utk_ornateheist
#start esx_voice
start vVoice
start esx_weaponshop
start malteser_cinema
start pNotify
start progressBars
start esx_lapdance
start esx_moneywash
start esx_strippers
start esx_doorlock
start zone
#start allcity_infokey
#start fivemqueue
#start esx_taximeter1
#start esx_hacking
#start NoDrivingCopCar
start Nomorenpcweapons
start irs-ui
start esx_locksystem2
start esx_extraitems
start esx_gangjob
#start logsystem
#start Radargunirs
start esx_didrik_foodplace
###start esx_AdvancedFuel
## End of ESX Pack ##
#start es_ui
start esx_discord_bot
start bob74_ipl
#start SexySpeedometer
start esx_nocarjack
#start esx_ladderhud
#start LegacyFuel
start frfuel
start esx_outlawalert
start prison-map-addon
start esx-qalle-jail
#start rolesFX
start Calm-AI
start disabledispatch
start discord
start SemArmasReward
start esx_jb_eden_garage2
start esx_mafia
start refund
start esx_borrmaskin
start esx_holdupbank
start esx_duty
start vehcontrol
start esx_tattooshop
start Weaponry
start esx_anticheat
start mythic_progbar
start mythic_notify
#
start irsCarHUD
#start script
start esx_customscript
start vSync
#start esx_inventoryhud_trunk
#start RadarWhileDriving
start irs_carwash
start NativeUI
start hrp_pd_impound
start progressBars
start setroannounce
start fivem-ipl
start esx_speedcamera
start irsholsterweapon
start esx_fishing
start MissionText
start esx_didrik_bbc
start esx_didrik_camera
#start esx_didrik_craftsystem
start esx_didrik_restaurant
#start esx_bennysjob
start esx_deliveries
start esx_nightclub
#start DBG_LesterJobs
start esx_marker
start qalle_coords
#start skincreator
start speedometer
#start hair
#start Mai
#start MaiT
#### ANDREAS ####
#start esx_andreas_interactionmenu
#start esx_andreas_bankfack
#start esx_andreas_bankfackshop
start esx_andreas_moonshine
start esx_andreas_blackmarket
#### MAPPAR-DESIGN ####
start Didrik_Vagskyltar
#start Didrik_Polisstation
start Didrik_Vagskyltar
#start Didrik_Polisstation
start Parken
start Mekonomen
start Burger
start Sjukhus
start Sjukhus_Props
start Sjukhus_door
#start Polisstation
start bilfirman
start ESX_CommunityService
#start PillboxHospital
#start VisualWeatherVoter
The short answer for you is as follows.
Step one: optimize your resources
Step two: in your database, in tables, make sure you have indexed key/commonly selected data.
Step three: continue to refine the above.
Without doing them, or knowing how to do them, no one can truely help you. Because it is not a “just do this” fix…
You are running scripts that aren’t well written. You need to remove them or optimize them.
Tips on optimizing: [Best practice] Improve your resource performance
Thank you I will try to follow what you show me
Do you know how to optimize vehicle files into a folder?
esplugin_mysql
-- Make sure you set this convar:
-- set es_enableCustomData 1
AddEventHandler('9deb1d51-d188-4ae7-8445-b32df2431098', function(identifier, callback)
MySQL.Async.fetchAll('SELECT 1 FROM users WHERE `identifier`=@identifier;', {identifier = identifier}, function(users)
if users[1] then
callback(true)
else
callback(false)
end
end)
end)
AddEventHandler('8656422a-0be8-4430-b5a8-3c2583c376b0', function(identifier, callback)
local Callback = callback
MySQL.Async.fetchAll('SELECT * FROM users WHERE `identifier`=@identifier;', {identifier = identifier}, function(users)
if users[1] then
Callback(users[1])
else
Callback(false)
end
end)
end)
AddEventHandler('7261e979-4ecc-4a99-a4b8-0c8ca22534b3', function(identifier, license, cash, bank, callback)
local user = {
identifier = identifier,
money = cash or 0,
bank = bank or 0,
license = license,
group = 'user',
permission_level = 0
}
MySQL.Async.execute('INSERT INTO users (`identifier`, `money`, `bank`, `group`, `permission_level`, `license`) VALUES (@identifier, @money, @bank, @group, @permission_level, @license);',
{
identifier = user.identifier,
money = user.money,
bank = user.bank,
permission_level = user.permission_level,
group = user.group,
license = user.license
}, function(rowsChanged)
callback()
end)
end)
AddEventHandler('59ebcb06-3435-4e02-9de1-15d1ff7c3551', function(license, callback)
MySQL.Async.fetchAll('SELECT * FROM users WHERE `license`=@license;', {license = license}, function(users)
if users[1] then
callback(users[1])
else
callback(false)
end
end)
end)
AddEventHandler('1cc0f30e-0e3d-4b4c-8210-854f140916b6', function(license, callback)
MySQL.Async.fetchAll('SELECT 1 FROM users WHERE `license`=@license;', {license = license}, function(users)
if users[1] then
callback(true)
else
callback(false)
end
end)
end)
AddEventHandler('c131c053-6c56-4565-9f1a-a9fe3a12ee88', function(identifier, new, callback)
Citizen.CreateThread(function()
local updateString = ''
local params = {identifier = identifier}
local length = tLength(new)
local cLength = 1
for k,v in pairs(new) do
if (type(k) == 'string') then
updateString = updateString .. '`' .. k .. '`=@' .. k
params[k] = v
if cLength < length then
updateString = updateString .. ', '
end
end
cLength = cLength + 1
end
MySQL.Async.execute('UPDATE users SET ' .. updateString .. ' WHERE `identifier`=@identifier', params, function(rowsChanged)
if callback then
callback(true)
end
end)
end)
end)
function tLength(t)
local l = 0
for k,v in pairs(t)do
l = l + 1
end
return l
end
SQL
-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 10.1.22-MariaDB - mariadb.org binary distribution
-- Server OS: Win64
-- HeidiSQL Version: 9.4.0.5125
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- Dumping database structure for essentialmode
CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
USE `essentialmode`;
-- Dumping structure for table essentialmode.users
CREATE TABLE IF NOT EXISTS `users` (
`identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
`license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`money` int(11) DEFAULT NULL,
`bank` int(11) DEFAULT NULL,
`permission_level` int(11) DEFAULT NULL,
`group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- Data exporting was unselected.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;