By default, the Create Seg process creates a segment bin file on the application server, which can take a long time to complete for a large strategic segment. When Campaign updates the binary file, it drops and then inserts the rows again into a cached table; the entire file is rewritten for sorting. For extremely large strategic segments (for example, 400 million IDs), it takes a long time to rewrite the entire file, even when the vast majority of the IDs have not changed.
To improve performance, you can use the doNotCreateServerBinFile property on the Configuration page to specify that strategic segments create a temp table in the data source instead of a bin file on the application server. When this property is set to
TRUE, at least one data source must be specified in the Create Seg process configuration.