FiveTech Support Forums

Dear Mr Rao,

In WAN connections we get xBrowse quite slow. The rest of the operations with DBFs are fine.

Would be possible for xBrowse to only load records needed to fit the screen size, and when scrolling load more?.

Or a kind of paging?.

I hope this feature will be very helpfull for all users, as Cloud and WAN are more important nowadays.

Thank you.

Would be possible for xBrowse to only load records needed to fit the screen size, and when scrolling load more?.

Thats what it does actually.

Present day's communication speeds are far better than they used be a decade back.
More than a decade back I was using xbrowse on WAN with very low speeds of 64 kbps without any problem,
But we do need to take care of fine tuning the dbf and what we are doing with xbrowse.

xbrowse:
1) do not use any feature that involves full refresh.
2) avoid using any feature that depends on OrdKeyNo() ( example pajama colors)
3) if still necessary remove vertical scrollbar.

dbf:
1) keep smaller index files.
2) SET FILTER TO !DELETED() and have an index tag on DELETED(). Improves performance when there are many deleted records.
3) if you are using filters, ensure that they are fully optimized.

Dear Mr. Rao,

We did those changes with no luck. Dbfs have less than 1.000 records.

What markee style is the fastest?.

Also, at the mean time do yo use xbrowse in Wan enviroments and Dbf databases?.

Thank you very much.

1000 records dbf should not be a problem.
MarqueeStyle: Any other than WIN7 look

I suggest first let us test with a DBF of 1000 records.
For test make sure it does not have any deleted records.
Use DBFCDX
Let it have only one Tag in the cdx file. Preferably on a small numeric column.

Prepare a small simple xbrowse. Limit the columns to what we can see on the screen.
Do not add any features of xbrowse.

Let us see the performance. And then decide what all we can add to the browse without hitting performance.