FiveTech Software tech support forums

... table with 700,000 customers with large number of columns was being browsed very comfortably with xbrowse over wide area network. ( Those days the speeds were much less over WAN ). This particular browse was very feature rich providing the required information on a click of button with different ...

Mr. Klyber

Please see this posting, if this helps you to achieve better speeds for importing data reliably.

viewtopic.php?f=3&t=20763

... of people browsing and reporting on the same database at the same time. 2. How long the index has been in use (updated). A new clean built index speeds up the access. 3. The underlying order of the data. If the data is already in the order of the index the times are better. This test is on a ...

... avoids lengthy coding and therefore bug-free. It is much easier to maintain the code too. May or may not be faster in execution but difference in speeds may not be perceptible. Except in a very rare case like your installation, this works well on all installations of XP and above.

... and for repairs. ) But those were the days when we did not have these advanced functions. Now these functions are available. I did not compare the speeds but please consider what happens in these two different cases. Assume the dbf resides on a remote server. Our program is executed on the client ...

... filters and all features, with around 200 simultaneous users on client server environment over slow speed wide area network ( those days our WAN speeds were as low as 64kbps/128 kbps). There are a few tricks to use XBrowse with ADS. If followed we gain speeds similar to WBrowse.

When we SET OPTIMIZE ON on DBFCDX, both OrdScope and DbSetFilter() work with acceptable speeds, if we create indexes in the right way, even on quite large tables.

It is a good idea to popup of a list of unoccupied rooms and let the user select one of them.

... only the required columns against reading all columns from the table is theoretically faster than reading all the columns. But the difference in speeds and burden on the server or network traffic may not be perceptible in many cases of medium sized tables. I propose this approach: 1) Construct ...

... was yesterday ( for example ), you have server logs to determine which changes were made. On the other hand...there's plenty of discussions on SQL speeds in the web, the worst are by far, those based on WINDOWS. I uploaded my MYSQL server 2 years ago in my LINUX FEDORA CORE 7 server... and there ...

... and for repairs. ) But those were the days when we did not have these advanced functions. Now these functions are available. I did not compare the speeds but please consider what happens in these two different cases. Assume the dbf resides on a remote server. Our program is executed on the client ...

... 180,000 rows might have taken more time, unless you removed the field width checking loop. Anyway glad that the customer is happy with the speeds. The program has 3 main steps. 1. Parsing the data 2. Checking for maximum field widths 3. Writing DBF. Step 1 takes the least time. Can be optimized ...

I agree with Mr James When we are experiencing sluggishness in browsing, I suggest we first look into data access speeds. When we do seek and refresh, what any browse essentially does is (1) skip the table backwards till the top of browse and (2) skip forward number of rows to fit ...

... some points mentioned by me and other friends already. It is well known that WBrowse is by far the fastest browse. XBrowse is not designed for speeds but to be feature rich. Defintiely xbrowse refreshes are slower than wbrowse. But in most cases, the speed diffferences are not perceptible. ...

... I use xBrowse to browse dbf table with more than 600,000 records with record length of 733 bytes very comfortably on LAN and WAN with different speeds, with some connections with as low speeds as 64 KBPS. The performance is very satisfactory. I use ADS server. Also, not having vertical scroll ...

... I use xBrowse to browse dbf table with more than 600,000 records with record length of 733 bytes very comfortably on LAN and WAN with different speeds, with some connections with as low speeds as 64 KBPS. The performance is very satisfactory. I use ADS server. Also, not having vertical scroll ...