[MySql] Plugin help

[Joshua]

Hello, I am very new to MySql storage and search functions and I am trying to create a simple block logger plugin but when I place the stone it causes a lot of lag.
Everything is working though just drops the TPS by a lot with each use... Any tips on what I am doing wrong?

https://hastebin.com/akatizazud.csharp

 

[Sfvv]

Put the connection/Mysql function in async

 

[X1XX]

As the other person said, make it asynchronous/different thread. You can also look into batching sql insertions/caching block changes.

Resource for threads:

https://docs.oracle.com/javase/tutorial/essential/concurrency/runthread.html

Look into using Runnables with the bukkit scheduler.

 

[Galsk]

Hello, I am very new to MySql storage and search functions and I am trying to create a simple block logger plugin but when I place the stone it causes a lot of lag.
Everything is working though just drops the TPS by a lot with each use... Any tips on what I am doing wrong?

https://hastebin.com/akatizazud.csharp

Async, also any persistent storage of player logging should be done with UUIDs and not player names as they can change with different sessions.