Quicken File Size
Keith A. Reid
A friend told me that he heard that there was a file size limit on the
Quicken data file. When it is reached the file locks up and your data is
corrupt. I am using Quicken 98 and have data from '93 still in my file. I
dont know the size of the .dat file or how many total transactions are in it
right now, but I can find out either.
Anyone know anything about this one.
Thanks in advance!! :-}
Don Macpherson
As with any file containing data, the larger the file, the higher the
odds that "something" will be corrupted.
(Simply because there are more "somethings" in a large file than in a
small file!).
My QDF file (apparently a medium size one in the scale of things), is
currently 3.5MB, with approx 9000 transactions in 65 accounts.
Early versions of Quicken may have more problems with data files than
later versions.
There was a significant change in the database structure a few years
back.
In other words, the information may not apply (if it ever really did) to
current versions of Quicken.
Don Macpherson
Keith A. Reid <kar...@gr.com> wrote in message
news:z_Cq3.380$8X1.37993@PM01NEWS...
alan
having done a verify data and superverify since i thought i had corruption.
but it reduced the size of the ancillary f iles *.qsd from 1500k to 500k and
all of my data is still there. now it fits onto 2 floppies instead of about
3. I was very worried about it last nite and restored a pre-vefify file -
but intuit today told me that can happen and should not worry about it.
they also note in their web site that simply copying a file can reduce the
space it takes up without losing any data.
Has anyone had this experience??
alan
Don Macpherson <nearly_donmac@almost_erols.com> wrote in message
news:7of0f9$sra$1...@autumn.news.rcn.net...
Don Macpherson
Bruce Lee once explained some of the issues here.
1. There are 3 "file management" functions: Copy, Validate and
SuperValidate.
2. The validate function examines the data in place.
3. The Copy and Supervalidate functions write out a new file.
4. Dead space can accumulate in the file (deleting data, Quicken
padding some info, etc).
5. The functions that write out a new file remove this dead space.
So, a copy or supervalidate *may* reduce the file size. Whether it will
actually do so depends on your data.
One of the major uses of QSD is to contain security price history. If
this file has become significantly smaller, it could be due to the fact that
you have deleted some security price history (or it has somehow got lost),
leaving "dead space" that was eliminated during the creation of the new
files.
HTH,
Don Macpherson
alan <armm...@worldnet.att.net> wrote in message
news:7ofc88$4ip$1...@bgtnsc03.worldnet.att.net...
Bill H
As in many databases a deleted entry does not actually delete it. It
flags it as deleted. In general purpose database there is often a
compress function that actually removes them.
The Quicken copy operation is not the same as a dos copy. It reads and
writes each transaction, but not the deleted ones.
Bill
On Fri, 6 Aug 1999 15:13:09 -0400, "alan" <armm...@worldnet.att.net>
wrote:
>Have you heard of a file size shrinking? I stumbled on this with quicken 98
>having done a verify data and superverify since i thought i had corruption.
>but it reduced the size of the ancillary f iles *.qsd from 1500k to 500k and
>all of my data is still there. now it fits onto 2 floppies instead of about
>3. I was very worried about it last nite and restored a pre-vefify file -
>but intuit today told me that can happen and should not worry about it.
>they also note in their web site that simply copying a file can reduce the
>space it takes up without losing any data.
>
>Has anyone had this experience??
>
>alan
>
Michael Abbaticchio
alan wrote:
--
Michael A. Abbaticchio
abba...@mindspring.com
reb...@my-deja.com
(Sorry for interrupting the flow of this thread, which deals with files
that were shrunk unexpectedly, but it seems like this is the best place
to insert this question.)
I've archived my prior years' data (which seemed to have virtually no
impact on my file size). Many of the messages on this thread seem to
indicate that "verifying" and "superverifying" the data will work. But
I don't see that on any of my Quicken 99 Deluxe menu options, and it
doesn't show up as a help topic. How do I verify and superverify?
Also, are there other tricks that can help me reduce the file size?
(I'm up to two disks now for one year's data, which is a pain, because
I continuously transfer data between my desktop at home and my laptop
on the road.) Thanks for any suggestions.
In article <7ofc88$4ip$1...@bgtnsc03.worldnet.att.net>,
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Don Macpherson
alan used the term "verify".
I used the correct term "validate" in my second response last week.
Don Macpherson
<reb...@my-deja.com> wrote in message news:7p2169$g17$1...@nnrp1.deja.com...
Andrew DeFaria
Can someone tell me how I can take steps to shrink my file size? (Sorry for interrupting the flow of this thread, which deals with files that were shrunk unexpectedly, but it seems like this is the best place to insert this question.)I've archived my prior years' data (which seemed to have virtually no impact on my file size). Many of the messages on this thread seem to indicate that "verifying" and "superverifying" the data will work. But I don't see that on any of my Quicken 99 Deluxe menu options, and it
doesn't show up as a help topic. How do I verify and superverify? Also, are there other tricks that can help me reduce the file size? (I'm up to two disks now for one year's data, which is a pain, because I continuously transfer data between my desktop at home and my laptop on the road.) Thanks for any suggestions.
Please route messages appropriately!
Home: And...@DeFaria.com http://www.defaria.com ICQ# 25286737
Work: def...@cisco.com Phone: (408)-527-1280
Unofficial Quicken Web Page: http://www.defaria.com/Quicken
Newsgroup: news:alt.comp.software.financial.quicken
reb...@my-deja.com
BEFORE I post questions to this forum, and save you some work.
In article <37B499A9...@cisco.com>,
Andrew DeFaria <def...@cisco.com> wrote:
>
> --------------78B01ADCDE9DEA6C5A2B311A
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
------------------------------------------------------------------------
-------
> Please route messages appropriately!
> Home: And...@DeFaria.com http://www.defaria.com ICQ# 25286737
> Work: def...@cisco.com Phone: (408)-527-1280
> Unofficial Quicken Web Page: http://www.defaria.com/Quicken
> Newsgroup: news:alt.comp.software.financial.quicken
>
> --------------78B01ADCDE9DEA6C5A2B311A
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> reb...@my-deja.com wrote:
> <blockquote TYPE=CITE>Can someone tell me how I can take steps to
shrink
> my file size? (Sorry for interrupting the flow of this thread, which
deals
> with files that were shrunk unexpectedly, but it seems like this is
the
> best place to insert this question.)
> <p>I've archived my prior years' data (which seemed to have virtually
no
> impact on my file size). Many of the messages on this thread
seem
> to indicate that "verifying" and "superverifying" the data will
work.
> But I don't see that on any of my Quicken 99 Deluxe menu options, and
it
> <br>doesn't show up as a help topic. How do I verify and
superverify?
> Also, are there other tricks that can help me reduce the file size?
(I'm
> up to two disks now for one year's data, which is a pain, because I
continuously
> transfer data between my desktop at home and my laptop on the road.)
> Thanks for any suggestions.</blockquote>
> See <a href="http://www.defaria.com/Quicken/cgi-
bin/redirect.cgi?page=QTips/Shrinking.html">My
> database has grown huge. Is there anyway I can shrink it down to a
more
> manageable size?</a> and <a href="http://www.defaria.com/Quicken/cgi-
bin/redirect.cgi?page=FAQ/Validate.html">How
> do I validate my Quicken Database?</a>
> <center>
> <hr SIZE=1 NOSHADE WIDTH="100%">Please route messages appropriately!
> <br>Home: And...@DeFaria.com <A
HREF="http://www.defaria.com">http://www.defaria.com</A> ICQ# 25286737
> <br>Work: def...@cisco.com Phone: (408)-527-1280
> <br>Unofficial Quicken Web Page: <A
HREF="http://www.defaria.com/Quicken">http://www.defaria.com/Quicken</A>
> <br>Newsgroup: <A
HREF="news:alt.comp.software.financial.quicken">news:alt.comp.software.f
inancial.quicken</A></center>
> </html>
>
> --------------78B01ADCDE9DEA6C5A2B311A--
alan
I had a feeling that this is what happens. So is it worth running
supervalidate to shirnk the files and use less disks or am I giving
something up? It seems that that function creates more subfiles or breaks
up the large files into several and I wonder if some data is lost?
alan
Michael Abbaticchio <abba...@mindspring.com> wrote in message
news:37B3973A...@mindspring.com...
> Supervalidate compacts the files. Removes holes where items were deleted.
>
Andrew DeFaria
I had a feeling that this is what happens. So is it worth running supervalidate to shirnk the files and use less disks or am I giving something up?
It seems that that function creates more subfiles or breaks up the large files into several and I wonder if some data is lost?
Basically Super Validate (and alternately File: File Operations: Copy) copies the data to a new Quicken database. The process of copying it is not "copy every single bit from this DOS file to that DOS file" rather it's a "Run down each list and copy every record contained there in". In the process "bad" records are not copied (where "bad" records are ones that are not linked in properly to the list). The result is often a smaller database.
And it's not like you'll lose data because that data, not being on the list properly, was not really there (or it if was there is was being shown to you inadvertently because it shouldn't have been. IOW you might lose data but that would be because your database is corrupted and the likelihood of recovering that data is small anyway).
Newsgroup: news:alt.comp.software.financial.quicken
it's too much work for me to fix your email address!
Bill H
Bill
On Fri, 13 Aug 1999 21:03:11 GMT, reb...@my-deja.com wrote:
>Can someone tell me how I can take steps to shrink my file size?
>(Sorry for interrupting the flow of this thread, which deals with files
>that were shrunk unexpectedly, but it seems like this is the best place
>to insert this question.)
>
>I've archived my prior years' data (which seemed to have virtually no
>impact on my file size). Many of the messages on this thread seem to
>indicate that "verifying" and "superverifying" the data will work. But
>I don't see that on any of my Quicken 99 Deluxe menu options, and it
>doesn't show up as a help topic. How do I verify and superverify?
>Also, are there other tricks that can help me reduce the file size?
>(I'm up to two disks now for one year's data, which is a pain, because
>I continuously transfer data between my desktop at home and my laptop
>on the road.) Thanks for any suggestions.
>
>In article <7ofc88$4ip$1...@bgtnsc03.worldnet.att.net>,
Michael Abbaticchio
time, That way the losses are minimized should something go wrong.
alan wrote:
> Michael-
> I had a feeling that this is what happens. So is it worth running
> supervalidate to shirnk the files and use less disks or am I giving
> something up? It seems that that function creates more subfiles or breaks
> up the large files into several and I wonder if some data is lost?
>
> alan
>
> Michael Abbaticchio <abba...@mindspring.com> wrote in message
> news:37B3973A...@mindspring.com...
> > Supervalidate compacts the files. Removes holes where items were deleted.
> >