Slowdown when deleting in the UI

[PeterSurda]

Deleting messages individually causes too much CPU usage. I narrowed it down to propagateUnreadCount in src/bitmessageqt/__init__.py. I remember doing performance tests, so it must have broken since then.

[g1itch]

It seams you mean bitmessageqt not bitmessagemain. I noticed that adding many messages also causes heavy CPU load.

[PeterSurda]

Yes.

[dimyme]

you could use --curses mode (with my fixes) and delete there. seems to work better... ;-)

[g1itch]

Not sure if that related... I thought of adding indexes for frequently used fields in messages.dat, e.g.

create index inbox_read on inbox (read);
create index inbox_folder on inbox (folder);
create index inbox_read_toaddress on inbox (read, toaddress);
create index inbox_toaddress_folder on inbox (toaddress, folder);
create index inbox_fromaddress_folder on inbox (fromaddress, folder);

But when I opened class_sqlThread I realized that it requires a heavy cleanup work. So that's still work in progress in my home repo.

BTW, when I delete a message I see maximum 3% CPU load in SQL thread, it seems not too much compared to ~ 65% when I click any inbox folder.