antares-sql
Performance improvement (suggestion)
In earliest versions the app was pretty snappy in all operations. However with new releases it became progressively slower (both to launch and to execute common operations).
I understand that a lot has changed and with new functionality it's expected side effect, however it's becoming noticeably slower, so this is more of a suggestion to optimize the performance at some point.
Could you explain in what way it seems slower to you? Despite the new features, there should be no noticeable drop in performance. On my side I have never noticed anything, which is why I ask you to tell me what hardware and OS you use. I also ask anyone reading this issue who is experiencing similar problems to kindly provide me with feedback.
@Fabio286 Well, on MacOS (arm M1), just launching the app takes close to a minute sometimes (not measured, but felt like over 30 sec). On Ubuntu (on toaster laptop) is quicker, but still far from native apps (about 6-7 seconds until GUI is clickable). SSH connection takes about 3-4 seconds and sometimes (rarely) fails (still can't guess at what point it decides to fail) while other tools do it in less than a second (both on MacOS and Ubuntu). Sorting on column also takes a while (3-4 seconds or more if the table is big).
Those are the ones I usually use, so those are on top of my head, but perhaps there there are other cases. And i'm certain earlier versions were quicker, because it was the reason i stuck to using Antares (apart from the pretty UI).
And just earlier today because of the sorting issue i decided to switch to another tool and the speed difference in the same operation was huge => one did each operation in fraction of a second, while Antares took few seconds for every operation.
Can you tell me if you notice the slow sorting only when using ssh or also when you connect directly?
Here are some numbers from Antares on Ubuntu (just noticed it had this):
Connecting to SSH took about 4s. Local was instant.
Loading small table data (<200 results) over SSH : 11-18s (seems it's different every time)
Loading same table with more data locally: pretty fast
Sorting seems to show time it took only for over 1000 results and not show it if under 1000 and seem to be faster in ASC order, but slower in DESC order. In current test it took between 0.2 and 1 seconds on SSH (on 40k row table) and 3 times less locally (on a 150k rows table). But i think this varies, because it's fast on some (smaller) tables and faster on other (bigger) tables (sorting on the same column). But in general local sorting is much faster, yes. And sorting under 1000 rows seems to be pretty fast both over ssh and locally.
PS: i switched the tool because it could sort, not because sorting specifically was faster.
At this point I will start doing some testing to understand the reasons behind this slowness in ssh. I should mention that a few months ago I had experienced slowness connecting via ssh to a Postgres db. I thank you for the appreciation and anyway this slowness is a bug to be fixed. Otherwise it is the startup times, which I can try to optimize, but they will never be like native apps for reasons related to the nature of Electron.
Have you considered tauri framework instead?
To consider Tauri i have to learn Rust and rewrite half of the application with it.
To consider Tauri i have to learn Rust and rewrite half of the application with it.
I think the rust part is only needed if you want to write some backend logic in it otherwise it can act like a wrapper just like electron. Am I missing something?
To consider Tauri i have to learn Rust and rewrite half of the application with it.
I think the rust part is only needed if you want to write some backend logic in it otherwise it can act like a wrapper just like electron. Am I missing something?
All the part related to connections and queries to DBs is handled by a backend.
ubuntu snap launching in 2secs 16gb RAM ,11th Gen Intel® Core™ i5-1135G7 × 8 laptop
@Fabio286 I think on macOS the slow launch is due to not being arm version and running from rosetta ☹ initial launch takes forever because i guess it's doing the setup of rosetta and consecutive launch takes about 20-30 seconds, about 10 of which is waiting for the UI to render after the app window has already opened (but shows only back background until the UI shows).
VScode for example which is also electron based (but arm build) launches as fast as native app (perhaps even faster then some heavier native apps)