In my experience the amount of data is relatively small (even for thousands of records) and database performs well in XML form. As other people have said - it is copied into memory, So not much use putting it on proper RDBMS. I remember when I used it on MySQL over 100Mb connection on LAN (or even MySQL on the same laptop) there was a distinct lag in importing several hundred transactions, which was not there with XML or SQLite backend.
I found the best of both worlds is to use SQLite backend - because it is fastest and most portable - you just need to copy the file. It allows me to run quite complex reports from R using standard SQL approach. Even more - I made some bash scripts with SQL queries utilizing regexp support, that allowed me to quickly get some vital information on terminal - even without firing up gnucash. Best wishes, Roberts -- Dr Roberts Klotins On Thu, 19 Sept 2024 at 02:33, Chris Miller via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi Folks, > > The FAQ talks about PostgreSQL storage and how it was tired and > discontinued, but then tried again. This was around version 2 - 3. We are > now at version 5.8. > > Is there support for database storage? I see reference to sqlite3, > PostgreSQL, and MySQL. Sqlite3 is obviously supported, since I can simply > save my content as sqlite3 in preference to XML, but I'd really like to use > either PostgreSQL or MySQL, because, that makes GnuCash client server, and > probably lets me run on distributed client machines. If GnuCash can > communicate with a database, it probably doesn't matter where the database > is. > > What is the authoritative position for configuring database storage? Where > are the instructions about how to do it? > > Thanks for the help, > -- > Chris. > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > 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 gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
