Subject RE: [IBO] HDR
Author Josipovic, Nikica
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.


Nick Josipovic
CMCI/Research Labs
Global Corporate Communications

Neurottstrasse 16
69190 Walldorf
T ++49 6227 762945
F ++49 6227 7834457
E nikica.josipovic@...

-----Original Message-----
From: Christian G├╝tter [mailto:cguetter@...]
Sent: Friday, November 16, 2001 11:39 AM
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)?



IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to