A million voters is a lot of voters... I too end up using many indexes with
DP... the impost is not so great as it is with Access...
----- Original Message -----
From: Don Friedman
To: Dataperfect Users Discussion Group
Sent: Monday, February 18, 2008 9:56 AM
Subject: Re: [Dataperf] Importing STE w/o re-generating indexes
Brian - my larger applications are fairly matured so my efficiency in
indexing has probably gotten as good as it is going to get. The beauty of DP is
that I can use indexes in so many ways that it makes sorting through a million
voters for who I want to target awfully easy, and fast.
Hope all is well with you.
Don
On Feb 17, 2008 4:14 PM, Brian Hancock <[EMAIL PROTECTED]> wrote:
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
--
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
