Page 1 of 1
Problems Using XDBU.EXE is slow
Posted: Tue Jul 13, 2010 6:39 am
by 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.
Re: Problems Using XDBU.EXE is slow
Posted: Tue Jul 13, 2010 7:06 am
by Tom
How many fields does the table have? Does it happen with all kinds of tables or only with a special one?
Re: Problems Using XDBU.EXE is slow
Posted: Tue Jul 13, 2010 8:11 am
by digitsoft
The DBF has 85 fields and 530 records
FOXDBE
Nolberto Paulino
Re: Problems Using XDBU.EXE is slow
Posted: Tue Jul 13, 2010 8:15 am
by digitsoft
The DBF has 85 fields and 530 thousand records
FOXDBE
Nolberto Paulino
Re: Problems Using XDBU.EXE is slow
Posted: Tue Jul 13, 2010 8:30 am
by 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.
Re: Problems Using XDBU.EXE is slow
Posted: Tue Jul 13, 2010 11:01 am
by 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
Re: Problems Using XDBU.EXE is slow
Posted: Tue Jul 13, 2010 11:11 am
by 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}
Re: Problems Using XDBU.EXE is slow
Posted: Wed Jul 14, 2010 9:02 am
by 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