FiveTech Software tech support forums

... If this is a regular operation and we like to transfer from local to remote only those records inserted or modified recently, the process can be optimized if we have a timestamp fields which is updated with every insertion and modification. In such a case, we can simply use this method and do ...

... Checkpoint 2000 generated Checkpoint 1600 and 1800 will be transferred to wormhole.app. But we need 1.6 million runs. So the save_steps need to be optimized and perhaps more.

...   END   ENDreturn nil https://imagizer.imageshack.com/v2/xq90/922/zGOZCx.png Note: Easy to write but not fully optimized for speed.

... server must be sized appropriately I don't remember how much ram each user ... In my opinion in a local area network if it were programmatically optimized the index management (DBFCDX) maybe the file/server architecture is still the winning choice each user uses the power of his own client pc ...

... save themes for ribbon bar. The color schemes are saved in an .ini file that is generated with default values. Surely the code can be improved and optimized, I hope it will be useful to you, improvements are welcome. Retomando este viejo tema, queria compartir este codigo para cambiar, generar ...

... enough mostly, there can be more demanding applications that need complex matrix calculations performed in large loops. To support this, highly optimized C level functions are also provided.

Thank you very much Villian, I have optimized and changed my code like that. oRs := oTb_ICBELGE:Open("SELECT IC_ID, IC_NO, IC_TYPE FROM icbelge")IF !EMPTY(oRs) .AND. oRs:Reccount()>0    oRs:GOTOP()  ...

SET FILTER TO !DELETED() is optimized if you have an index tag on the expression DELETED() We recommend INDEX ON DELETED() TAG DELETED  Filters are optimized if your index expressions are simple Eg: INDEX ON UPPER(CITY) ...

Code: Select all  Expand view

WHERE codicont NOT IN (SELECT codicont FROM catalogo)

This is not well optimized by MySQL

By the way how many records are there in catalogo?

... to GET Object ... and no "sleep" without "OutPut" (VERBOSE=NO) it just take < 5 Sec HMG and FiveWin need Minutes with (not optimized) GUI "Output" which is "normal" neverless i like to ask is there a Way to "Speed" up "OutPut" :idea: ...

... index tag on every large dbf as INDEX ON DELETED() TAG DELETED  Then the filter "SET FILTER TO !DELETED()" also is fully optimized. Better we familiarize ourselves with the way RDD optimizes filters.

... big help of Antonio I can now connect with Advantage Database Server. The browses and the selects are like rockets. And the html code is built and optimized with Bootstrap. So all the forms are compatible with different screen sizes. I found the Bootstrap Studio https://bootstrapstudio.io ...

Nages,

Filters are optimized using indexes and only the required records (not the entire database) are read from the server.

Hmm, I haven't used filters in many years. Are you saying that they are now as fast as scopes?

James

... Later Nantucket bought the technology from Loadstone and adopted for DBFCDX in Clipper 5.3. That is what we have now with (x)Harbour. Filters are optimized using indexes and only the required records (not the entire database) are read from the server. But to use this effectively, the programmer ...

... cWrkord )      ::gotop()   endif   Return self  Of course there are many other processes that take place, and they are also optimized as Methods within the Workorder class.  In one case, I found that I was using 5 different functions, in various places, when calculating totals. ...