It rings me a bell when you use a browse in the UIB you could have
Which is related to the browse browse-2 define several lines above in your code
/* Definitions for BROWSE BROWSE-2 */
You should store/record the cCombinedOrder and set it to "" after each "Do while "
DEFINE BUFFER order2 FOR order.
DEFINE VARIABLE iOrderDetail as INTEGER INITIAL 0.
DEFINE VARIABLE cCombinedOrder as CHAR INITIAL "".
define temp-table tt No-undo
field first-order as INTEGER...
I notice several potential performance issue on code like "for each ttcustomer where not ttcustomer.found" .
Even if there is an index on the field found , the request will not use it = > Whole-Index.
You should have "for each ttcustomer where ttcustomer.found = false"
You could have a...
The request stops to read the index and the records when the value of this index does not respect the value of the index you specify
For example ;
for each order where custnum = 10 no-lock , the process will stop to read the data when it find an index with custnum > 10
for each customer...
It is OK that you read one index more than records on each part of your query
(the last one , to show it does match your index key)
83 records on customer => 84 read on index
207 order + 83 request => 290 read on index
873 orderline + 207 request => 1080 read on index.
If the read on...
I have some issue with high -n on older release of Progress when the "-shmsegsize " was too small.
Could you try to start your db with the line below
proserve sports -S 13000 -n 1606 -Mn 42 -Mpb 40 -Ma 32 -Mi 5 -shmsegsize 2G -minport 18500 -maxport 22000
I have no issue with "-Mn 42 -Mpb 40 -Ma 40" .
proserve dbnewdb -N TCP -S 4.... -n 1606 -Mn 42 -Mpb 40 -Ma 40 -Mi 5
OpenEdge Release 10.2B0830 as of Mon Feb 16 03:35:45 EST 2015
09:26:47 BROKER The startup of this database requires 70Mb of shared memory. Maximum segment size is...
Ron, i do not think this is your case (CDC was considered at length but it caused problems for us), but others could be interresting to know this
If you are not avail on the record creates , instead of doing.
Buffer-copy sourcerecord to newrecord.
You could do...