Solved MySQL Help?

Discussion in 'Spigot Plugin Development' started by Leniency, May 22, 2016.

  1. I am planning on adding MySQL support to my plugin but I have several questions:
    1) When getting data from a MySQL server, I need it to be instant. If I get it from my MySQL server will there be a delay or will it be instant.
    2) How can I save an arraylist in a MySQL server?

  2. @Vexentric I had a host in Sweden and from my computer (I live in Slovenia) the delay was 2 sec. When everything was on localhost there was no delay.
  3. There will always be some delay of data being sent from A to B, just depends on where it is hosted. If it's on the same server than it will have near to no delay. With an arraylist you can store it as an Array, this could be useful. I don't use SQL anymore but MongoDB. It's faster (for most occasions) and an SQL Free system.
  4. Thanks for your answers. What I decided to do is cache the players data when the log in and remove it and upload to MySQL when they leave.