Search results

Kenneth, I can only answer what I think your questions are. Running .r (object) code IS much faster that running .p (source) code. This is because Progress would have to compile the source code at run-time in order to use it. To avoid crc problems, you would only need to recompile...

I think we're moving away from the initial topic. Suggest you might consider posting a topic "What performance benefits gained from fixed extents". However, Progress KB10759 describes the performance difference as "significant". Your strategy might be forced upon you by your users, but...

Letting extents grow dynamically will affect your performance. Whenever extra space requires to be written to, there will be a delay whilst the space is reserved prior to the writing being done. toddt's principal of monitoring the fixed extents so that a new fixed extent is added before...

You can also go to the "R&D" options on promon, choose "Status Displays", then "Database" and examine the values for "Empty Blocks". This will show you both the number of empty blocks and the percentage of empty blocks.

Is there a method of determining if all records for a given query have been fetched by the Smart data Object? Looking at the docs for 9.1B would suggest you could use the function getNextBatchRow, but this function does not appear to be defined within data.p for either 9.1B or 9.1C (Our...

This can happen if a new unique index is added as inactive, and then activated using idxbuild. A warning would appear on the idxbuild report. Had you tried to add the index as active, a warning would have told you that you had duplicate values and would have backed out the adding of the...

By much experimentation and randomly hitting buttons, the following seems to achieve the desired result. APPLY "HOME" TO ip-hBrowse. PUBLISH 'fetchPrev' FROM hNavigate. APPLY "END" TO ip-hBrowse. hQuery:REPOSITION-TO-ROWID(rRowid) NO-ERROR. Where ip-hBrowse is the browser on...

I have a smartwindow with sdo, sdb and navigation toolbar. The user is able to re-sort the data in the browser as per their requirements. This is done by reopening the browser query "FOR EACH RowObject BY ....". The navigation toolbar by definition, however, works on the database query...

I haven't tried this, but it might work Store the _file._valexp and _field._valexp fields in a temp table and set them to null on the meta-schema. Perform your upload. Use the temp table to repopulate the _valexp fields. You could also find the person who put cross table validation...

Opinion in our office seems to be that, certainly in older versions of Progress, setting an index to unique would slow database performance. This was because before writing the record, Progress would have to perform additional checks to verify the uniqueness of the index element(s). I...

Try the following. hDefBuffer is the default buffer handle for the table on which the query is running (hQuery:GET-BUFFER-HANDLE(1)) and hQuery is your query. hQuery:GET-FIRST. REPEAT: ASSIGN cOutput = "". DO iLoop = 1 TO hDefBuff:NUM-FIELDS: ASSIGN hField =...

I've just tried this on our dynamic example and it worked. Put your freeform browser on the window. Go to the OPEN_QUERY "trigger" and choose to DELETE THE TRIGGER. It will give you a warning message - don't worry. Then as before....... /* New code */ ASSIGN v-hBrowse =...

I would have thought that a static freeform browser would require a compilable OPEN_QUERY statement. This, in turn, would suggest something to stick at the end of your FOR EACH/PRESELECT EACH clause. If you don't use a temp table or a database table, what do you use? Static is old-hat. Come...

I don't know if this answers your question, but.... We use A dynamic query v-hQuery AND the default buffer of a dynamic temp-table v-hTmp_Buffer And create A dynamic browse CREATE BROWSE v-hBrowse ASSIGN QUERY = v-hQuery PARENT = FRAME...

To list all tables in all connected databases, do the following: DEF VAR i AS INT NO-UNDO. REPEAT i = 1 TO num-dbs: RUN changealias(INPUT i). RUN listtable(INPUT "Your Field Name") . END. /* changealias.p */ DEF INPUT PARAM i AS INT NO-UNDO. DELETE ALIAS dictdb. create alias...

FOR EACH _File NO-LOCK, EACH _Field OF _File: IF _Field._Field-Name EQ "Your Field Name" THEN DISPLAY _File._File-Name. END.

Lance, What steps did you do to the database when you upgraded the server? When we moved from 9.1B to 9.1C we had to: Work with 9.1B Stop the database server. Stop after imaging and 2 phase commit. TRUNCATE THE BI FILE (not obvious, but necessary) Upgrade to...

What I had in mind was: Do this only once: Create an empty database with the production schema. Add all the indexes you require for reporting. Create an incremental .df file between this database and the production database called, for instance, addindex.df. This is what I meant by the...

OK, I don't know if this can be done, but I'm sure if it can someone will tell us how. Potentially, you could create the reporting database from the production database and then apply a prepared incremental .df to add the reporting indexes. As I've said, I don't know how you would...

How about having all the indexes on your production database, but set those only used for reporting to inactive. Create your reporting databse by copying the production database each night. Perform an idxbuild on the reporting database to activate the reporting indexes.