Hi Don, Me again. I used to reindex my database on a regular basis as a form of housekeeping. If you don't want to pay out for SSD, you can run DP on RAM DISK. Prior to SSD's becoming available in the 90's, I used to create a RAM disk on boot up and then with batch files as menu options in DP office, I would copy my DP database to the RAM DISK for the day's work and then copy back to HDD at the end. Naturally the PC was powered by a UPS. I ran the RAM disk from the late 80's for many years before the SSDs became available. This was on an 286. One database I created used to take 2-3 hours to re-index on HDD. On RAM disk this dropped to about 8 minutes. There are utilities available to use as a RAM DISK e.g. http://www.softperfect.com/products/ramdisk/ Regards Eric Donn Director J.I.T. Systems Ltd "ZERO DOWN TIME OR WE FIX IT FOR FREE" 021 548 411 [email protected] ph: 64 3 351 4100 fax: 64 3 351 4148 www.jit.co.nz Delivery Address: 24 Albany St Christchurch 8014 Postal Address: P.O. Box 29063 Christchurch 8540 The information contained in this e-mail message is intended only for the use of the person or entity to whom it is addressed and may contain information that is CONFIDENTIAL and may be exempt from disclosure under applicable laws. If you read this message and are not the addressee you are notified that use, dissemination, distribution, or reproduction of this message is prohibited. If you have received this message in error, please notify us immediately and delete the original message. You should scan this message and any attached files for viruses. J.I.T. Systems Limited accepts no liability for any loss caused either directly or indirectly by a virus arising from the use of this message or any attached file From: [email protected] [mailto:[email protected]] On Behalf Of Don Friedman Sent: Tuesday, 23 April 2013 06:30 To: Dataperfect Users Discussion Group Subject: [Dataperf] Two points of inquiry First, has anyone written (in English) a formula for scanning text and adjusting the capitalization of names? As in changing MCCARTHY to McCarthy? I'm about to undertake this to see how it goes but if someone has done it it would be helpful. Obviously there's no great trick to it other than writing a very, very long formula. Secondly, on one of my larger voter databases that was acting just fine yesterday, when I opened it up this morning the colors changed on my basic panel listing and report writing screens. I went in to the STE file and saw that there was a bit of corruption in the header area which I was able to correct without having to reindex (that takes all night plus some . . . ) but I'm wondering how often any of you find that happening. Don -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems Liveport WiFi 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax
______________________________________________________________________________ This email has been scrubbed for your protection by J.I.T. Systems Ltd. For more information visit http://www.jit.co.nz ______________________________________________________________________________
<<inline: image001.jpg>>
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
