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 <[EMAIL PROTECTED]> > *To:* Dataperfect Users Discussion Group <[email protected]> > *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
