search

plotly / falcon

Free, open-source SQL client for Windows and Mac 🦅
https://plot.ly/free-sql-client-download/
MIT License
5.13k stars 279 forks source link

SQLite performance is bad #309

Open titanomachy opened 6 years ago

titanomachy commented 6 years ago

For a SQLite database of 45MB in size I need to wait around 60 seconds before being able to type a 2nd query inside the editor. In between each action this happens. I am running it on an Asus Zenbook 3, no performance issues in other applications whatsoever. On an i7 octacore desktop the same experience. Too much lag to be of any use.

Maybe the Atom editor is not suitable for these kind of things? The editor itself has been plagued with performance issues (have been using Atom from the start on occasions). They rewrote a couple of performance critical parts in C++, but it still isn't stellar.

n-riesco commented 6 years ago

Could you check how much RAM is Falcon using after the first request, please?

Also, how many rows and columns are you retrieving in this query?

titanomachy commented 6 years ago

RAM is max 500MB, what I noticed is that Falcon is using 47%+ CPU when not doing any queries or rendering. I am retrieving 26000 records for 2 columns. I noticed Falcon is starting to slow down after a doing a couple of queries (5+) and especially when switching queries between tables.

edit: 235 MB RAM after a fresh start and running the query

n-riesco commented 6 years ago

I'm going to label this issue as a bug. We had recently another issue report #257 where Falcon became very slow. Unfortunately, we don't know how to trigger this issue.

I'll try and see if I can reproduce it using a query retrieving so many records.