Hi, Ralph,
I checked the indexes on the import panel, and there is one index that
consists of the first variable length text field and the autoincrementing
field. I would have to check just to make sure that this index is not being
used for anything, but I believe it is NOT being used, and could therefore
be deleted. However, the only thing that is ever imported into this field
is a short (up to 12-letter) code, so I wouldn't think that this is causing
the problem even though it is being used in an index, for the following
reasons: 1) It is a short value, 2) it is only there temporarily until the
record is deleted, so it isn't there cluttering up the index long-term, and
3) the fields and indexes in this panel have been unchanged (none added or
changed) for literally years. Based on my personal experience with Murphy's
Law, I believe that if something were going to go wrong with it, it probably
already would have.
The fields I added a few months ago were to another panel, which is not even
linked to the import panel. None of the newly added fields (2-3 months ago)
were variable length text fields. To the best I can recall, I did not add
any new indexes or links at that time, either. (However, my memory is
failing me -- I'm a grandmother x2 now, so I guess that's as good an excuse
as any!)
By the way, Ralph, do you know what the size limit is for the *.TXX file?
Thanks again for your help!
Laurie Corvacho
----- Original Message -----
From: "Ralph Alvy" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Sunday, August 19, 2007 3:42 PM
Subject: [Dataperf] Re: Re: I need help with a dumb question!
Regarding the Import Panel, do you have variable length fields in any of
its
indexes?
Laurie Corvacho wrote:
Hi Ralph and Mark,
I made an empty copy of the database, and all the records import fine, in
toto. (??!!) Would this mean I have hit some kind of a limit as far as
index
and/or TXX file size? Getting close to and then hitting a limit might
possibly make sense as to why the number of records that could be
successfully imported suddenly became a problem, and is now constantly
shrinking. I don't think DP's file size limits are actually this low, so
possibly I have hit a practical as opposed to a theoretical limit?
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
