Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread DBISAM internal operation
Wed, Apr 11 2007 12:26 PMPermanent 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 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image