How to open a large sqlite file?

Question

SQLite

Hi everybody!
Essence of the question: there is a large (> 30 GB) sqlite file (to be more specific, lgd is a 1C log) and you need to open it and find / filter the necessary data. In principle, it opens with any appropriate program, but when you try to view (and filter) the largest table, it hangs more often, although sometimes it opens. If you make a request, the result is the same.
So far I've tried DB Browser for SQLite and SQLiteStudio. Perhaps there are some programs that, when opened, do not try to load the entire file at once, but load the data as they scroll or search / filter.

PS There is a workaround (open the file in the same 1Ce and save it in small parts, for example, for months), but it will also take a lot of time.

Answer 1

Try the console client .

Answer 2

If you make a request, the result is the same.

What request are you making? Add the `LIMIT , ` construct to it and get the data in chunks.
We need to look at your request. Suddenly there is a full join and everything, of course, does not fit into memory.