Subject FB 1.5 RC5 and DB design success story!
Author Don Gollahon
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
Fix all indexes that had a huge amount of duplicates
Take the duplicate record check out of import and make it it's own
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.


Thank you all very much!

Don Gollahon
"The Original GenSoft Prodigal"