FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexActive topicsAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour Why am I having xbrowse too slow?
Silvio.Falconi
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
Why am I having xbrowse too slow?
Posted: Tue Apr 05, 2022 10:18 AM


I keep having display problems, there are about 6500 records in the archive and each record has 57 fields.
the size of the dbf archive is about 757 bytes
If I open the dbf with EmagDbu or with fwdbu I have no problems
I am using Tdatabase and scrolling is very slow
how can i improve the visualization?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Otto
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Why am I having xbrowse too slow?
Posted: Tue Apr 05, 2022 10:30 AM

Silvio, you should include in your software the
Benford's Law and Euler's number into your software for prediction.

Also the integration of AI would be interesting. Yes, even very interesting.

viewtopic.php?f=3t=41605

Best regards,
Otto

&

Silvio.Falconi
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
Re: Why am I having xbrowse too slow?
Posted: Tue Apr 05, 2022 12:55 PM
Otto wrote:Silvio, you should include in your software the
Benford's Law and Euler's number into your software for prediction.

Also the integration of AI would be interesting. Yes, even very interesting.

viewtopic.php?f=3&t=41605

Best regards,
Otto

I not know it
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Otto
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Why am I having xbrowse too slow?
Posted: Tue Apr 05, 2022 02:11 PM

Silvio, you made a beautiful design.
This looks superb.
Best regards,
Otto

mauri.menabue
Posts: 181
Joined: Thu Apr 17, 2008 02:38 PM
Re: Why am I having xbrowse too slow?
Posted: Wed Apr 06, 2022 07:49 AM

Hi Silvio,
Try to remove all the frills colors, filters or view the records in a simple way,
maybe even just one city at a time, then enter one thing at a time hoping to
understand who slows down the display.
it is a way of proceeding not as a computer scientist but as a policeman but
the point is to solve the problem, we are not Nages.

TIA

Silvio.Falconi
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
Re: Why am I having xbrowse too slow?
Posted: Wed Apr 06, 2022 08:16 AM
mauri.menabue wrote:Hi Silvio,
Try to remove all the frills colors, filters or view the records in a simple way,
maybe even just one city at a time, then enter one thing at a time hoping to
understand who slows down the display.
it is a way of proceeding not as a computer scientist but as a policeman but
the point is to solve the problem, we are not Nages.

TIA



this morning I realized that maybe xbrowse doesn't work well, that is I took an example of Nages and I put a dbf with 106353 records in it
the search is very very very very very slow, too slow
so xbrowse works for small archives even if I have 9000 records in another program and it runs fine
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Marc Venken
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Re: Why am I having xbrowse too slow?
Posted: Wed Apr 06, 2022 08:54 AM

Xbrowse needs correct tuning to work the best.

Correct use of : set filter to, set relation to, Ordscope's ....
Correct setup of indexes...
Calculating fields slows down
Colors are only repainted in the screen that you see, so that should not matter to much.

I also have speed issues a moments, but more in case of networking. (Can be related to network setup)

I think if mr. Rao would be so kind of making a Sticky-Topic : Xbrowse Best speed performance
many users of the forum could benifid from it.

There have been many postings on speed issues, but Mr. Rao is the right person to setup this post.

Marc Venken

Using: FWH 23.08 with Harbour
Otto
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Why am I having xbrowse too slow?
Posted: Wed Apr 06, 2022 09:01 AM

Marc,
>Can be related to network setup

Have you tried RemoteDesktop?
If not, you should.
It is also a good preparation for web programming as you change your way of thinking about data access.

Best regards,
Otto

hmpaquito
Posts: 1515
Joined: Thu Oct 30, 2008 02:37 PM
Re: Why am I having xbrowse too slow?
Posted: Wed Apr 06, 2022 09:04 AM

Hola,

Nuestros browses van a ser lentos siempre que se muestren pocos entre muchos registros.
Por desgracia no uso xBrowse (llegó cuando ya tenia todo montado) y si utilizo SBrowse.

Utilizo busquedas con wildcards OrdSeekWild() que precisamente presentan el escenario antes descrito: En grandes .dbf muestran pocos registros, con lo cual un set filter ahi puede ser mortal.

¿ Como lo solucione ?

1º Presento el sbrowse en dbf
2º El usuario realiza la busqueda
3º Relleno un array con los recnos encontrados en la anterior busqueda
4º Le doy la vuelta al sbrowse que pasa a ser un sbrowse de array (el de los resultados)

Va como un avion y el usuario no percibe absolutamente nada. Cuando el usuario borra el texto en el get de busqueda entonces el sbrowse vuelve a ser sobre una .dbf

Salu2

nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Why am I having xbrowse too slow?
Posted: Sat Apr 09, 2022 02:46 PM
I am using Tdatabase and scrolling is very slow

Always working directly with DBF is faster than working through TDataBase.
Still it will not be VERY SLOW. Only a little slower.
To reduce the speed differences, you may use
Code (fw): Select all Collapse
oDbf:lBuffer := .f.


Normal speeds of scrolling DBF data with 100,000 records with XBrowse:
Single line scrolling, Page scrolling and Scrollbar scrolling:



This speed is definitely not slow.
Even using TDatabase, you should not notice much difference.
If it is conspicuously slow, then examine:
1. Data access speeds (nothing to do with xbrowse)
2. Complex filters.
3. Most likely, your own program.
Regards



G. N. Rao.

Hyderabad, India
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Why am I having xbrowse too slow?
Posted: Sat Apr 09, 2022 02:51 PM
Zoom/Unzoom speeds of 100,000 records DBF.

Regards



G. N. Rao.

Hyderabad, India
Silvio.Falconi
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
Re: Why am I having xbrowse too slow?
Posted: Sat Apr 09, 2022 05:47 PM

Nages,
If we try with xbrowser oDbf it is fast no problem
If we insert a xbrowse into a dialog as the test sample I sent you it is too slow

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Continue the discussion

Static archive · New replies & topics via GitHub Discussions