I just wanted to pass this along for your encouragement:

Due to following the suggestions in the FB support and development
newsgroups over the past month we were able to greatly improve the intense
processing of our master databases. To recap, the changes made were:

Upgrade from Windows FB 1.02 SS to FB 1.5 RC5 Classic (to use multiple
processors)
Fix all indexes that had a huge amount of duplicates
Take the duplicate record check out of import and make it it's own
process
Change the duplicate record check logic

These suggestions were made by Nickolay Samofatov, Sean Leyne, Alexander
Nevsky, and others.

The result: The normal 23 hour processing of our largest database was
reduced to 2 hours! And the server has now been running multiple databases
with no "lockups" for over a week now. Database backups and cleanups run
smooth and the sweep (after deleting 3 million records out of around 7 to 9
million) takes only 3 to 4 minutes rather than hours or even days.

Fantastic!

Thank you all very much!



Don Gollahon
gollahon@...
"The Original GenSoft Prodigal"