MASSIVE performance increase of SQL data source

[ShadowDog007]

• Runs SQL queries in a separate thread every 5 ticks. Prevents connections to database blocking the main thread.
• Store references to TownBlocks within the TownBlocks table rather than in a giant string

Tested working.

Note that code has not been added to automatically update a users database.

[ElgarL]

This is a nice piece of code, however. It doesn't handle DB conversion so it breaks all older databases. It doesn't handle reload/restart so saving the queues will allow it to resume but it won't handle a restart.

[ShadowDog007]

Well fix it yourself then.

It was ridiculous what you were doing before. My friend had a 200KB string in his towny table.

[ElgarL]

The SQL implementation was simply a flat-file port. It has never been optimised. I'm commenting to say we don't accept partial fixes as pulls.

[ShadowDog007]

Well fix it yourself then.

It took me like 20 minutes to write that. You should have done it right in the first place.

[ElgarL]

Don't bring an attiutde here.

[ShadowDog007]

One more thing to note, not sure if plotPrice is handled correctly if it is taken from the town.

[ErgoAsh]

Is that fix is fully working now without changing something in database?

[ElgarL]

No it's not backwardly compatible, but we will incorporate this once time allows.

[ErgoAsh]

Thanks for response, I'm waiting.

[ElgarL]

Included most of this with my update to use prepared statements.