reinaldocrespo wrote:
1. I like to use a lot of browses, I suppose that browsing of very large dbfs, would be very slow.
No Way !!!!, I have a program that actually browses 24 databases AT THE SAME TIME, database size are abot 200,000 records and they are pretty damn fast.
The secret is to open ALL THE FILES you are going to need at the begining of the application, and let all the files opened until you close the app.
ADS only deploys the exactly amount of record images you need. For example if your browse only shows 20 lines, ADS wil provide you 20 lines of data, no matter that you dbf has millions of records and you will recieve the data needed as you move over the file. If you wish to "read ahead" data, in order to have it ready when you perform a page-up/page-down action, you can use ADSCacheRecords() function to indicate how many records does ADS have to read in advance.
reinaldocrespo wrote:2. I like to use incremental searches on browses. How would that affect the speed when connected via the AIS?
He he he, Incremental searches are solved by the server itself, so you don't have to worry about speed, all the searches no matter if the server is local, remote or internet are solved at leats ten times faster than the way (x)Harbour does with the RDD, you may experiment some delay specially in the Internet server if you have to do too many jumps to reach the server you want, my best advice in these cases is to use a VPN, having a VPN you will have a speed similar to you LAN.
Posted: Mon Jan 23, 2006 2:08 pm