I've been trying to figure out why there would be such a difference in doing an Insert Into query to my local iSeries vs my remote iSeries through MS Access. I have a simple query that has about 3800 rows of data and 4 columns. There are keyed values in both the table on the iseries and in access. When I do the Insert Into query to the iSeries in my building, it is super fast, just as quick as doing a file transfer. When I do the same query to my remote iSeries, it takes super long and appears to do it in junks. Both ODBC configurations are the same and I'm puzzled as to what is going on. My current work around is to do a file transfer outside of Access, but I'd really like to just put the data right into the table through Access without opening another table.
Has anyone dealt with this before? Any suggestions on things I can try or look at to make the data transfer quicker through Access?