I'm sure we've been here before and not all that long ago, but the questions begs to be asked again:
how? Regards, Alastair. ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, July 16, 2004 9:52 PM Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the subject > Larry, > > At the spring conference I demonstrated a Select with output directed to a > Text File, the Loaded the TextFile output into the Variable User Defined Listbox > (ComboBox). It takes only a couple of seconds to load 70,000 rows. The Wider > the Text Data the Slower the Load, but for most lookup operations, this is > probably the Fastest.. > > > ----- Original Message ----- > From: "Lawrence Lustig" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, July 16, 2004 3:25 PM > Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the > subject > > > > > Thanks, however I tried the temp table thing already > > > and that takes too > > > long also. Its creating a temp table then inserting > > > non-duplicate rows > > > from a table that has 14,000 records in it and that > > > was too painfull > > > too > > > > If you are trying to dedup a 14K record table > > everytime you load the combo box, you may have a > > legitimately slow operation on your hands. Certainly, > > the combo box is unlikely to load _faster_ than the > > time it would take to select the records into a temp > > table (the problem is the combo boxes are often much > > _slower_ than a regular SELECT). > > > > But here's something you can try. Create a compound > > index on your table including all the columns that > > appear in the combo box and that have to be unique. > > If you do that, R:Base _should_ perform and index-only > > retrieval for the combo box, and that will have > > performed the deduplication for you: > > > > CREATE UNIQUE INDEX ON YourTable(YourCol1, YourCol2, > > YourCol3) > > > > -- > > Larry > > >
