Re: KDEPIM with SQLite3

[Martin Steigerwald <martin@lichtvoll.de>]

Hi Eike, hi.

Eike Lantzsch ZP5CGE / KY4PZ - 18.12.24, 22:35:27 MEZ:
> Thanks,
> so I reckon that I can go on using PostgreSQL and if I like can migrate
> to SQLite3 later - is that right?

Exactly.

I'd recommend that even. Do one step at a time. Test KDEPIM 24.12 for some 
weeks and then, if you like, do the migration.

My latest setup with PostgreSQL was PostgreSQL 15. I was happy to migrate 
to SQLite 3, cause I got fed up having to upgrade PostgreSQL cluster every 
now and then. I do not like to be a database administrator just to use a 
mail program.

I was surprised by the immense improvement of the performance. I did not 
expect that. I have more than one and a half million of local mails and 
for the first time ever akonadi_indexing_agent actually completed the job 
to full text index them without bogging down even a very powerful ThinkPad 
T14 AMD Gen 5 laptop with Samsung 990 Pro SSD to an extent I gave up by 
stopping the indexing and chmod'ing akonadi indexing agent to 000. Also 
during daily use it is a difference as night and day.

Akonadi SQLite3 database is currently 2,4G, Xapian based search database 
is 12 GiB.

Best,
-- 
Martin