sqlitebrowser/sqlitebrowser

Useless time consuming internal SQL-commands at start-up and at browsing data??

Open

#503 opened on 2016年1月22日

GitHub で見る
 (14 comments) (0 reactions) (0 assignees)C++ (2,334 forks)batch import
enhancementhelp wantedperformanceresponse requested

Repository metrics

Stars
 (24,039 stars)
PR merge metrics
 (平均マージ 14d 21h) (30d で 4 merged PRs)

説明

Hello,

I observed, that just opening a big sqlite-file tooks lots of time. At the SQL_Log panel I could see that SQLitebrowser first queries the sql_temp_master table, which is ok for me, but then also automatically queries the first table inside the db file. Just to show me nothing else more than the entry panel with the file structure. I think the last query is pretty useless, cause switching to data panel issues the query for the first table again!

Second: If then I will have a look at the data and right-click on the table of choice and clicking Browse Table then SQLitebrowser issues 2 queries: 1st) for the last table (looked at or automatically queried by program start) and 2nd) for the actual table I want to look at. Again I think the first query is pretty useless!?

Or do I miss a point?

Regards Ralf

コントリビューターガイド