I need to extract 400.000-800.000 of record from a few oracle tables and put all of them into a datagrid.
Each record should have a total of 40 characters in 15 columns...
I can extract them and, if the number of lines if low enough,everything works fine, just using
Code: Select all
set the dgdata of grp "grSwitchAgg" of cd "Main" of stack "ExtSwitch" to theSwitchAgg
Therefore I've read about large amount of data and datagrid, so I've decided to put all the data into a custom property and through
Code: Select all
command GetDataForLine pLine, @pDataA
set itemDelimiter to tab
put pLine into pDataA["#"]
put line pLine of the uFlussiXmlDel65 of stack "ExtSwitch" into theRecord
put item 1 of theRecord into pDataA["#"]
put item 2 of theRecord into pDataA["POD"]
put item 3 of theRecord into pDataA["GDL"]
put item 4 of theRecord into pDataA["MESE_RIF"]
put item 5 of theRecord into pDataA["PNO"]
put item 6 of theRecord into pDataA["RNO"]
put item 7 of theRecord into pDataA["SNM"]
put item 8 of theRecord into pDataA["SNF"]
put item 9 of theRecord into pDataA["SNS"]
put item 10 of theRecord into pDataA["PDO"]
put item 11 of theRecord into pDataA["RFO"]
put item 12 of theRecord into pDataA["SOF"]
put item 13 of theRecord into pDataA["SOS"]
put item 14 of theRecord into pDataA["TOT"]
end GetDataForLine
Is there anything more I can do to get higher efficiency?