tgstation/-tg-station — pull request #5530 by Jordie0608 (2014-10-29 12:52:19+00:00)
Title: [MSO] Minor sql improvements.

PR'ing for MSO since he can't

Commits are atomic and lays things out, so im just gonna paste them here:

- Removes extra sql sanitize procs in favor of sanitizeSQL()
- Removes some sql related lag caused by too many clients connecting at once after a restart (and other minor fixes to client sql logic):
- Clients will now spread out their sql database connection logging and related ckey by ip/cid searching at world start so it doesn't all happen at once.
- Fixes a minor bug with related ckey searching where only one would be returned.
- Fixes a minor bug where related ckey searching would return the client's own ckey.

- Feedback reporting now uses 1 insert query with mutiple rows rather then making a new query for each feedback item.
- Each query can take between 25ms and 100ms, and this is a static per-query overhead, so removing the 60 or so needless querys will speed things up.