Stuart McLachlan
stuart at lexacorp.com.pg
Mon Aug 1 20:45:27 CDT 2011
No, I didn't do anythiing with the tables since: 1. There was only one record in each table 2. I didn't actually update the table, I just repeatedly moved data from one recordset buffer to the other. On 1 Aug 2011 at 21:38, William Benson (VBACreations. wrote: > Nice Test Stuart,... Did you delete table and compact in between > tests? I still think the time adding records to a table and updating > the recordset is needless expansion on the time test. The real issue > is simple reference, and I think that the fastest test for this may be > just a string assignment (or a debug.print - I opted for the former).