Novell is now a part of Micro Focus

Using Indexes to Optimize DirXML Transfers

Novell Cool Solutions: Tip

Digg This - Slashdot This

Posted: 28 Mar 2002

If you've experienced speed problems when using the DirXML delimited text driver, this tip may be just what you're looking for.

For updates on this tip, see TID-10069218

The Issue:
Attempting to import (migrate) several thousand users through DirXML delimited text driver into NDS on a NetWare server was causing high CPU utilization and a very slow import. The average import speed was about one user every 3 seconds. (About 20 users a minute.)

The Cause:
Every time a user was imported into the directory, the DirXML matching rule checked the entire attribute list on every object in the tree for a match on WorkforceID before importing the user.

The Fix:
Create an index for WorkforceID on the server object where the DirXML engine is installed. To do this, go to the properties of the server object, "indexes" tab, and add WorkforceID (or whatever attribute exists in the matching rule), and set the Rule to "Value".

The Footnote:
In the sample case, this fix increased the import speed to approximately 6 users per second. (Our math says that's about 1800 times better -- your mileage may vary.)

Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions.

© Copyright Micro Focus or one of its affiliates