I remember that now Mike. I will have to look at my CD again.
James
On Jul 16, 2004, at 4:52 PM, MikeB wrote:
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
James Hageman, CITA I University of Delaware Archives 002 Pearson Hall Newark ,DE 19702 302-831-3127 [EMAIL PROTECTED]
