New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
1.9 slow opening 15Mb table #155
Comments
Hmm, there are no changes in Also check in the dialog title how many rows are loaded. Maybe 1.9.0 loads all data. You should go to |
No, the table contains only integer and text data. There are also 2 indices. Nothing special: CREATE TABLE "product" (
id integer PRIMARY KEY,
kind integer NOT NULL DEFAULT 1,
type integer NOT NULL,
format text NOT NULL,
extent integer NOT NULL DEFAULT 1,
name text NOT NULL,
active integer NOT NULL DEFAULT 0,
avalability integer NOT NULL DEFAULT 1,
list_price integer,
sale_price integer,
discount real,
tax_code text,
width integer,
height integer,
length integer,
weight integer,
packaging text,
addons text,
create_time integer NOT NULL DEFAULT (cast(unixepoch('subsec') * 1000 as integer)),
update_time integer NOT NULL DEFAULT (cast(unixepoch('subsec') * 1000 as integer)),
delete_time integer
);
CREATE INDEX product_create_time_idx ON product(create_time); I will try to replace sqlite3.dll with v1.82 and let you know about. |
I dumped and recreated the database from sql to exclude corruption. Then replaced sqlite3.dll for 1.82 in a clean sqlite-gui installation. Result is the same: 1.82 works fine but 1.90 hangs for 10-20 seconds independent of sqlite3.dll version. It's a pity. |
How many rows are loaded in both cases? |
In dialog title it shows 10000. In settings 10000 too. If I change it to 1000 the table is loaded much faster. |
1.82 also loads 10000 as in settings. |
I managed to repeat this error on Win10x64. I suppose that the issue is related to a common controls library (Windows standard library). 1.9.0 uses 6.0 instead of 4.8 (it allows to use stylized buttons and another input controls) but it also provides that problem :( Thanks for the report. P.S. I use Win7 and there is no change of loading time between 1.8.2 and 1.9.0. |
Great! Hope it can be fixed. |
Thanks for your great work. I was awaiting for the font rendering fix on scaled display and it's here now. Unfortunately some strange behavior occurs when double-clicking on table name in left panel. If table data is relative big (ca 100 000 records, 15MB) it hangs for ca 10-20 seconds with "(Not response)" label added in window title bar. I'm on en-US Windows10 64 bit. I've tried switching off real-time virus protection with no success. Only rolling back to 1.82 solved the problem. Any ideas?
The text was updated successfully, but these errors were encountered: