[Libreoffice-bugs] [Bug 134421] Replace xcu settings storage with sqlite database

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134421

Telesto <telesto at surfxs.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mikekaganski at hotmail.com

--- Comment #6 from Telesto <telesto at surfxs.nl> ---
(In reply to Miklos Vajna from comment #4)
> > Replace xcu settings storage with sqlite database.
> 
> I would say this only makes sense if somebody is interested in doing the
> work, then profile it and demonstrate that the perf gain is indeed
> significant. I am not. :-)

I blindly copy/pasted the promotion text of SQLite... :-). I'm actually more
interested: *The application only has to load the data it needs, rather than
reading the entire file and holding a complete parse in memory.*

Ever monitored how often the xcu is accessed. It's an immense amount if times
(say 1000) times a day. File History/ Color Picker color/ Window/ toolbar
position and size. Toolbar items. On every time selecting an item in draw
(sidebar). A 'normal' xcu should be around 1 MB.. But with extensions and lots
of modifications and stuff .. 2/3 MB maybe

So 1000 MB of read/writes in a single session should be to abnormal.  

--
https://ask.libreoffice.org/en/question/145837/registrymodificationsxcu-writing-to-disk-excessively/

"We encountered same issue. about 200 PC users on other machiens with roaming
profile have this file "registrymodifications.xcu" constantly writing and
dumping our IO. Is there a way to make disable writing to this file in
configuration of Libre ? or editing some option in "registrymodifications.xcu"
?"

--

So not into really interested in the performance gain .. more like a being a
bit nicer to SSD's (even if the have technical read/write life time; which
maybe not to often hit (of course depending on SSD size etc)

However, proofing if SQLite would useful or not is far beyond my capability's I
can only assume, this based on other applications using this for storing
profile stuff. Nor can I asses the benefit of this in a local / or roaming
setup etc. Nor can I estimate complexity to code this kind of thing. Or if this
could qualify as GSOC project for example. 

So if the consensus within the (base) development team is, that this waste of
resource/ not worth the effort etc, please close. If the common dev opinion is
that it would make some sense to further investigate, leave it open..

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200630/ca58c33f/attachment.htm>