Just an addendum.
you mentioned an entire table being loaded into memory. I have to look further
into this. I use the c layer of sqlite3 for swift. Not sure if this sheds any
more light into the memory loading factor.
On 1 Nov 2018, at 9:39 pm, Taksan <taksantong@xxxxxxxxx> wrote:
You are correct. I just want to add an extra detail: some programming
languages use some database libraries, that,if not used correctly, may
load an entire table into memory when you try to access them. Also, if
your sql is not properly defined with a good "where" clause you may be
getting too much data..... so you are correct in a "general" sense,
but if you want a more specific answer you may need to provide more
specific details on what you are doing.
On 11/1/18, Dzhovani <dzhovani.chemishanov@xxxxxxxxx> wrote:
Yes, only indexes and cache would be loaded in the ram.** To leave the list, click on the immediately-following link:-
Is your app required to work offline?
On 1.11.2018 г. 12:45, Yuma Decaux wrote:
Hey all,** To leave the list, click on the immediately-following link:-
I'm sure this is also relevant to sqlite, but here goes.
When opening a connection to an sql/sqlite database, I am not having the
entire database loaded to memory, and the queries and results are purged
when I close the connection. Am I correct in assuming this?
Just asking as I have a rather large database I am fitting on a smartphone
app, though I have minimised the load, and just want to Mae sure my above
assumption is correct.
Any help greatly appreciated
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
