xbrowse slow

[Marc Venken]

I also wonder if the function :

FW_CdxCreate() // creating all indexes on all fields

will slow down a application because many tags are open? ( lets say until 20/30 tags ?)

For my kind of programming, it would be good, because i always have the bad habbit of creating some extra index's before some program loops
because I'm never shure that the base-index created before will be correct. (it probably is) since CDX if only 1 file.

Habbit from the NTX time (extra .ntx to open)

A Cdx is always update if changes are made by : Xbrowse, changes by Loops, Packs ?

On witch point do you use a Reindex function ?

[nageswaragunupudi]

You are already using locals in your program. That is right.
You are using alias for all functions and references to the field. That is a good and healthy practice. Please continue the way you are doing.

You may use field declaration and avoid aliasing ONLY in INDEX and FILTER expressions.
In all other code please continue the way you are doing and that is good.

[nageswaragunupudi]

FW_CdxCreate( [<cfieldlist>] )

Creating index on all fields is not necessary. This may result in very large cdx files and slow down on networks. Better you create index on fields that are necessary for seeks and filters. ( Filters are optimized when the fields involved are indexed)

If you specify fieldlist, you do not need to specify UPPER(), because the function automatically adds upper clause for character fields. You need to include "DELETED" in the list if you want index on DELETED()

We regret that we are not able to keep the manuals / Wiki uptodate.

But we do mention every new functionality in whatsnew.txt. That is good starting point for reference.
If you need more details of the functionality you can refer to the source code in the prg file. This helps to understand the function better as well as we learn a few hints on good programming.

[Marc Venken]

Thank You very much for the very usefull info.

[artu01]

Mr. Rao
I'm using CDX
As I said the xbrowse is slow only when I use this code

Code: Select all  Expand view

      oBrw:lIncrFilter := .t.
      oBrw:lSeekWild := .t.
      oBrw:cFilterFld := "RUC"
 

Thank you for your help