Need advice : I am transfering data from Access table( 19 fields mostly text string) to sapdb using delphi 6.xx I am using ADODataset by setting connection to Access and SAPDB using kstart := gettimetick ; while not.fromtable eof do begin for i := 0 to fromtable.fieldcount -1 do begin totable.insert ; totable.fields[i] = fromtable.fields[i] ; totable.post; end; // for fromtable.next end //while kend := gettimetick;
mytime = kend - kstart; this takes 940 msecs. And I can tell it is long( about 100 meter dash event !!!) Any advice as to how to make this faster ? ( one would be to use batchupdate) or how do I do this from 2 ADOdatabase sources like : insert into totable(inSAPDB) from fromtable( in Access) Thanks for any help. samira _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
