G
goo
Guest
OE11.6.2 win I have an appserver procedure that receives a blobfile within an temp-table. The blob is copylobed into a longchar named lcFile. It runs smooth as long as the file is small, but now it receives a file with approx 50000 rows and each row has 30-40 columns. The codelogic is checking the first row, and based on what kind of file, it will hold a list of hte column names in cColumnList. The code is something like this: do ix = 1 to num-entries(lcFile,chr(10)). cString = entry(ix,lcFile,chr(10)). if length(cString) le 1 then next. if cString begins ',,,,,' then next. if cString begins '@' then....... : : case cImportMethod: when 'AcBal' or when 'R1Bal' then doImportFile(cString). : : otherwise leave. end case. if not obOk then return. end. : : doImportFile......: bhAtable:find-unique('where something=something and somethingelse=somethingelse and........) if not bhAtable:avail then bhAtable:buffer-create(). : assign bhAtable:buffer-field('Field...'):buffer-value = ..... : . do i = 1 to num-entries(cColumnList): bhAtable:buffer-field(entry(i,cColumnList)........ = something if i = lookup('R1',cColumnList) then bhAtable:buffer-field(..... = something. end. end. /* Method*/ Since I am running with on AppServer (but not async) and it takes more than 20 min to run it, it will stop because of the VPN timeout (I believe)... What would be a better way of approaching this? I have thought about having a process on the server, and add a process table that the file can be added to. Then I can have a serverside process that runs it and sends a message back to the user.... Any other ideas? //Geir Otto
Continue reading...
Continue reading...