Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
DBISAM internal operation |
Wed, Apr 11 2007 12:26 PM | Permanent Link |
Kyle Heironimus | We are running into some performance problems with a customer using CS over a fairly slow
VPN. As we look at optimizations, I would like to have a better handle on how DBISAM is working behind the scenes. We have a fairly straightforward table with 2000 records and each record is about 1000 bytes each. Several fields are indexed, including account name. I have a form with a standard data-aware grid from Infopower using a table and the account name index is selected. About 15 records are visible at a time. When I open the form, it seems to pull the entire table down from the server. My understanding of what should happen is the following sequence: 1. Form is opened. Table is opened with proper index set. 2. Data aware control requests 15 or so rows from the table. 3. The table component sends a request to the server for the first 15 rows. 4. The server returns the first 15 rows. 5. We're done. Obviously, my assumption is incorrect. Can someone help point out the flaw in my logic please. Thanks, Kyle |
Wed, Apr 11 2007 1:50 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Kyle
If the infopower grids are like DevEx or TMS they will have two modes. One which operates like a standard DBGrid which is what you're expecting and the other where all records are loaded into the grid to allow advanced functionality. I don't know if they do have this but its worth checking out. Roy Lambert |
Wed, Apr 11 2007 2:54 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kyle,
<< I have a form with a standard data-aware grid from Infopower using a table and the account name index is selected. About 15 records are visible at a time. When I open the form, it seems to pull the entire table down from the server. >> It shouldn't. I'm of the understanding that the InfoPower grid works just like a TDBGrid and only grabs enough rows to satisfy the visible portion of the grid. An easy way to test this is to simply perform the same operation with a standard TDBGrid. << My understanding of what should happen is the following sequence: 1. Form is opened. Table is opened with proper index set. 2. Data aware control requests 15 or so rows from the table. 3. The table component sends a request to the server for the first 15 rows. 4. The server returns the first 15 rows. 5. We're done. >> That is correct. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |