drtshock/gist:92594d658ee482e28839

## gistfile1.txt
[5/22/14, 12:45:32 PM] Bron_4: I been having some troubles with ChestShops and really bad timings, is this something you might be able to help with. not sure if we can maybe change it from a sqlite format to mysql , and if that would help. ( i think it might)
[5/22/14, 12:48:36 PM] Bron_4: Not sure what is the best way to tackle this issue, but its causing a ton of server stress.  Open to other ideas as well, I just ned this issue to stop  :)

From modding this plugin to totally having it redone is on the table
[5/22/14, 12:50:25 PM] Bron_4: Look how bad the timings are: http://aikar.co/timings.php?url=7502371
[5/22/14, 12:52:03 PM] Bron_4: when i wipe out the player database the lag goes away till the player file grows big again. Was thinking if we can get this into a mysql format instead of sqlite it might take care of the issue, i think its just taking to long to open this file as it grows in size.
[5/22/14, 3:09:14 PM] drtshock: did you ask the plugin author?
[5/22/14, 3:19:10 PM] Bron_4: he's basically quit and doesnt seem to really be that enthusiasic about fixing it
[5/22/14, 3:19:48 PM] Bron_4: i dont have time to wait, its a major problem for me
[5/22/14, 3:20:02 PM] drtshock: http://dev.bukkit.org/bukkit-plugins/chestshop/tickets/849-dev-build-major-resources-and-lag-when-user-db-file/
[5/22/14, 3:22:21 PM] Bron_4: Nice,  he just posted this to someone yesterday so wasnt optimisic.

Acrobot
1 day, 9 hours ago - 0 likes Like
@BBFChaser: Go Well, sure, I do keep the plugins updated all the time, I just stopped playing Minecraft recreationally somewhere around a year ago. I am, and still will update ChestShop for the upcoming updates.
[5/22/14, 3:22:53 PM] drtshock: so? i don't play minecraft anymore.
[5/22/14, 3:22:55 PM] Bron_4: I replied to he thread but i dont get any errors so, not sure thats gonna help him
[5/22/14, 3:22:58 PM] drtshock: i still update my plugins.
[5/22/14, 3:23:41 PM] Bron_4: Dont really scream its at the top of his priority list though,
[5/22/14, 3:24:54 PM] Bron_4: Looking for a solution in hours -days, not days -weeks. More optimistic that he replied though, maybe hes not abandoning it like 95% of other people do "when they quit playing"
	[5/22/14, 12:45:32 PM] Bron_4: I been having some troubles with ChestShops and really bad timings, is this something you might be able to help with. not sure if we can maybe change it from a sqlite format to mysql , and if that would help. ( i think it might)
	[5/22/14, 12:48:36 PM] Bron_4: Not sure what is the best way to tackle this issue, but its causing a ton of server stress. Open to other ideas as well, I just ned this issue to stop :)

	From modding this plugin to totally having it redone is on the table
	[5/22/14, 12:50:25 PM] Bron_4: Look how bad the timings are: http://aikar.co/timings.php?url=7502371
	[5/22/14, 12:52:03 PM] Bron_4: when i wipe out the player database the lag goes away till the player file grows big again. Was thinking if we can get this into a mysql format instead of sqlite it might take care of the issue, i think its just taking to long to open this file as it grows in size.
	[5/22/14, 3:09:14 PM] drtshock: did you ask the plugin author?
	[5/22/14, 3:19:10 PM] Bron_4: he's basically quit and doesnt seem to really be that enthusiasic about fixing it
	[5/22/14, 3:19:48 PM] Bron_4: i dont have time to wait, its a major problem for me
	[5/22/14, 3:20:02 PM] drtshock: http://dev.bukkit.org/bukkit-plugins/chestshop/tickets/849-dev-build-major-resources-and-lag-when-user-db-file/
	[5/22/14, 3:22:21 PM] Bron_4: Nice, he just posted this to someone yesterday so wasnt optimisic.

	Acrobot
	1 day, 9 hours ago - 0 likes Like
	@BBFChaser: Go Well, sure, I do keep the plugins updated all the time, I just stopped playing Minecraft recreationally somewhere around a year ago. I am, and still will update ChestShop for the upcoming updates.
	[5/22/14, 3:22:53 PM] drtshock: so? i don't play minecraft anymore.
	[5/22/14, 3:22:55 PM] Bron_4: I replied to he thread but i dont get any errors so, not sure thats gonna help him
	[5/22/14, 3:22:58 PM] drtshock: i still update my plugins.
	[5/22/14, 3:23:41 PM] Bron_4: Dont really scream its at the top of his priority list though,
	[5/22/14, 3:24:54 PM] Bron_4: Looking for a solution in hours -days, not days -weeks. More optimistic that he replied though, maybe hes not abandoning it like 95% of other people do "when they quit playing"