Subject | RE: [IBO] HDR |
---|---|
Author | Josipovic, Nikica |
Post date | 2001-11-16T10:52Z |
Detail-Queries are parametrized queries with the primary key of the
master-dataset as search-parameter for the foreign key of the detail.
Whenever you navigate in the master, the detail will be executed with a new
parameter value.
HDR has got nothing to do with this case.
HDR _will_ help, if you get large sets of details and want to do search _in_
them, but the MD-mechanism itself is as fast as it can get.
CU,
Nick Josipovic
CMCI/Research Labs
Global Corporate Communications
SAP AG
Neurottstrasse 16
69190 Walldorf
T ++49 6227 762945
F ++49 6227 7834457
E nikica.josipovic@...
http://www.sap.com/germany
-----Original Message-----
From: Christian Gütter [mailto:cguetter@...]
Sent: Friday, November 16, 2001 11:39 AM
To: ibobjects@yahoogroups.com
Subject: [IBO] HDR
Hi list,
due to the successes of Guido Klapperich I am also playing
with the HDR (Horizontal Dataset Refinement). I saw that it
increases the speed of my queries with large result sets.
Now a small question. I have got to tables, A and B, and a
Master-Detail relationship using IBO's Masterlinks.
A is master, quite small, about 4.000 records. B is a larger
table with 30.000 records.
Does it make sense to activate HDR for the detail table,
will HDR speed up the search for the detail records
(about 5 to 40 records)?
TIA,
Christian
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
master-dataset as search-parameter for the foreign key of the detail.
Whenever you navigate in the master, the detail will be executed with a new
parameter value.
HDR has got nothing to do with this case.
HDR _will_ help, if you get large sets of details and want to do search _in_
them, but the MD-mechanism itself is as fast as it can get.
CU,
Nick Josipovic
CMCI/Research Labs
Global Corporate Communications
SAP AG
Neurottstrasse 16
69190 Walldorf
T ++49 6227 762945
F ++49 6227 7834457
E nikica.josipovic@...
http://www.sap.com/germany
-----Original Message-----
From: Christian Gütter [mailto:cguetter@...]
Sent: Friday, November 16, 2001 11:39 AM
To: ibobjects@yahoogroups.com
Subject: [IBO] HDR
Hi list,
due to the successes of Guido Klapperich I am also playing
with the HDR (Horizontal Dataset Refinement). I saw that it
increases the speed of my queries with large result sets.
Now a small question. I have got to tables, A and B, and a
Master-Detail relationship using IBO's Masterlinks.
A is master, quite small, about 4.000 records. B is a larger
table with 30.000 records.
Does it make sense to activate HDR for the detail table,
will HDR speed up the search for the detail records
(about 5 to 40 records)?
TIA,
Christian
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/