I always create a class module where I initialize the sql object and query the database (like most tutorials show), but this time I have many .db files that I want to read (45 and increasing). One solution would be to create 45+ sql objects (or inside a list) and a huge "if" condition to select the right object to do the queries, I'm not an expert but does not seem to be the best solution.
What are the memory consequences of having this amount sqlite databases opened?
The class is initialized in the "AppStart" of a non-ui application.
Beside the fact that the amount of databases is huge and could decrease by using more tables inside of a few .db files, what are other possible solutions?
Is it efficient to initialize and open a .db file each time I want to query it?
Thanks
What are the memory consequences of having this amount sqlite databases opened?
The class is initialized in the "AppStart" of a non-ui application.
Beside the fact that the amount of databases is huge and could decrease by using more tables inside of a few .db files, what are other possible solutions?
Is it efficient to initialize and open a .db file each time I want to query it?
Thanks