wbernard / Memorado

Memorize anything

https://bernard.im/memorado

GNU General Public License v3.0

15 stars 6 forks source link

Performance issue (delayed typing) in the deck name field #63

Open amethystgosling163 opened 3 months ago

amethystgosling163 commented 3 months ago

https://github.com/user-attachments/assets/e42b81ea-419e-4f29-b2af-5f84ad9a300b

As you can see the performance issue only exists in the flashcard front and back input field but not in the deck name field.

My System Information

Hardware Information:

Hardware Model: Lenovo ThinkPad T440s
Memory: 8.0 GiB
Processor: Intel® Core™ i5-4300U × 4
Graphics: Intel® HD Graphics 4400 (HSW GT2)
Disk Capacity: 1.0 TB HDD

Software Information:

Firmware Version: GJETA4WW (2.54 )
OS Name: Fedora Linux 40 (Workstation Edition)
OS Build: (null)
OS Type: 64-bit
GNOME Version: 46
Windowing System: Wayland
Kernel Version: Linux 6.10.3-200.fc40.x86_64

valeb commented 1 month ago

The issue is linked to the fact that the SQL DB is called on every keystroke. This could be refactored to perform a "cheap" update on keystroke and only call SQL to "save". Help is appreciated :)