Richard Troy wrote:
It just occurred to me: Ensure there are no indicies on your tables as you reload and then recreate the indicies after the load is complete. The time it takes to continually add pages to an index can be vastly longer than creating a new index as the data set size is known in advance...
Thanks for this hint. I know that there is a -ccm switch in copydb and unloaddb command that will change the copy.in script to the sequence you describe (index creation after data load), BUT: whether I use this flag or not, Ingres 2006 is much slower than R3 in both cases.
Regards Gerhard _______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
