|
#5
10-21-2006, 11:49 PM
| |||
| |||
 Re: Making your file faster There are a lot of things that can slow a datafile down -- it isn't just size. -- Michael Gordon "Eric" <Email[at]delthistiscali.nl> wrote in message news:453a65b6$0$752$5fc3050[at]dreader2.news.tiscali.nl... - quote - > Hi Michael, > I managed to manually do what I wanted. Yet it seems that another account > (cash) was affected (I must have deleted grocery-expenses, that were > actually split-transactions with a transfer into the cash-account). The > balance had become negative. Exported from a backup the cash-account and > imported it into the file in which I had replaced the "frequent costs". It > has now been busy for about 4 hours with "updating" and when I look from > time to time at the balance of the cash account it slowly grows again > towards the balance it had. > So if anyone wants to do it, here's the first don't! > I thought that my file had become a bit faster, but it was not a big > improvement. I gained about 2 Mb > Eric > "Michael Gordon" <gordonm[at]denison.edu> schreef in bericht > news:e6WLSPK9GHA.2268[at]TK2MSFTNGP05.phx.gbl... > > Let us know if that works for you. > > > -- > > Michael Gordon > > > > "Eric" <Email[at]delthistiscali.nl> wrote in message > > news:453910f5$0$757$5fc3050[at]dreader2.news.tiscali.nl... > > > Yes, so I found out. > > > > > But the suggestion by Bob Peel didn't suit me. I might just manually > > > combine 6 or 7 expenses within one category and month to one expense. I > > > would think that should help. It should at least make the file smaller. > > > (The problem is not the filesize though, I just want to gain speed when > > > doing reports that have several years to compare) > > > > > Thanks, > > > > > Eric > > > > > "Michael Gordon" <gordonm[at]denison.edu> schreef in bericht > > > news:eI20qtF9GHA.5092[at]TK2MSFTNGP04.phx.gbl... > > > > reimporting from Excel is not an easy procedure, Eric. There are better > > > > ways to speed things up (and 40 mb is actually not a particularly large > > > > datafile). > > > > > > > -- > > > > Michael Gordon > > > > > > > > > > "Eric" <Email[at]delthistiscali.nl> wrote in message > > > > news:4537bbe8$0$720$5fc3050[at]dreader2.news.tiscali.nl... > > > > > Hello, > > > > > > > > > I have M07 and my file right now is about 40 mb. Overtime, I have done > > > > > many entries that have a higher frequency than once a month > > > > > (groceries, etc.). > > > > > I was thinking of exporting the whole file to excel, subtotal those > > > > > more frequent costs to monthly totals and reimport them again, as I > > > > > think that monthly subtotals are just fine to compare to earlier years > > > > > and months. > > > > > > > > > Anyone ever tried this? > > > > > Would this actually make the file smaller (I assume it will) and > > > > > faster? > > > > > Would there be an easier way than I described? > > > > > > > > > Thanks, > > > > > > > > > Eric > > > > > > > > > > > > > > > > |
