FiveTech Software tech support forums

... The closest thing I know of to rollback for .dbf files is to work with temporary files and then commit at the end It is a technique that greatly improves the referential apparatus in the event that a cut occurs. In any case, the rollback, as far as I know, does not exist in all bb.dd. and it ...

... the great power for complex queries. Calculations are done on the server and only summary comes to server reducing network traffic and also highly improves speeds. Free from the limitations of DBFCDX, importantly size. Better performance with more concurrent users and larger tables. CONS: Cost ...

... should be enough for most applications. Where large computations are to be performed in large loops writing the code in C using these C functions improves the execution speed considerably.

... should be enough for most applications. Where large computations are to be performed in large loops writing the code in C using these C functions improves the execution speed considerably. Example: This code written using FW_Matrix() is taking 3.0 to 4.0 seconds for executing 10,000 times.   ...

... In this case, please remove all totals. We should never call oBrw:MakeTotals() for large tables (even for DBF). Let us see if the performance improves after completely removing totals and using Dolphin's pagination with page size of 100 or so. Once we achieve acceptable performance, then we ...

... create good indexes Its not possible, I have fwh 13.01 - Creating index on "DELETED()" and then "SET FILTER TO !DELETED()" improves performance on dbfs having many deleted records. I will try that - On network, smaller index files improves performance. Build indexes with ...

... FW_CdxCreate( [fieldslist] ) helps create good indexes - Creating index on "DELETED()" and then "SET FILTER TO !DELETED()" improves performance on dbfs having many deleted records. - On network, smaller index files improves performance.

... between the original and modified values and refreshes the footer without having the call MakeTotals() again. This recalculation feature highly improves the performance. Issues: However this recalculation feaure is used by xbrowse only when the value of a cell is modified with inline edit and ...

... for touch selection. - Enhancement: XBrowse now full uses GDI+ calls only for both reading and rendering all types of bitmaps and images. This improves quality of image rendering. - Calling oBrw:Refresh() or any method which in turn calls the refresh method (eg. oCol:Hide(), etc ) before oBrw:Adjust() ...

... for touch selection. - Enhancement: XBrowse now full uses GDI+ calls only for both reading and rendering all types of bitmaps and images. This improves quality of image rendering. - Calling oBrw:Refresh() or any method which in turn calls the refresh method (eg. oCol:Hide(), etc ) before oBrw:Adjust() ...

... 3) if still necessary remove vertical scrollbar. dbf: 1) keep smaller index files. 2) SET FILTER TO !DELETED() and have an index tag on DELETED(). Improves performance when there are many deleted records. 3) if you are using filters, ensure that they are fully optimized.

...     endif If you do oBtn:lBorder := .F. then you will avoid it (at least for a temporary solution) Please try it and lets see if the paiting improves, thanks :-)

... Code compacted. - Enhancement: Avoided unnecessary calls to Refresh() to improve performance, particulary at the time of initial display. This improves performance in case of slow access RDDs. - Enhancement: Protection is provided against inadvertent deletion or hiding of all columns by an ...

... the great power for complex queries. Calculations are done on the server and only summary comes to server reducing network traffic and also highly improves speeds. Free from the limitations of DBFCDX, importantly size. Better performance with more concurrent users and larger tables. CONS: Cost ...

Hi Lucas,

1. Issue cAlias->( AdsCacheRecords( <nRecs> ) ) or TABLE->( AdsCacheRecords( 50 ) ).. in my case, it improves the speed.
2. on your ads.ini:

[Settings]
COMPRESSION = Always
USE_TCP_IP = 1
PACKET_SIZE = 512 ;or 1024

This also improves my speed.


Kind regards,