Good point and indeed doing it that way gives consistent sizes. I’ll let the client developer know.
> On Mar 1, 2024, at 9:24 AM, Derek Atkins <[email protected]> wrote: > > Hi, > > On Fri, March 1, 2024 9:21 am, Ira Fuchs wrote: >> My MySQL client shows tables sizes. > > I would never trust that different versions of databases would store it > the same way.. > > Use a Query to see how much data is in the table. For example: > > select count(*) from XXX; > > This will tell you how many rows are in the table, which will be MUCH more > accurate that looking at "table size." > > -derek > >> >>> On Mar 1, 2024, at 9:02 AM, Derek Atkins <[email protected]> wrote: >>> >>> What queries are you running to compare the two databases? >>> >>> -derek >>> >>> On Fri, March 1, 2024 8:53 am, Ira Fuchs wrote: >>>> They are precisely the same. No changes have been made during this >>>> test. >>>> One difference is that one MySQL is running 8.0.22 and the other is >>>> 8.0.36 >>>> but that should not affect the gnucash data table row numbers. >>>> >>>>> On Mar 1, 2024, at 8:38 AM, Derek Atkins <[email protected]> wrote: >>>>> >>>>> Hi >>>>> >>>>> On Fri, March 1, 2024 8:30 am, Ira Fuchs wrote: >>>>>> I have 2 instances of MySQL to which I save copies of my Gnucash >>>>>> data. >>>>>> I >>>>>> have gnucash open with an xml file and I do a save to the first >>>>>> instance >>>>>> and then I reopen the XML file and Save again, this time to another >>>>>> MySQL. >>>>>> In both cases the save proceeds normally after warning the file will >>>>>> be >>>>>> overwritten. I then examine the 2 files and in particular the number >>>>>> of >>>>>> records in the transactions, slots, and splits tables and find that >>>>>> they >>>>>> are different by 1000s of rows. (It doesn’t matter if I do the save >>>>>> from >>>>>> xml->MySQL(1)-MySQL(2) or xml->MySQL(1)-XML->MYSQL(2). >>>>>> Can anyone explain to me why there would be any difference in these 2 >>>>>> SQL >>>>>> files? >>>>> >>>>> I cannot explain why they are different, however, in case #2 have you >>>>> compared the two XML files to ensure they are the same? >>>>> >>>>> -derek >>>>> >>>>>> Please remember to CC this list on all your replies. >>>>>> You can do this by using Reply-To-List or Reply-All. >>>>> >>>>> -derek >>>>> >>>>> -- >>>>> Derek Atkins 617-623-3745 >>>>> [email protected] www.ihtfp.com >>>>> Computer and Internet Security Consultant >>>>> >>>> >>>> >>> >>> >>> -- >>> Derek Atkins 617-623-3745 >>> [email protected] www.ihtfp.com >>> Computer and Internet Security Consultant >>> >> >> > > > -- > Derek Atkins 617-623-3745 > [email protected] <mailto:[email protected]> www.ihtfp.com > <http://www.ihtfp.com/> > Computer and Internet Security Consultant _______________________________________________ gnucash-user mailing list [email protected] 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.
