sourcebans-pp icon indicating copy to clipboard operation
sourcebans-pp copied to clipboard

[Optimization] Single database handle for all SB plugins

Open rumblefrog opened this issue 7 years ago • 0 comments

Is your feature request related to a problem? Please describe.

As approached by few users, SourceBans++ currently have 4 plugins that each individually create their own database handle, on a large scale, 5 servers can easily take up ~20 connection slots on a MySQL database, assuming it reuses the handle correctly

Describe the solution you'd like

Natives within the main plugin for retrieving database handles, status, etc

Example typedefs:

native Database getDBHandle();

native bool isDBConnected();

Describe alternatives you've considered

  • I've discussed bumping connection limits with users, however, this is quite impossible on shared hosting

Additional context

rumblefrog avatar May 15 '18 02:05 rumblefrog