CDX TOO SLOW

[Silvio.Falconi]

I have an archive of 61819 Records

I must index it on seven indexes

When Imade (cdbf)->(OrdSetFocus(n)) and refresh() the xbrowse it is too slow

How I can resolve this problem

I'm using a portable Pc with 8GBRam Winseven

[Mulyadi]

Sivio...

DBF/CDX originally work base in physical platform.
the problem has came to me long time ago. from the time that, i migration to Oracle database.

Just a good idea. maybe you have to cast about to use other database like SQL Server, Oracle, DB2 etc....


Mulyadi

[Gale FORd]

Do you have a filter or scope set?

[Silvio.Falconi]

I use cdx to index the dbf then I use dbsetfilter but the filter is activate then when the user made a search not when I open the file
I'm afraid it not run ok or run slowly because perhaps xbrowse not run ok
On old app 16 bit I used lbx( wbrowse) no problem

[Rick Lipkin]

Silvo

Set Scope to... is much faster than dbSetFilter.
Rick Lipkin

Code: Select all  Expand view

#Include "Ord.ch"

cStockno := "12345"

Select Invoice
Set Order to Tag Stockno

Set Scope to cStockno
Seek cStockno

xbrowse()

 

[Gale FORd]

If the filter is active while the browse is updating it might be the reason it is slow.
If you use a filter just for the search then why use a filter at all, a locate would be better?
Another issue that comes up is the number of deleted records that may have to be skipped during the browse painting.

[Gale FORd]

Is this related to the incremental search question in another thread.
If so the the problem is trying to use wildseek() in a filter. It does not allow any optimization against the indexes.
When the browse does a go top and then tries to paint the rows it has to compare every record to match filter instead of using the indexes to solve filter logic.

[Silvio.Falconi]

the problem I have seven Get control and I wish filter on these get on dbf and I not Know how make it

[stefano]

did you try

index on DESTATOF to "TEMP" FOR (DESTATOF = "ARRIVATA" .OR. DESTATOF = "IN LAVORAZIONE" ) MEMORY

I had the same problem with xbrowse (30 pc in the network and for now 15000 records, use dbf and ntx) and it's  ok. In fact I can set up filters and indexes in a free way and prg responds quickly.

Stefano