Hi Robert,
I agree with Don, 300Mb of data and indexes is a relatively small database,
and on a standalone machine reindexing might only take a very short space of
time... Over a slow network might be a littloe too much, but if it is on a
network server, it night be easier to copy it off, reindex and text the renamed
database and then upload it to the server.
Hi Don,
290Mb Index is a big index !!! Whenever I find myself with big indexes I use
the Dpdiag utility to check if anything is redundant. Not only do large indexes
consume time with reindexing, but they also consume time when writing data, and
so removing unused indexes improves performance. (by default Microsoft Access
Indexes every fieldname with the letters "id" or "no" in it, and often at the
end of a development cycle I find that a relatively large percentage of my
database are these useless indexes, and trimming them our demonstrably improves
data save times.)
Regards
Brian
----- Original Message -----
From: Don Friedman
To: Dataperfect Users Discussion Group
Sent: Monday, February 18, 2008 3:06 AM
Subject: Re: [Dataperf] Importing STE w/o re-generating indexes
Robert - glad all is well with you.
A big clean might be a good thing to do right after you change the names. It
dusts off the cobwebs and with today's machines hardly takes much time. I also
have large databases - one county's index is 290Meg - but if I start
regenerating before I leave the office in the early evening it is done when I
come back in the morning. Not a problem.
Don Friedman
Pittsburgh
On Feb 16, 2008 4:21 PM, Robert Pollard <[EMAIL PROTECTED]> wrote:
Dear Friends,
I are renaming a database, so will be using WP 5.1+ search and replace in
the .STE file, but will not otherwise be making any changes.
I seem to remember there is a startup option to tell DP not to recreate all
the indexes and running DPIMP. Since the databases has 99 panels, and about 300
megabytes in total data & index files, with a good number of panels having 10
or more indexes, si I am not enthisiastic about waiting for the whole database
to be reindexed
Btw, although I have not been active on this list I am continuing to grow
my database work, with much of it generated content for TiddlyWiki sites I have
developed. See www.ngo-framework.net for the most recent site, that has now
become the interim official web site for a major UN/NGO conference in September
in Paris, preparing for the 60th Anniversary of the Universal Declaration of
Human Rights, and with the tentative theme: Dignity, Integrity & Justice for
All of Us: Being the change we want to see.
In conjunction my role as Co-Chair of the Research, Communications &
Website Sub-Committee for the Conference Planning Committee, I am renaming my
database UDHR60 and will be dedicating its use as the digital engine for the
conference preparations, participation & follow-up.
Please don't be surprised if I am around asking some questions - including
exploring ways to better integrate the genius of DP with that of TiddlyWiki
With warm regard
Robert
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
--
Don Friedman
ProfessionalRecords.Com LLC
PRS Data Systems
205 S Main Street
Pittsburgh, PA 15215
412-784-1600 - 1-800-PRS-FILE
412-784-1615 Fax
------------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
