Skip to content

Stephen Baker

← Customer Feedback for GnuCash

My feedback

1 result found

  1. Investigate slow startup time and make it faster.

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  Feature Request  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Stephen Baker commented  · 

    The SQL got updated in Version 3.7. Now the time that it takes to load the data from a mysql database is reasonable. Still not blindingly fast, but comparable to loading from a file. That saved me from setting up a development for Version 3. The last time that I compiled was Version 2. There is a huge difference in required foundation packages.

    An error occurred while saving the comment
    Stephen Baker commented  · 

    I have found that the SQL executed to load all the data is extremely inefficient. On my data set, it takes almost 15 minutes to execute the SQL. Using a more efficient SQL statement returns the same data set in <1 second. This query is an ad-hoc statement cobbled together through string concatenation. I'm looking to see where else the function that creates this statement is used to determine if there are unintended consequences for changing the statement.

    slow:
    `SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM splits WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))`

    fast:
    `SELECT slots.* FROM slots, splits s, transactions t WHERE obj_guid = s.guid AND s.tx_guid = t.guid`

Feedback and Knowledge Base

(thinking…)