On Thursday, 7 August 2025 05:46:04 Central European Summer Time Robin Laing wrote: > Do you feel that this will fix the issue of busy newsgroups that crash > PAN and then need to have the headers downloaded again? > > I hope so.
Pan with sqlite uses less memory, so it shouldn't crash due to memory issues. That said, I've not tested Pan and sqlite with big download. My test mostly uses articles that are already downloaded. i.e. I use the migration process where files in ~/.pan2/groups are read and stored in DB. My tests involve a group with about 400k article, and 22M headers. I've not tested much header download. It works, but I don't really know what happens during a crash when downloading. That said, a crash may corrupt the database. I've not seen it often, but it can happen. Since the DB contains servers, group and article, a corrupted DB means a restart from scratch (unless you have a backup). To limit the consequence of a corrupted DB, I think I need to split the DB in 3 separate files: - server (mostly filled manually by user) - groups - articles and headers Hopefully, only article and headers would be corrupted in case of a crash. Note that, as long as sqlite branch is not merged, I don't guarantee that the DB stays compatible. Updating the branch may mean that DB needs to be destroyed. All the best _______________________________________________ Pan-users mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/pan-users
