FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour XBrowse very slow in network with big databases (solved!)
Posts: 274
Joined: Fri Apr 04, 2008 01:25 PM
XBrowse very slow in network with big databases (solved!)
Posted: Fri Aug 08, 2008 06:44 PM

James,

yes, you're right, that's what 'solved' the problem. Tests with about 200,000 records and olb:refresh took up to 3 seconds per dbseek, whereas olb:select(0) and select(1) only take up to 0.2 seconds at most.

But indeed, we are already considering, if it's useful to wait about half a second, if there follows another keystroke, and if not, then do the dbseek.

Best Regards,

Gilbert Kuhnert
CTO Software GmbH
http://www.ctosoftware.de
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
XBrowse very slow in network with big databases (solved!)
Posted: Fri Aug 08, 2008 08:48 PM

Gilbert,
as far as I understood not xBrowse was the problem.
Would you be so kind to change the topic.
Your topic is like a statement and someone not reading the whole thread could get the impression that xBrowse is slow.
But my tests do not confirm this statement. xBrowse is indeed a fast browser.
Regards,
Otto

Posts: 274
Joined: Fri Apr 04, 2008 01:25 PM
XBrowse very slow in network with big databases (solved!)
Posted: Tue Aug 19, 2008 08:38 AM
Otto,

as far as I understand, oBrw:Refresh() is a xBrowse-Method (when oBrw is a xBrowse-object). So the performance problem is directly linked with xBrowse. But we found a solution to improve performance a lot. So I think, the topic still is ok.
But I want to share a better solution than I posted before. Instead of
oBrw:Select(0) 
oBrw:Select(1)

we now use
oBrw:GetDC()
oBrw:Paint()
oBrw:ReleaseDC()
Best Regards,

Gilbert Kuhnert
CTO Software GmbH
http://www.ctosoftware.de
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
XBrowse very slow in network with big databases (solved!)
Posted: Tue Aug 19, 2008 09:39 AM

Gilbert,

Why don't you just use oBrw:Refresh() ?

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 274
Joined: Fri Apr 04, 2008 01:25 PM
XBrowse very slow in network with big databases (solved!)
Posted: Tue Aug 19, 2008 10:12 AM

Antonio,

because oBrw:Refresh() made our search very slow (in network with a big database, when the database is in use at more than one computer simultaneously)
That was the outcome of our search, why xBrowse was slow.

On our testing system, oBrw:Refresh() still takes up to 3 seconds, while oBrw:Paint() takes about 0.1s

Best Regards,

Gilbert Kuhnert
CTO Software GmbH
http://www.ctosoftware.de

Continue the discussion