Problems Using XDBU.EXE is slow

[digitsoft]

Hi Roger

I have problems when I load XDBU.EXE Using a DBF and then use browse
the XDBU.EXE last long to load the browse and that same thing happens on my system.

You can tell me what was going on, with eXpress

Nolberto Paulino
Regards.

[Tom]

How many fields does the table have? Does it happen with all kinds of tables or only with a special one?

[digitsoft]

The DBF has 85 fields and 530 records
FOXDBE

Nolberto Paulino

[digitsoft]

The DBF has 85 fields and 530 thousand records
FOXDBE

Nolberto Paulino

[rdonnay]

Are you saying that this started suddenly?

Earlier versions of DC_Dbu() would automatically switch from using DC_XbpBrowse() to using DC_XbpQuickBrowse() whenever there were more than 40 fields because it takes a long time to create a browse of 84 columns.

In build 254 (I think) I changed it to always use DC_XbpBrowse() because computers are faster than when I wrote this 10 years ago. Apparently, this is still a problem for you.

Here is what you can do.

Remove the // comment marker from line 1029 of \exp19\source\dclip1\_dcdbu.prg.
Then rebuild DCLIP1.DLL by running build19.bat or build19_sl1.bat.

Code: Select all

IF !('98' $ Os()) // .AND. Len(aFields) < 40

Another option is to save the fields you want to browse, by picking the fields to browse and saving the list to a .DBR file. If you choose less than 40 fields, it will browse much faster.

[digitsoft]

Hi Roger
The problem I have when I use DBF large with over 600 thousand records
April at the Time of the DBF take long, and when I insert a record Also New

When I navigate in the Browse, sometimes it takes a lot, This makes both
in RED with locally

Roger, you could tell me the steps to follow in order to accelerate Reading
and recording process and that this is not so slow, and with regard to how I
can improve browse pagination to be faster in the use of filtering.

I Loaded the Task Manager and I've noticed that whenever I go to each module
of the application Process is constantly increasing

First entry into the Task Manager process to PV.EXE with 24.584 KB the Load
Point of Sale Module Expands to 29.688 KB, I leave and enter another Once the
POS module and Increase to 29.720 KB

Now I leave the system
When I go back to the Point of Sale Module Shoot This is 47.352 KB
and sientra the Client Module Increases to 53.860 KB

When I call each module _ActiveDLL use this function ("(|o|pvpu01 (oDlg: drawingarea)) ")

FUNCTION _ActiveDLL (bblock)
return (| o | o: = Thread (): new () or: Start (& (bblock)))

and when I leave the mudulo threadobject use this code (): quit ()

Now you can tell me please what would be my solution
This is urgent I

The terminal is like this P4 1G RAM each.


Nolberto Paulino
Regards

[rdonnay]

Ok, this is a different problem and it is caused by the fact that it take time to calculate the logical (not physical) record of a large, indexed database.

This is so the thumb on the scrollbar can be correctly positioned.

I am not sure why this is a problem for you because the thumb is supposed to be locked if there are more than 100,000 records.

If you will send me your database and indexes, I will see what I can do.

The below code is from _DCDBU.PRG:

Code: Select all

  @ 5,5 DCBROWSE oBrowse ;
        INVISIBLE ;
        PARENT oBrowStatic ;
        SIZE oBrowStatic:currentSize()[1]-10,oBrowStatic:currentSize()[2]-10 ;
        PIXEL ;
        ALIAS cAlias ;
        THUMBLOCK IIF(cAlias=='QUERY',0,100000) ;
        FONT '8.Terminal' ;
        EDIT xbeBRW_ItemSelected MODE DCGUI_BROWSE_EDITACROSSDOWN ;
        PRESENTATION DC_BrowPres() ;
        GOTFOCUS {||DC_DbSel(cAlias)} ;
        ITEMMARKED {||DC_GetRefresh(aGetList,'DELETE_BUTTON'), ;
                      DC_GetRefresh(aGetList,'RECORD_NUMBER')} ;
        FREEZELEFT {1,2}

[digitsoft]

Hi Roger
I realized that my software using XDBU and done with eXpress
ram memory always increases more and more

in XDBU if there will be a screen to find a DBF and then Close
RAM is not its size down, if that is repeated several times give
mind that is always increasing

This is the problem I have in my software, but I can see why
this happening, maybe you can realize and see how to
solve this major problem.


Nolberto Paulino
Regards