I have a JDBC driver connecting to a MSSQL database. The driver is
configured for indirect processing. Our current IDVault has 300,000 user
objects managed through this interface.

versioninfo
Driver name: Identity Manager Driver for JDBC
Driver module: com.novell.nds.dirxml.driver.jdbc.JDBCDriverShim
Driver version: 3.5.4

there are times when the indrect.process table will have 500,000 to
1,000,000 entries due to updates being done to the user/group objects in
SQL. This causes the connector to slow to processing 1 record about
every 3-8 sedonds. we've found this is from the cennector doing a
"select *" on the indorect.process table after each row is completed.

Is there a way to change this to perform a select first or similar. Its
very costly doing select * everytime to get the first record.

thanks for any help


--
Bryan Newswanger
University of Cincinnati
------------------------------------------------------------------------
6202936's Profile: http://forums.novell.com/member.php?userid=5439
View this thread: http://forums.novell.com/showthread.php?t=416863