1 - Simple actions. We open Calc. We open the Base, open the Base table (about 100,000 records). While it is opening, none of the LibO windows are available. I can’t work in Calc! Next, Calc works with his table and makes a calculation (about 100,000 records). LibO application windows are again unavailable. I can’t work in Base! Finally, it was over. I close the Base table, and … it cannot close in any way. I just delete the process in the task manager…
2 - If everything is working properly. I close the Base table. The processor is loaded by about 35%-40%. The table closes in about 10 seconds. Finally closed.
3 - And that’s not all! Let’s open an empty Base table. And then we will close this table. The situation described above is repeated! The effectiveness of such work is reduced to 0 …
It’s very, very inconvenient to work like that. Why is this happening? Why don’t other apps spend so much time on simple actions - at least open, close? And do they not interfere with each other?
FORMAT DB: HSQLDB embedded, saved as ODB
Thank you all for your help! You helped me understand. I’m trying Firebird!
Version: 220.127.116.11 (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
EDIT_ebot - Text formatted