[GNC] Using a mysql database?

Jacob Larsen jacob at larsen.net
Wed Mar 13 16:22:10 EDT 2019


Ahh. It felt like it loaded faster from the database, but I just timed 
it and it is the same. In any case, the stalls on autosave are enough to 
switch to a database for me.

I have to add though that even if day-to-day writes to the database are 
instant then the initial import does take forever. Just one time though.

/Jacob

On 13/03/2019 19.52, D wrote:
> If you're hoping that the db version is going to load faster, you should probably abandon that. As I have been told, the startup for the db isn't faster because Gnucash still loads the entire file into memory at startup. Saves are instant, though.
>
> On March 14, 2019, at 12:11 AM, Jacob Larsen <jacob at larsen.net> wrote:
>
> Hi
>
> It is mainly to get around the long load times and stalls on autosaves
> for v3.x. But having it (sequentially) accessible from multiple PCs is
> an interesting bonus.
>
> I will have it accessible on WAN through an SSH tunnel too, but I
> suspect that the performance might not be very good here, so definitely
> not a primary use case.
>
> /Jacob
>
> On 13/03/2019 09.27, Colin Law wrote:
>> On Tue, 12 Mar 2019 at 22:42, Jacob Larsen <jacob at larsen.net> wrote:
>>> Hi
>>>
>>> How reliable is my data if I move from an XML file to a mysql database?
>> Do you have a specific reason for wanting to do that?
>>
>> Colin
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list