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 >
