I would think that is a ‘mileage varies’ sort of issue based on your computer specs and in the case of remote access, network latency, which is variable for anyone. I don’t think a hard comparison is possible as a generalized statement, there are just too many variables.
If you’re looking for personal anecdotes, I prefer sqlite3 over xml on MacOS, but that’s for the ability to query the db. I suppose it performs equally well best I can tell. I never shut the app down save for rare occasion or experimentation, so I can’t attest to load times. Regards, Adrien > On Aug 16, 2018, at 10:19 PM, MycoGeo <[email protected]> wrote: > > Do people have experience with different load/save times with the different > formats? > > A long while back, I experimented with storing gnucash data on a MySQL server > on a NAS, so it was over the LAN. I didn’t find the save/load times > different than saving/loading from the compressed XML format on the local > machine. > > Gnucash 2.x.16 > Windows 10 > > > Sent from my iPad > >> On Aug 16, 2018, at 7:20 PM, David T. via gnucash-user >> <[email protected]> wrote: >> >> John, >> I don't understand your statement. >> Insofar as a user might open the Guide immediately after installation (I'm >> not that self-aggrandizing as that), they would see in the second sentence >> of this section that xml is the default file format. >> Or did you have some other concern? >> David >> >> >> >> On Thu, Aug 16, 2018 at 18:53, John C<[email protected]> wrote: Please tell >> the reader the default file format right after installation. >> >> regards, >> John >> >>> On 8/16/2018 5:06 PM, Adrien Monteleone wrote: >>> Looks good to me. >>> >>> Regards, >>> Adrien >>> >>>> On Aug 16, 2018, at 3:00 PM, David T. via gnucash-user >>>> <[email protected]> wrote: >>>> >>>> I’ve attempted to incorporate the suggestions that others have made for >>>> the section on file storage formats, and I attach the resulting version 2 >>>> for further consideration. Keep in mind that this is not meant to be an >>>> encyclopedic coverage of the topic; it’s meant to outline the choices. I >>>> expect further detail to reside on the wiki, or be placed in other places >>>> in the documentation. >>>> >>>> Cheers, >>>> David >>>> >>>> P.S. The table layout doesn’t come through, but will be in the final >>>> version… >>>> >>>> >>>> ———————————— >>>> >>>> 2.5 Storing your financial data >>>> 2.5.1 Overview >>>> GnuCash offers several formats for storing your financial data. The >>>> default file storage format is XML, while SQL storage is available in >>>> SQLite, MySQL, and PostgreSQL formats. Users can choose a file format from >>>> the File→Save and File→Save As dialogs. >>>> The XML storage format is a text file that is compressed with gzip, which >>>> is a preference that is set at Edit→Preferences→General→Use file >>>> compression. SQL storage is available via the DBI back end; use of MySQL >>>> and PostgreSQL requires installation of those DBMS packages as well as >>>> additional DBI drivers. >>>> Note: users can change the format at any time by using File→Save As. This >>>> will create a copy of the data file in the selected format. >>>> >>>> Storage Comparison >>>> Each storage format has benefits and shortcomings that the user should >>>> consider for their needs and abilities. See the Storage Comparison Table >>>> below for further details. >>>> The XML format is the most stable and established, and for this reason, it >>>> is recommended for most users. SQL stora > > _______________________________________________ > gnucash-user mailing list > [email protected] > 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. _______________________________________________ gnucash-user mailing list [email protected] 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.
