Probably an "order by" that doesn't correspond to the index used by the
where-clause, or, in absence of where-clause, to no index at all.
--
Kind reGards,
Gerard
(ghp_at_santens.be; ghp_at_skynet.be)
Sigrid Staudte <mstaudte_at_rz.uni-leipzig.de> schreef in artikel
<345B60D2.3CEF2B73_at_rz.uni-leipzig.de>...
> I have following problem with a Forms-mask:
>
> Using a List of Value (LOV-Button with When-Button-Pressed-
> Trigger) I have to select some customer data and put them
> in several mask fields. Standard LOV is too slow for this
> because of more than 4500 entries.
>
> At the moment I use a separate mask of type LOV. It is
> called with a call-form at a Key-Listval-Trigger of the
> used item and fills two global variables (these contains the
> primary keys of the selected person). After that the 2
> variables are used within a When-Validate-Item Trigger to
> put the right data from database at the mask fields.
> At the When-Button-Pressed-Trigger of the LOV-Button is
> also a Go-Item to the item with the LOV.
>
> Although the variables are given back very fast, the complete
> select is using very much time. Has anybody an idea why, or
> do you know another possibility to solve this problem?
>
> bye Sigrid
>
Received on Sun Nov 02 1997 - 00:00:00 CST
