On Thu, 25 Nov 1999 11:55:26 CST, the world broke into rejoicing as
"Paul B. Brown" <[EMAIL PROTECTED]> said:
>
> > I'm just in my 10th month of using CBB, and it starts to slow down a
> > bit. Transfers are really getting slow (and I use them fairly often).
> >
> > I already have a mySQL database server running on my Linux box, and I
> > would really like to have CBB use that.
>
> Yet another point in favor of DBMS'. The scalability of DBMS' far out-
> strips that of flat files. For me, I have Quicken QIF3 files that date
> back to 1982. I would like to have those files imported into CBB so I
> can do some serious trending and data mining.
Extracting data out of CBB (or GnuCash) into a DBMS is a perfectly good
idea.
Trend analysis and data mining tend to be done using completely separate
databases. They don't use online data; they use data extracts *from*
the transactional systems.
People that try to do "data mining" in the R/3 system I help administer
get their processes *killed off* when we notice it... The priority
is for *payroll to run,* not for people to do after-the-fact analysis.
Those that do can buy separate DB servers, and we'll be happy enough to
extract data for them. (In the case of our payroll system, the folks
doing "after-the-fact" stuff are the pension group...)
The guys using SAS to do nonlinear regression to find out that putting
diapers and beer on adjacent displays is a Good Move don't need to
have up-to-the-second data, and the people that are trying to do data
entry certainly don't want the database locked up due to some idiot in
marketing having a DB query that went bad, generating some huge temp
table that blew out the DB server.
By having *separate databases,* everybody is left happy.
Data mining is an argument in favor of having a *separate* SQL database.
It doesn't favor integrating an RDBMS *into* CBB.
--
Pound for pound, the amoeba is the most vicious animal on earth.
[EMAIL PROTECTED] - <http://www.hex.net/~cbbrowne/lsf.html>
--
Gnucash Developer's List
To unsubscribe send empty email to: [EMAIL PROTECTED]
