Hi Tim and thanks. Actually, I have long had this problem with an older laptop before I redid this high-end Dell machine, upgrading it to a solid state drive and Win7. The reports I'm talking about can last anywhere from a half an hour to some hours - evaluating close to a million records and then recording the appropriate "scores" can take that long. Or days using VirtualBox.
It doesn't happen with shorter reports or processes. I have to figure it has something to do with the way DP manages memory but I don't know how to allot a greater share of memory to the DOS window; I did increase buffer sizes and number but that didn't have any impact that I can tell. OTOH, I just reindexed the database: 904T voter records, 506T dwelling records, 670T mailing unit records, 57T NCOA records and then some ancillary panels with limited numbers of records. Multiple indexes in each. Took maybe a half an hour to reindex. This is an issue that has plagued me but so far I have no idea how to address it. Once I establish the database it stays fairly stagnant for the rest of the election cycle, perhaps a few thousand record postings against it but mostly it's used to spit out target lists, mailing data and evaluate neighborhoods for how we treat them. All of that is easily done through VDos which I use on all our machines. Good hearing from you. One of these days I ought to find Ralph again! *Don FriedmanProfessionalRecords.Com LLCPRS Data Systems* *205 S Main StreetPittsburgh, PA 152151-800-PRS-FILE 412-784-1615 Fax* *412-400-3881 Cell/Text* On Wed, Mar 22, 2017 at 3:33 PM, Tim Rude <[email protected]> wrote: > That's a new one on me. We run DP apps on Win7-32 a good bit and haven't > seen that issue. However, none of the reports/imports take minutes to run. > They usually take less than 10 seconds (usually much less). > > Have you tried this on another machine with Win7-32? Or perhaps on a > Win10-32 machine? > > Tim Rude > > > On 3/22/2017 2:17 PM, Don Friedman wrote: > > As some of you know, I tend to work with larger databases. While VDos and > VirtualBox give me some ways of using DP under any OS, they both slow down > imports and long reports that post results to a record. I've found that the > fastest way to take care of this is to run under 32-Bit Win7 using its DOS > capability. An incredible speed difference. However, I've had one problem > with that approach that I still haven't solved which is that once these > processes are running for a few minutes Windows seems to give up control of > the DOS box and no commands hit the DP app even though the report/import > continue to run. When finished there is still no way to access the DOS box; > the only choice is to exit DOS and re-enter the app. Any ideas on why this > might be happening and what I could do to modity the behavior? This does > not happen under VDOs or VBox. > > Don > > > > > > > > *Don Friedman ProfessionalRecords.Com LLC PRS Data Systems * > > > > *205 S Main Street Pittsburgh, PA 15215 1-800-PRS-FILE 412-784-1615 > <(412)%20784-1615> Fax* > *412-400-3881 <(412)%20400-3881> Cell/Text* > > > > _______________________________________________ > Dataperf mailing > [email protected]http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf > > > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf > >
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
