Many thanks - I'm downloading it now to have a play with. Regards, Alastair.
----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, July 17, 2004 2:09 AM Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the subject > www.byerley.net/LoadBigFile.zip > > An RB7 form with Listbox and simple code to load the contents of the file called > BigFile.LFF. Put the BigFile.LFF file in the same directory of the DB that you > import the RB7 Form into. > > The Form requires table Dummy. Just run the form and it loads 41890 cities and > zipcodes in just a couple of seconds. The file was created using output to > file, and some Formatting Functions to create the alignment of the text in the > listbox as shown. The Select to create the file was only a couple of seconds, > so the whole thing was under 5 seconds.. > > The Conference CD has examples of multiple columns of data aligned correctly and > also demonstrates using One form to perform multiple tasks by getting its > startup information from an initialization file. > > ----- Original Message ----- > From: "Alastair Burr" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, July 16, 2004 5:52 PM > Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the > subject > > > > 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 > > > > > > > > > >