|
#4
10-21-2006, 06:23 PM
| |||
| |||
| Re: Making your file faster Hi Michael, I managed to manually do what I wanted. Yet it seems that another account (cash) was affected (I must have deleted grocery-expenses, that were actually split-transactions with a transfer into the cash-account). The balance had become negative. Exported from a backup the cash-account and imported it into the file in which I had replaced the "frequent costs". It has now been busy for about 4 hours with "updating" and when I look from time to time at the balance of the cash account it slowly grows again towards the balance it had. So if anyone wants to do it, here's the first don't! I thought that my file had become a bit faster, but it was not a big improvement. I gained about 2 Mb Eric "Michael Gordon" <gordonm[at]denison.edu> schreef in bericht news:e6WLSPK9GHA.2268[at]TK2MSFTNGP05.phx.gbl... - quote - > Let us know if that works for you. > -- > Michael Gordon > "Eric" <Email[at]delthistiscali.nl> wrote in message > news:453910f5$0$757$5fc3050[at]dreader2.news.tiscali.nl... > > Yes, so I found out. > > > But the suggestion by Bob Peel didn't suit me. I might just manually > > combine 6 or 7 expenses within one category and month to one expense. I > > would think that should help. It should at least make the file smaller. > > (The problem is not the filesize though, I just want to gain speed when > > doing reports that have several years to compare) > > > Thanks, > > > Eric > > > "Michael Gordon" <gordonm[at]denison.edu> schreef in bericht > > news:eI20qtF9GHA.5092[at]TK2MSFTNGP04.phx.gbl... > > > reimporting from Excel is not an easy procedure, Eric. There are better > > > ways to speed things up (and 40 mb is actually not a particularly large > > > datafile). > > > > > -- > > > Michael Gordon > > > > > > > "Eric" <Email[at]delthistiscali.nl> wrote in message > > > news:4537bbe8$0$720$5fc3050[at]dreader2.news.tiscali.nl... > > > > Hello, > > > > > > > I have M07 and my file right now is about 40 mb. Overtime, I have done > > > > many entries that have a higher frequency than once a month (groceries, > > > > etc.). > > > > I was thinking of exporting the whole file to excel, subtotal those > > > > more frequent costs to monthly totals and reimport them again, as I > > > > think that monthly subtotals are just fine to compare to earlier years > > > > and months. > > > > > > > Anyone ever tried this? > > > > Would this actually make the file smaller (I assume it will) and > > > > faster? > > > > Would there be an easier way than I described? > > > > > > > Thanks, > > > > > > > Eric > > > > > > > > > |
|
#3
10-20-2006, 11:59 PM
| |||
| |||
| Re: Making your file faster Let us know if that works for you. -- Michael Gordon "Eric" <Email[at]delthistiscali.nl> wrote in message news:453910f5$0$757$5fc3050[at]dreader2.news.tiscali.nl... - quote - > Yes, so I found out. > But the suggestion by Bob Peel didn't suit me. I might just manually > combine 6 or 7 expenses within one category and month to one expense. I > would think that should help. It should at least make the file smaller. > (The problem is not the filesize though, I just want to gain speed when > doing reports that have several years to compare) > Thanks, > Eric > "Michael Gordon" <gordonm[at]denison.edu> schreef in bericht > news:eI20qtF9GHA.5092[at]TK2MSFTNGP04.phx.gbl... > > reimporting from Excel is not an easy procedure, Eric. There are better > > ways to speed things up (and 40 mb is actually not a particularly large > > datafile). > > > -- > > Michael Gordon > > > > "Eric" <Email[at]delthistiscali.nl> wrote in message > > news:4537bbe8$0$720$5fc3050[at]dreader2.news.tiscali.nl... > > > Hello, > > > > > I have M07 and my file right now is about 40 mb. Overtime, I have done > > > many entries that have a higher frequency than once a month (groceries, > > > etc.). > > > I was thinking of exporting the whole file to excel, subtotal those more > > > frequent costs to monthly totals and reimport them again, as I think > > > that monthly subtotals are just fine to compare to earlier years and > > > months. > > > > > Anyone ever tried this? > > > Would this actually make the file smaller (I assume it will) and faster? > > > Would there be an easier way than I described? > > > > > Thanks, > > > > > Eric > > > > |
|
#2
10-20-2006, 06:09 PM
| |||
| |||
| Re: Making your file faster Yes, so I found out. But the suggestion by Bob Peel didn't suit me. I might just manually combine 6 or 7 expenses within one category and month to one expense. I would think that should help. It should at least make the file smaller. (The problem is not the filesize though, I just want to gain speed when doing reports that have several years to compare) Thanks, Eric "Michael Gordon" <gordonm[at]denison.edu> schreef in bericht news:eI20qtF9GHA.5092[at]TK2MSFTNGP04.phx.gbl... - quote - > reimporting from Excel is not an easy procedure, Eric. There are better > ways to speed things up (and 40 mb is actually not a particularly large > datafile). > -- > Michael Gordon > "Eric" <Email[at]delthistiscali.nl> wrote in message > news:4537bbe8$0$720$5fc3050[at]dreader2.news.tiscali.nl... > > Hello, > > > I have M07 and my file right now is about 40 mb. Overtime, I have done > > many entries that have a higher frequency than once a month (groceries, > > etc.). > > I was thinking of exporting the whole file to excel, subtotal those more > > frequent costs to monthly totals and reimport them again, as I think that > > monthly subtotals are just fine to compare to earlier years and months. > > > Anyone ever tried this? > > Would this actually make the file smaller (I assume it will) and faster? > > Would there be an easier way than I described? > > > Thanks, > > > Eric > |
|
#1
10-20-2006, 03:21 PM
| |||
| |||
| Re: Making your file faster reimporting from Excel is not an easy procedure, Eric. There are better ways to speed things up (and 40 mb is actually not a particularly large datafile). -- Michael Gordon "Eric" <Email[at]delthistiscali.nl> wrote in message news:4537bbe8$0$720$5fc3050[at]dreader2.news.tiscali.nl... - quote - > Hello, > I have M07 and my file right now is about 40 mb. Overtime, I have done > many entries that have a higher frequency than once a month (groceries, > etc.). > I was thinking of exporting the whole file to excel, subtotal those more > frequent costs to monthly totals and reimport them again, as I think that > monthly subtotals are just fine to compare to earlier years and months. > Anyone ever tried this? > Would this actually make the file smaller (I assume it will) and faster? > Would there be an easier way than I described? > Thanks, > Eric |
|
10-19-2006, 08:13 PM
| |||
| |||
| Re: Making your file faster There is an option in M2007 to Remove all Bills data (File > Repair Money File) that some users have reported as having a miraculous effect on performance. Before you try it a) copy your .mny file and b) make sure you have a note of all your bills. -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default...d=fh;EN-GB;mny. I do not respond to any emails that I have not specifically asked for. "Eric" <Email[at]delthistiscali.nl> wrote in message news:4537bbe8$0$720$5fc3050[at]dreader2.news.tiscali.nl... - quote - > Hello, > I have M07 and my file right now is about 40 mb. Overtime, I have done > many entries that have a higher frequency than once a month (groceries, > etc.). > I was thinking of exporting the whole file to excel, subtotal those more > frequent costs to monthly totals and reimport them again, as I think that > monthly subtotals are just fine to compare to earlier years and months. > Anyone ever tried this? > Would this actually make the file smaller (I assume it will) and faster? > Would there be an easier way than I described? > Thanks, > Eric |
|
#-1
10-19-2006, 05:54 PM
| |||
| |||
| Making your file faster Hello, I have M07 and my file right now is about 40 mb. Overtime, I have done many entries that have a higher frequency than once a month (groceries, etc.). I was thinking of exporting the whole file to excel, subtotal those more frequent costs to monthly totals and reimport them again, as I think that monthly subtotals are just fine to compare to earlier years and months. Anyone ever tried this? Would this actually make the file smaller (I assume it will) and faster? Would there be an easier way than I described? Thanks, Eric |
| Tags |
| faster, file, making |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Money 2006 is faster for me marc: I up grade every year. Last was a major change. This year I see few changes but ones we all have wanted. Also for me, the program is much faster. I... | Microsoft Money | 2 | 07-21-2005 07:25 PM | |
| Money 2005 faster? Rod: Is Money 2005 faster than 2004 with large data files? My file is 23MB and has almost 10 years of information. (I don't want to archive.) Thanks! | Microsoft Money | 11 | 09-25-2004 10:02 PM | |
| Is 2004 Significantly Faster than 2002? Mike: I am running a Dell Precision 420 with dual P3 600 mhz processors, 256K L2 Cache, 256 RAM, over a gigabite of available disk space on each hard... | Microsoft Money | 4 | 01-04-2004 10:25 PM | |
| Faster Operation? MLW: I have read that the MSM archive function does not do much good. I agree but still, I have tried to archive my data on an annual basis, but still... | Microsoft Money | 1 | 10-30-2003 08:42 AM | |
| Is Money 2004 any faster? C.B. McCoy: Has MS done anything to improve the performance of Money 2004? | Microsoft Money | 14 | 08-28-2003 10:56 PM | |
| Thread Tools | |
| Display Modes | |
| |
Linear Mode
