FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Browse via internet and repaint
Posts: 207
Joined: Fri Oct 07, 2005 07:58 AM

Browse via internet and repaint

Posted: Thu Nov 26, 2009 04:26 PM

Hello!

I'm testing an app that works on the internet via AIS and I'm trying to optimize it ... I would like know if there is a way to find out whether bSkip codeblock of TWBrowse is executed because of the navigating the browse or just because of the repainting after the window that covered the browse area was closed?

Thanks, Roman

© I'm not patented!
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: Browse via internet and repaint

Posted: Thu Nov 26, 2009 06:44 PM

Skip is executed while repainting also.
If size of AdsCacheRecords(..) is set optimally, the skip is only on records cached by the client

Regards



G. N. Rao.

Hyderabad, India
Posts: 207
Joined: Fri Oct 07, 2005 07:58 AM

Re: Browse via internet and repaint

Posted: Fri Nov 27, 2009 04:33 PM
Hello!

nageswaragunupudi wrote:Skip is executed while repainting also.
If size of AdsCacheRecords(..) is set optimally, the skip is only on records cached by the client


Thanks. I set it to AdsCacheRecords(80), but I've also reviewed the code and noticed that I made a lot of neccessary calls on events like
Code (fw): Select all Collapse
bChange, bPainted, bLostFocus, bGotFocus, bWhen and bLogicLen

Now the browse is working much much faster on ADSL / cable internet ...

Regards, Roman
© I'm not patented!
Posts: 566
Joined: Thu Aug 30, 2007 03:40 PM

Re: Browse via internet and repaint

Posted: Fri Nov 27, 2009 06:10 PM

Roman, i have this problem too.. can you share your experience? you change only adscacherecords? thanks

Posts: 207
Joined: Fri Oct 07, 2005 07:58 AM

Re: Browse via internet and repaint

Posted: Tue Dec 01, 2009 03:02 PM
Hello!

norberto wrote:
I set it to AdsCacheRecords(80), but I've also reviewed the code and noticed that I made a lot of neccessary calls

i have this problem too.. can you share your experience? you change only adscacherecords? thanks


I'm sorry that I was not clear in my reply. I've added the AdsCacheRecords(80) just to be safe, because I didn't know the default value - the setting didn't accelerate the browse.

My application is MDI based - it is possible to browse one table (with single alias) in different MDI windows with different filters/scopes. So on each event like bGotFocus or bRepaint I use functions like dbSelectArea, dbSetOrder, dbSetScope, dbGoto and similar to be sure that repainting works correctly. After I removed most calls to those functions, browse became much faster (but now I can't use multiple MDI windows) ...

Regards, Roman
© I'm not patented!
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: Browse via internet and repaint

Posted: Wed Dec 02, 2009 05:21 AM

you can open the same table with different alias for each Browse in each MDI. This works well. Each browse can be navigated independently and the server optimizes performance well when same table is opened with different aliases.

Regards



G. N. Rao.

Hyderabad, India

Continue the discussion