[ALOY-1693] Alloy: Prevent re-opening DB on queries

GitHub Issue	n/a
Type	Improvement
Priority	Medium
Status	Closed
Resolution	Fixed
Resolution Date	2019-11-19T15:14:52.000+0000
Affected Version/s	n/a
Fix Version/s	CLI Release 7.1.2
Components	n/a
Labels	n/a
Reporter	Gary Mathews
Assignee	Gary Mathews
Created	2019-06-20T22:50:50.000+0000
Updated	2019-11-19T15:14:52.000+0000

Description

- During sync, Alloy will open and close the database. Which is unnecessary and has an overhead of ~5ms. - We can prevent closing the database and maintain an open connection to the database.

Comments

Gary Mathews 2019-06-20

master: https://github.com/appcelerator/alloy/pull/933
Ewan Harris 2019-10-16

[~gmathews] I'm guessing this came about from observing a customer app? Do you know of anything internal that we can use to fully exercise this?
Samir Mohammed 2019-11-19

*Closing ticket*. Fix verified in CLI Version "NPM":"4.2.15-1","CLI":"7.1.2-7". Tested using the Alloy sample apps which can be found in the Alloy repo, applications ran fine with no performance issues. *Test Environment* MacOS Catalina 10.15.1 beta Xcode 11 Node.js 10.16.3 iphone 8 13.2 "NPM":"4.2.15-1","CLI":"7.1.2-7" SDK Version 8.3.0.v20191114073239

JSON Source