Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > Money

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-17-2008, 07:32 PM
R. P.
 
Posts: n/a
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.

Reply With Quote
  #2 (permalink)  
Old 07-20-2008, 01:09 AM
Dick Watson
 
Posts: n/a
Re: Money slow in saving data

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.



Reply With Quote
  #3 (permalink)  
Old 07-23-2008, 08:23 PM
R. P.
 
Posts: n/a
Re: Money slow in saving data

"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.

Reply With Quote
  #4 (permalink)  
Old 07-24-2008, 05:02 AM
Dick Watson
 
Posts: n/a
Re: Money slow in saving data

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.



Reply With Quote
  #5 (permalink)  
Old 07-24-2008, 08:37 PM
R. P.
 
Posts: n/a
Re: Money slow in saving data

"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.

Reply With Quote
  #6 (permalink)  
Old 07-25-2008, 02:32 AM
Dick Watson
 
Posts: n/a
Re: Money slow in saving data

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.



Reply With Quote
  #7 (permalink)  
Old 07-25-2008, 02:56 AM
R. P.
 
Posts: n/a
Re: Money slow in saving data

"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.

Reply With Quote
  #8 (permalink)  
Old 07-25-2008, 12:28 PM
Dick Watson
 
Posts: n/a
Re: Money slow in saving data

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.


Reply With Quote
  #9 (permalink)  
Old 07-25-2008, 02:41 PM
Bob Peel, MVP
 
Posts: n/a
Re: Money slow in saving data

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.

>
>


Reply With Quote
  #10 (permalink)  
Old 07-25-2008, 06:11 PM
Dick Watson
 
Posts: n/a
Re: Money slow in saving data

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! :-(



Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > Money


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 11:23 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109