Search results

This code doesn't have any issues - the problem lies within the sub-procedure, of which only the call is present. Even so, thanks for your comments.

Thanks, do appreciate all help - the problem-line is a procedure call to update the Email Address in the Update and Create Blocks, as below - there is a call to a custom-library procedure, that has always worked to update/create Email address in the database, until now ... when the volume has...

when that happens, the slowness is very abrupt - so imports first 50,000 lines at a good speed - and then the speed falls down exponentially and instantaneously

got to line of code that was slowing it down - commented it out, though I do need it - but without that line, the program goes on to import 320,000 lines of data ! it appears that there might be a build-up of buffer-size, that MS-Windows does not let the Progress program to get away with, and...

Have obtained the following now :- a) Debug-List file and protrace.pid# files from the stall point b) Debug.log from Log-manager c) 4GLtrace.log ( using -clientLog. -logentrytypes and -loglevel ) - 7gb file, however I will open it !? time to investigate ..

srt is large 287Mb - probably because it's filling up the temp-tables with the data from the input file and building the temp-table indexes but don't suspect it would be the sorting of database tables for want of indexes, or the right indexes

srt are available - dbi may have be cleared up by Progress

not even of this month, actually

yeah got 'em - but it's not showing the ones from today

great, thanks - yes the files are there - haven't been able to access them yet Have put some Logs in the code as below - is there a way to have Log-manager to write them UNBUFFERED because I only get to see a zero-sized Log file from the below. IF NOT lAppliedLog and ttLineNo GT 46000 THEN DO...

Can't find dbi or srt files in ( -T c:\progress11\temp folder) - possibly because it's a TDE database

1. Next will be do a debug-list on the compile to read protrace - thanks for that 2. Indeed, -q has made a difference - within 12 minutes it has got to where it did after 7 hours without -q, but has stopped moving further now. I have noticed that the moment it gets to this point of "no...

1. Next applying -q to the client .pf and restart it. 2. Have opened a case with tech support. 3. Just noticed that a 50,000 Lines data update was started 7 hours ago - had reached up to 46,454 lines in 12 minutes, but then had stopped moving , so had abandoned it because it hadn't for over...

Hi Rob, Tom - thanks , please herewith some more detail -cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf),-p mainprogram.w,-pf \\WinServer\folder-name\dbname\dbname.pf,-inp 32000,-s 100,-rand 2,-Mm 32600,-D 300,-mmax 5500,-cpstream...

yes currently going through the progetstack trace collection

Thanks for all help and showing me process explorer. Please find attached the actual .st from the Linux box, which is a lot longer with actual extent sizes. The db Server is started for Both - 4gl/sql Only one user is connected to this Test db. no other I/O at the time of Update. [DB Startup Log...

Thanks for that, appreciate Other startup parameters on the db are currently as below: -Mn 15, -Mm 32600, -maxport 10,000 -n 75, -Mqb 15, -pinshm, -lruskips 100, -lru2skips 100, -bistall, -bithold 6144, -bibufs 50, -pica 8192 Linux OS has 4096 blocksize - db blocksize is 8192 AI is not enabled...

Progress 11.7 Windows client - Linux db server -B 3,000,000, -B2 500,000, -L 1,000,000 We have recently increased the Import Data volume to 300,000 lines causing DB updates to almost halt after updating 38000 records. I have cut the Import Data File to contain 100,000 lines - as a result the...