Money slow in saving data

I've seen a lot of complaints about slow reporting but my problem is the
slowness of saving new billing or withdrawal entries. Recording deposits
is usually much faster. I guess the number of that type of transaction
may have to so something with it. Anybody else having similar problems?
I use Money 2004, std edition.

R.P.

Dick
Sat Jul 19 20:09:16 CDT 2008

I would consider trying this: download and install, on a separate machine if
possible or in a separate directory--and be sure you have media to reinstall
M04 and do this SOON before Microsoft makes the service patches
disappear--the M+ trial version. Open a COPY of your data file with M+. Try
the Nuke the Bills tool. (See http://umpmfaq.info/faqdb.php?q=187 for more
info.) Then try entering data in your file. If it's remarkably faster, this
may point a direction for you. It's one that will force you to M07 or M+,
But if it gets you the performance improvement you seek, it MAY be
worthwhile. But read http://umpmfaq.info/faqdb.php?q=187 again before doing
anything rash.

"R. P." <r_pol12gar@hotmail.com> wrote in message
news:edB4fPE6IHA.1200@TK2MSFTNGP04.phx.gbl...
> I've seen a lot of complaints about slow reporting but my problem is the
> slowness of saving new billing or withdrawal entries. Recording deposits
> is usually much faster. I guess the number of that type of transaction may
> have to so something with it. Anybody else having similar problems? I use
> Money 2004, std edition.

R
Wed Jul 23 15:23:00 CDT 2008

"Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote:
>I would consider trying this: download and install, on a separate
>machine if possible or in a separate directory--and be sure you have
>media to reinstall M04 and do this SOON before Microsoft makes the
>service patches disappear--the M+ trial version. Open a COPY of your
>data file with M+. Try the Nuke the Bills tool. (See
>http://umpmfaq.info/faqdb.php?q=187 for more info.) Then try entering
>data in your file. If it's remarkably faster, this may point a
>direction for you. It's one that will force you to M07 or M+, But if it
>gets you the performance improvement you seek, it MAY be worthwhile.
>But read http://umpmfaq.info/faqdb.php?q=187 again before doing
>anything rash.

Oh, then I might as well just cough up the money for the latest version
and install that. I'm just not sure if it would automatically find and
import the data from the old install.

R.P.

Dick
Thu Jul 24 00:02:32 CDT 2008

I don't know that the answer its that simple or I would have recommended it.
Some people have real technical issues with M05 or higher. Others have
emotional issues with M05 (less so with higher versions). Nuke the bills
might not even solve the issue you came here with and even if it does it is
not a simple thing to go do if you have more than a few very simple
scheduled bills. Consider yourself advised. It's all I can do.

At any rate, to your comment, it SHOULD find your file and upgrade it to the
new versions format since it was the most recently used and the installer
looks for that in the older version's metadata. It does NOT "import" the
data. "Import" in Money's context is for a totally different and unrelated
operation. Always keep copies and backups. Never take anything for granted.

"R. P." <r_pol12gar@hotmail.com> wrote in message
news:O895eHQ7IHA.3692@TK2MSFTNGP05.phx.gbl...
> Oh, then I might as well just cough up the money for the latest version
> and install that. I'm just not sure if it would automatically find and
> import the data from the old install.

R
Thu Jul 24 15:37:13 CDT 2008

"Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote:
>I don't know that the answer its that simple or I would have
>recommended it. Some people have real technical issues with M05 or
>higher. Others have emotional issues with M05 (less so with higher
>versions). Nuke the bills might not even solve the issue you came here
>with and even if it does it is not a simple thing to go do if you have
>more than a few very simple scheduled bills. Consider yourself advised.
>It's all I can do.
>
> At any rate, to your comment, it SHOULD find your file and upgrade it
> to the new versions format since it was the most recently used and the
> installer looks for that in the older version's metadata. It does NOT
> "import" the data. "Import" in Money's context is for a totally
> different and unrelated operation. Always keep copies and backups.
> Never take anything for granted.

I have a feeling that the gradual performance degradation might be
caused by the database structure used to store data. I see the same kind
of degradation in Outlook Express which tends to take longer and longer
time to catch-up a larger news group. I suspect the same db structure is
used there too, to store and index the data.

R. P.

Dick
Thu Jul 24 21:32:49 CDT 2008

Surely the database is the issue. My experience was that Nuke The Bills made
a huge improvement. That improvement seems to be disappearing with time.


"R. P." <r_pol12gar@hotmail.com> wrote in message
news:%23GluE0c7IHA.1468@TK2MSFTNGP05.phx.gbl...
> I have a feeling that the gradual performance degradation might be caused
> by the database structure used to store data. I see the same kind of
> degradation in Outlook Express which tends to take longer and longer time
> to catch-up a larger news group. I suspect the same db structure is used
> there too, to store and index the data.

R
Thu Jul 24 21:56:27 CDT 2008

"Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote in
message news:%2369j26f7IHA.1080@TK2MSFTNGP06.phx.gbl...
> Surely the database is the issue. My experience was that Nuke The
> Bills made a huge improvement. That improvement seems to be
> disappearing with time.

I have not noticed major performance improvement though after I archived
last year's data and saved it in a separate file. This amounts to nuking
the bills, right? My experience is that Money does not handle frequently
repeating similar transactions, such as ATM withdrawals. Those take
forever to register but the infrequent deposits are registering fast.
This definitley suggest some type of inefficient DB indexing problem
just like indexing large news group discussion threads in OE. I used to
work with databases a lot a few years ago, and have seen this type of
behavior often. It usually required a redesign of the DB.

R. P.

Dick
Fri Jul 25 07:28:39 CDT 2008

See comments inline.

"R. P." <r_pol12gar@hotmail.com> wrote in message
news:%23T7C%23Hg7IHA.3696@TK2MSFTNGP04.phx.gbl...
> I have not noticed major performance improvement though after I archived
> last year's data and saved it in a separate file.

No one has ever reported a performance increase from archiving. No one has
ever reported any worthwhile effect from archiving. Many of us Just Say No
to archiving for these and lots of other reasons.

> This amounts to nuking the bills, right?

No. Did you read the link I sent you to?

> My experience is that Money does not handle frequently repeating similar
> transactions, such as ATM withdrawals. Those take forever to register but
> the infrequent deposits are registering fast. This definitley suggest some
> type of inefficient DB indexing problem just like indexing large news
> group discussion threads in OE. I used to work with databases a lot a few
> years ago, and have seen this type of behavior often. It usually required
> a redesign of the DB.

There are probably many of these kinds of issues in the Money database
design. It goes back to '92.

Bob
Fri Jul 25 09:41:33 CDT 2008

Dick, I have a feeling that Nuking the Bills is a one time fix but with no
ongoing benefit. The problem with the bills will, IMHO, start building up
again and at some stage one will have to perform another Nuke! :-(

--
Regards
Bob Peel,
Microsoft MVP - Money

For unofficial FAQs see
http://money.mvps.org/
or
http://umpmfaq.info/

I do not respond to any emails that I have not specifically asked for.

"Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote in
message news:%2369j26f7IHA.1080@TK2MSFTNGP06.phx.gbl...
> Surely the database is the issue. My experience was that Nuke The Bills
> made a huge improvement. That improvement seems to be disappearing with
> time.
>
>
> "R. P." <r_pol12gar@hotmail.com> wrote in message
> news:%23GluE0c7IHA.1468@TK2MSFTNGP05.phx.gbl...
>> I have a feeling that the gradual performance degradation might be caused
>> by the database structure used to store data. I see the same kind of
>> degradation in Outlook Express which tends to take longer and longer time
>> to catch-up a larger news group. I suspect the same db structure is used
>> there too, to store and index the data.
>
>

Dick
Fri Jul 25 13:11:02 CDT 2008

I'm getting that feeling as time goes on as well. You'd sure think they
**could** make the app clean up after itself better along the way...

"Bob Peel, MVP" <bob_peel@kiandra.freeserve.co.uk.INVALID> wrote in message
news:%23gVIESm7IHA.2072@TK2MSFTNGP04.phx.gbl...
> I have a feeling that Nuking the Bills is a one time fix but with no
> ongoing benefit. The problem with the bills will, IMHO, start building up
> again and at some stage one will have to perform another Nuke! :-(

R
Fri Jul 25 14:50:48 CDT 2008

"Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote:
> No. Did you read the link I sent you to?

Yes, I did, but didn't like the procedure; too much work and risky.

> There are probably many of these kinds of issues in the Money database
> design. It goes back to '92.

So what are we to do then? I think I'll be looking for a better designed
alternate program with similar functionality.

R. P.

Dick
Fri Jul 25 16:40:31 CDT 2008

Well, it is what it is. But you might still want to at least test a copy of
your file in a version M07 or newer with Nuke The Bills to see if it has the
same dramatic effect for you it has had for many others. If you want to
change Money being slow in saving data, that is.

"R. P." <r_pol12gar@hotmail.com> wrote in message
news:%23mMS9%23o7IHA.3724@TK2MSFTNGP03.phx.gbl...
> "Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote:
>> No. Did you read the link I sent you to?
>
> Yes, I did, but didn't like the procedure; too much work and risky.

Bob
Sat Jul 26 01:23:20 CDT 2008

It wouldn't be so bad if MS automated the process. I wouldn't mind doing an
auto-Nuke once a quarter - say!

--
Regards
Bob Peel,
Microsoft MVP - Money

For unofficial FAQs see
http://money.mvps.org/
or
http://umpmfaq.info/

I do not respond to any emails that I have not specifically asked for.

"Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote in
message news:O7dJEHo7IHA.1420@TK2MSFTNGP06.phx.gbl...
> I'm getting that feeling as time goes on as well. You'd sure think they
> **could** make the app clean up after itself better along the way...
>
> "Bob Peel, MVP" <bob_peel@kiandra.freeserve.co.uk.INVALID> wrote in
> message news:%23gVIESm7IHA.2072@TK2MSFTNGP04.phx.gbl...
>> I have a feeling that Nuking the Bills is a one time fix but with no
>> ongoing benefit. The problem with the bills will, IMHO, start building up
>> again and at some stage one will have to perform another Nuke! :-(
>
>

Dick
Sat Jul 26 06:59:48 CDT 2008

You mean like you didn't end up re-creating the bills completely by hand?
Sure. If you could "export" then "import" them--all of their data, not just
the limited amount that the report prints--then maybe that would be
"better". But still a crutch for bad design somewhere else in the program
that should be fixed instead.

"Bob Peel, MVP" <bob_peel@kiandra.freeserve.co.uk.INVALID> wrote in message
news:%23HbJUgu7IHA.1468@TK2MSFTNGP05.phx.gbl...
> It wouldn't be so bad if MS automated the process. I wouldn't mind doing
> an auto-Nuke once a quarter - say!

Bob
Sat Jul 26 10:47:18 CDT 2008

There's so many examples of bad design that I have given up all hope of
their being fixed. :-(

--
Regards
Bob Peel,
Microsoft MVP - Money

For unofficial FAQs see
http://money.mvps.org/
or
http://umpmfaq.info/

I do not respond to any emails that I have not specifically asked for.

"Dick Watson" <littlegreengecko@mind-enufalready-spring.com> wrote in
message news:%232mkQcx7IHA.2016@TK2MSFTNGP02.phx.gbl...
> You mean like you didn't end up re-creating the bills completely by hand?
> Sure. If you could "export" then "import" them--all of their data, not
> just the limited amount that the report prints--then maybe that would be
> "better". But still a crutch for bad design somewhere else in the program
> that should be fixed instead.
>
> "Bob Peel, MVP" <bob_peel@kiandra.freeserve.co.uk.INVALID> wrote in
> message news:%23HbJUgu7IHA.1468@TK2MSFTNGP05.phx.gbl...
>> It wouldn't be so bad if MS automated the process. I wouldn't mind doing
>> an auto-Nuke once a quarter - say!
>
>

R
Sat Jul 26 14:00:23 CDT 2008

"Bob Peel, MVP" <bob_peel@kiandra.freeserve.co.uk.INVALID> wrote:
> There's so many examples of bad design that I have given up all hope
> of their being fixed. :-(

Hey, that's my line.

R.P.