J
JimfromIndy
I've revised my procedure to update POs from an external source trying
to speed it up. What I've found is that a reliable 4 seconds per
transaction is taken up executing a simple ADO "Find" command:
rst.Find "POLineID=" & rstImpLines!POLineID,,adSearchForward,1
The recordset has 44,000 rows. The rstImpLines recordset (with 2,000
rows) is in random order (sorted by PO number, not by PO Line ID....)
Is there a faster approach? DAO faster? POLineID IS the PRIMARY Key
for the table underlying the rst recordset....
Ideas?
Jim
to speed it up. What I've found is that a reliable 4 seconds per
transaction is taken up executing a simple ADO "Find" command:
rst.Find "POLineID=" & rstImpLines!POLineID,,adSearchForward,1
The recordset has 44,000 rows. The rstImpLines recordset (with 2,000
rows) is in random order (sorted by PO number, not by PO Line ID....)
Is there a faster approach? DAO faster? POLineID IS the PRIMARY Key
for the table underlying the rst recordset....
Ideas?
Jim