[GNC] Inconsistent MySQL databases

[Ira Fuchs]

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 <derek at ihtfp.com> 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 <derek at ihtfp.com> 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 <derek at ihtfp.com> 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
>>>>>     derek at ihtfp.com             www.ihtfp.com
>>>>>     Computer and Internet Security Consultant
>>>>> 
>>>> 
>>>> 
>>> 
>>> 
>>> --
>>>      Derek Atkins                 617-623-3745
>>>      derek at ihtfp.com             www.ihtfp.com
>>>      Computer and Internet Security Consultant
>>> 
>> 
>> 
> 
> 
> -- 
>       Derek Atkins                 617-623-3745
>       derek at ihtfp.com <mailto:derek at ihtfp.com>             www.ihtfp.com <http://www.ihtfp.com/>
>       Computer and Internet Security Consultant