Using Indexes to Optimize DirXML Transfers
Novell Cool Solutions: Tip
Digg 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
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.)
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.
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".
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. www.webwiseone.com