> > Ehh.. Not so good when your table has the possibility of having 120k
> > records.

> 120K records in a listbox? Sheesh!

To clarify, the actual control being used is a DBgrid (Straight Delphi
TDBGrid), with two columns in the grid (3 columns are being selected from
the database, the two being displayed, and the PK of the record).

> Table-oriented GUIs applications are slow on client/server databases, even

quite small ones.

Actually, we haven't had many issues up until now.
However, no one around here could think of a more intuitive (From a dumb
user's point of view, which is what we have to deal with) way of displaying
result sets from a query, other than a grid type of control (Given that
multiple columns need to be shown). Grid's are more of a dataset type of
gui control, rather than a table-type. If you're talking about Table type
dataset components (TTable, etc), no those are not an issue. I nuked them
out a long time ago, and my life has been much happier. :) I'm strictly
using TIBDataset's (IBX's Query+UpdateSQL component).

> By using indexed proxy search columns, populated by triggers. You might

be interested in researching out metaphone and soundex if

> strict alphabetical order is not essential.

In this case, as they're searching for clients, and they're used to getting
exactly the matches (From previous versions of our software), it pretty much
is strictly alphabetical. :(
It would have been fun to do the research, but right now, not enough time
(How many times have people said that before? :)).
Ah well, sounds like it's time to write some triggers.

- Jason