![]() I'm trying to prevent creating duplicate records since there is no primary key and so I really need to have the entire table in my recordset.īecause I'm running this on my local machine it appears that the operation is limited by the power of the CPU. I think slimming down the recordset would be the biggest step in fixing this but I haven't come up with any way of doing that. There are 46652 rows in the text file and about 650,000 records/rows in the ADO recordset. This is out of my control since I didn't write the software and I'm trying to stay away from making any structural changes to the database. The table does have an index on the item_cd field but the table does not have any primary key established. The database is a Visual Foxpro 6 database. I've tried using ADO's find method and it actually appears to be slower than the filter method. Running the code you see below this operation takes somewhere in the neighborhood of 3 hours. If it does not exist I'm going to create a new record. If it does exist I'm going to perform an update operation on it. Before I import a record from the text file I first need to see if one exists in the database. I'm trying to figure out how to speed up this operation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |