You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Originally posted by mtirfan66 May 1, 2024
Hi,
The sqlitestudio works great with me. I have the latest version 3.4.4. I have two issues which I wanted to check with everyone to see if I am doing everything right. The first one, described below, is on opening a large database in the studio. The second one is on copying a table from one database to another.
Here are the details of the first problem.
I have a large data file - about 370 mb in size with over 5000 tables each with 200 rows. Each table has a primary key, they are not related to each other though. The file gets updated roughly one to two times each month.
I need to look at the data frequently though, by opening the file in the studio and opening the tables that I need to look into.
It takes quite a bit of time each time I open this database in sqlitestudio by double clicking on the .db file.
Is there something I can do to the database (other than splitting it) to accelerate the loading of it in the sqlitestudio? Is it possible to load it once and access it later without having to reload even though the sqlitestudio (and, the device) is closed/shutdown in between?
Thanks, in advance.
-Irfan
</div>
The text was updated successfully, but these errors were encountered:
Discussed in #4978
Originally posted by mtirfan66 May 1, 2024
Hi,
The sqlitestudio works great with me. I have the latest version 3.4.4. I have two issues which I wanted to check with everyone to see if I am doing everything right. The first one, described below, is on opening a large database in the studio. The second one is on copying a table from one database to another.
Here are the details of the first problem.
I have a large data file - about 370 mb in size with over 5000 tables each with 200 rows. Each table has a primary key, they are not related to each other though. The file gets updated roughly one to two times each month.
I need to look at the data frequently though, by opening the file in the studio and opening the tables that I need to look into.
It takes quite a bit of time each time I open this database in sqlitestudio by double clicking on the .db file.
Is there something I can do to the database (other than splitting it) to accelerate the loading of it in the sqlitestudio? Is it possible to load it once and access it later without having to reload even though the sqlitestudio (and, the device) is closed/shutdown in between?
Thanks, in advance.
-Irfan
The text was updated successfully, but these errors were encountered: