Home
Forums
New posts
Search forums
What's new
New posts
New resources
Latest activity
Resources
Latest reviews
Search resources
Members
Registered members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
Registered members
Current visitors
Menu
Log in
Register
Install the app
Install
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
S
Shail
New Member
·
52
Joined
Jul 27, 2022
Last seen
Aug 2, 2022
Messages
18
Reaction score
0
Points
1
Find
Find content
Find all content by Shail
Find all threads by Shail
Latest activity
Postings
About
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
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...
Aug 1, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
Thanks, do appreciate all help - the problem-line is a procedure call to update the Email Address in the Update and Create Blocks, as...
Aug 1, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
when that happens, the slowness is very abrupt - so imports first 50,000 lines at a good speed - and then the speed falls down...
Aug 1, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
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...
Aug 1, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
Have obtained the following now :- a) Debug-List file and protrace.pid# files from the stall point b) Debug.log from Log-manager c)...
Jul 29, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
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...
Jul 29, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
srt are available - dbi may have be cleared up by Progress
Jul 29, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
not even of this month, actually
Jul 29, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
yeah got 'em - but it's not showing the ones from today
Jul 29, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
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...
Jul 29, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
Can't find dbi or srt files in ( -T c:\progress11\temp folder) - possibly because it's a TDE database
Jul 29, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
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...
Jul 28, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
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...
Jul 28, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
Hi Rob, Tom - thanks , please herewith some more detail -cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d...
Jul 28, 2022
S
Shail
replied to the thread
Question
Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server
.
yes currently going through the progetstack trace collection
Jul 28, 2022
Loading…
Loading…
Home
Members
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top