Cost of frequest sqlite updates during gameplay?

Solar2D General Questions/Discussion
#1

I’m wondering if frequent updates to a local sqlite during gameplay is not a good idea?

Does anyone know whether the performance cost is significant, and I should consider tracking scores inside a lua table, and only doing sqlite updates on specific intervals, like on game over, or between maps? Does it matter in terms of performance?

Thanks for the input. [import]uid: 4596 topic_id: 9967 reply_id: 309967[/import]

#2

Although I can’t speak from direct experience, I would say that accessing the disk in that way should certainly be limited wherever possible. As you say it is probably best to temporarily store them somewhere and then save them out once at a non-gameplay moment. [import]uid: 5833 topic_id: 9967 reply_id: 36354[/import]

#3

@GrahamRanson thanks for your input = ) [import]uid: 4596 topic_id: 9967 reply_id: 36372[/import]