Alex Perry <[EMAIL PROTECTED]> writes:
> Does the engine cope with databases which are 6MB when in Quicken?
Since I don't know Quicken's average transactions/MB factor, I
couldn't really say. How many transactions are you talking about?
I've got a file that has several years worth of data, and has
thousands of transactions, but it's only about 500K.
It works fine, though I don't do anything fancy with it. There are
still bugs that cause some trouble (crashes in the GUI) now and then,
but AFAIK I've never saved a corrupted file.
The GUI used to load all of an accounts transactions into the GUI's
register window. When that was the case, things were fairly slow for
large numbers of transactions (on the order of 1000). When I
complained about it, Linas changed it so that the GUI only loads a
fraction of the data set (say the past few months), though you can
adjust it to show all the data just like it used to[1]. This solved
the practical problem, but ideally, I'd like to see a solution that
allowed you to load all the transactions into the register without
slowing down so much. Quicken can do this, and the only reason we
can't is that we need to make the GUI widget smarter. This problem
might be solved when we switch to GNOME if GtkSheet handles this
intelligently. (I haven't checked).
[1] Right now theres (IMO) a bug that makes the register re-load
everything after every keypress in the date range fields so that
to change 5/5/1999 to 5/5/1988, when you first type backspace to
delete the last 9, the entire register re-loads all the
transactions back to 198 (which is a long time ago). This should
be fixed...
> There have been suggestions that a generic SQL database
> can be bolted onto the back end. Has anyone done this?
No. It's certainly not the plan for the normal GnuCash configuration.
I asked about this a while back (I'm not too SQL knowledgable), and it
was quickly obvious that average users don't want to (and shouldn't
have to) handle the level of complexity that it would take to
administer a full blown SQL server (a la postgresql). Normal users
want their data in a data file on disk that they can see and
manipulate with standard file system tools.
--
Rob Browning <[EMAIL PROTECTED]> PGP=E80E0D04F521A094 532B97F5D64E3930
----- %< -------------------------------------------- >% ------
The GnuCash / X-Accountant Mailing List
To unsubscribe, send mail to [EMAIL PROTECTED] and
put "unsubscribe gnucash-devel [EMAIL PROTECTED]" in the body
