Hello, I am pretty new to SQLite and I have to clear these question before I begin to move and port a big program from using a "bigger" database to my favourite SQLite:
When the program run, there are continuesly queries, inserts and updates At the moment I open 1 connection to the SQL Serv.. at the moment of login and I keep it open until the user exit the program. Can I do the same with SQLite, or do you suggest to open and close the connection every time I need it? Will I lose Performance? Thank you in advance, Giuly
