Re: [GNC-dev] Convert Imap to Flat

Op woensdag 7 november 2018 01:10:03 CET schreef John Ralls: > > On Nov 7, 2018, at 5:52 AM, Geert Janssens > > wrote:> > > Op maandag 5 november 2018 23:27:31 CET schreef John Ralls: > >> That’s not to say that we shouldn’t also do everything we can to speed up > >> the code--it’s really slow--a

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

On 11/6/2018 3:54 PM, John Ralls wrote: > Read about SQLite3 locking: https://www.sqlite.org/lockingv3.html. > They’re locking virtual memory pages, totally independent of table or > record structure. In practice what that means is that at the > application level only using the SQL Transaction API

Re: [GNC-dev] Convert Imap to Flat

> On Nov 7, 2018, at 5:14 PM, Geert Janssens wrote: > > Op woensdag 7 november 2018 01:10:03 CET schreef John Ralls: >>> On Nov 7, 2018, at 5:52 AM, Geert Janssens >>> wrote:> >>> Op maandag 5 november 2018 23:27:31 CET schreef John Ralls: That’s not to say that we shouldn’t also do ever

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

> On Nov 8, 2018, at 6:42 AM, Craig Arno wrote: > > On 11/6/2018 3:54 PM, John Ralls wrote: >> Read about SQLite3 locking: https://www.sqlite.org/lockingv3.html >> . They’re locking virtual memory >> pages, totally independent of table or record structur

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

On 11/7/2018 1:42 PM, Craig Arno wrote: > Using a queue has other benefits if you find yourself in a situation... For the "offline" update usecase where the primary database is "server" based, a local SQLite database could be used for local offline work (travel receipt entry), which the database E

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

On 11/7/2018 3:43 PM, John Ralls wrote: > Always keep GnuCash’s target audience (Personal/Small Business) in > mind: We’re definitely not designing for “heavy database updates”. "heavy database updates" can be caused in a Personal/Small Business application when two asynchronous events arrive at t

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

> On Nov 8, 2018, at 9:00 AM, Craig Arno wrote: > > On 11/7/2018 3:43 PM, John Ralls wrote: >> Always keep GnuCash’s target audience (Personal/Small Business) in mind: >> We’re definitely not designing for “heavy database updates”. > > "heavy database updates" can be caused in a Personal/Sma

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

> On Nov 8, 2018, at 8:50 AM, Craig Arno wrote: > > On 11/7/2018 1:42 PM, Craig Arno wrote: >> Using a queue has other benefits if you find yourself in a situation... > > For the "offline" update usecase where the primary database is "server" > based, a local SQLite database could be used for

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

On 11/7/2018 4:14 PM, John Ralls wrote: > Not my understanding of “heavy database updates” (which would be > something like > 100K TPS), but OK. Yeah, I may not be using the right terminology, but look at my suggestions as generally correct if not using the right glossary.  In the database arena I'

Re: [GNC-dev] [GNC] mysql backend, second user (lock, for example)

> On Nov 8, 2018, at 9:57 AM, Craig Arno wrote: > > On 11/7/2018 4:14 PM, John Ralls wrote: >> Not my understanding of “heavy database updates” (which would be something >> like > 100K TPS), but OK. > Yeah, I may not be using the right terminology, but look at my suggestions as > generally co