Recent content by George Potemkin

DBI file is the only one created in $Extend\$Deleted. Other Progress temp files are visible on Windows even if a session is not use the -t parameter.

I will split your question into 3 parts: 1. Should you do a d&l? 2,906,790,153 is the total size of records in your database; 4,440,358,912 is their footprint on the disk. Even laptops have much more RAM. You can put the whole database in memory and this will completely eliminate disk I/O. 2...

I added "Size" column from pt.viewB2.txt as the "Blocks" column to tabanalys. Also I added a few columns based on the formulas: Block Size = Blocks * 8128 where 8128 = dbblocksize - 64 Usage% = (Record) Size / Block Size * 100% Dev Symmetry = (Max - Mean) / (Mean - Min) Dev Ratio = (Max - Min)...

Wow! I did not know that proutil -C viewB2 supports the -csoutput -verbose parameters. At least since version 11.7! This does not documented even in V12.8. Thanks, Patrick!

@PatrickTingen Can you upload the -csoutput files instead of tabanalys?

Almost all databases have the tables with the updates/creates ratio close to 1 (or even higher /integer/ number) no matter how long is a sampling interval. Or it's close to an integer number only on the intervals when the creates are very high. In 99.9% cases it means the programming issue - the...

Unlike the outdated dbanalys the recent versions of proutil -C viewB2 and prostrct statistics reports the number of blocks owned by the database objects resided in SAT2. Together with the "size" value from dbanalys we can estimate the unused disc space. And then we can decide if a percentage is...

Hence the unique index with this component should be deactivated or deleted.

Based only on your example, I would recommend to add the TRANSACTION keyword to the DO block: IF NOT AVAILABLE(Manifest) THEN DO TRANSACTION: iCnt4 = iCnt4 + 1. CREATE Manifest...

Where do you assign a value to Manifest.ShippingMethod? Your code is totally forgot about this field. FIND statement uses all components of the OrderNumber index. ASSIGN statement also missed at least the Transferred, CarrierCode and LocationCode fields. Your ASSIGN statement does not create...

Bingo! DELETE OBJECT ophDataSet. END PROCEDURE. /* Callee */ Tested: a caller gets all records from ophDataSet and then a callee deletes the dataset Thank you!

I was wrong. On return to the editor, Progress deletes all temp-tables linked to the orphaned datasets but it just forgets to delete the datasets themselves. EMPTY-DATASET does crash a session when dataset does not have the temp-tables. The workaround does work! In the callee I’m using...

Unfortunately, it turned out to be impossible to re-use or to delete the "forgotten" datasets from the chain in SESSION:FIRST-DATASET. DELETE OBJECT hDataset has no effect. hDataset:EMPTY-DATASET() crashes a session whatever I do with dataset before EMPTY-DATASET. IMHO, it looks like a bug...

PROCEDURE B: DEFINE OUTPUT PARAMETER DATASET-HANDLE ophDataSet. <code> END PROCEDURE. /* B */ It looks like a dataset is sent to a calling procedure at the END operator. We should not empty a dataset before the END. We can't empty a dataset after the END.

Can it be used to call a remote procedure? Demo.p calls a local procedure only because it's a demo.