Database

Database handle explained

About

Since garages are dynamic, we've implement 2 options that you can choose:

• using queue system;

• dynamic;

How do they work exactly?

Dynamic

Dynamic is the mostly used one where every update for vehicle data manipulation (excluding the developer tools) updates database immedietely. This might be less beneficial for optimization since with larger user base you might get the server lag.

Queue

Queue system works different. It awaits specific time and gathers all data that should be updated and updates it after that specific time.

Additionally if one specific vehicle gets many different column updates such as park state or generally vehicle data it will be packed within one query.

You can also apply how the queue system applies updates to the database by choosing either asynchronous update where it awaits the previous query to be finished or by using timed one where there's an additional wait.

Setting

Firstly headover to the /shared/config.lua. If you want to use dynamic updates set:

Config.Database.UseQueueSystem = false

If you prefer to keep the queue system set:

Config.Database.UseQueueSystem = true