----- Original Message -----
From: "Alastair Burr" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Saturday, July 17, 2004 2:19 AM
Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the
subject
> Many thanks - I'm downloading it now to have a play with.
One caveat. If your db is on the network, the same architecture applies. If
you are going to create temp files of any kind, you should create them on your
local drive, so you might try (I haven't) putting the test file in your local
temp directory and then changing the test form "On After Start" EEP to read like
this:
*(The reason for the If/Else is because of the difference between win9x and Nt
and up, one adds the trailing backslash and the other doesn't.)
SET VAR vinifile = (ENVVAL('TEMP'))
IF (SGET(.vinifile,1,(SLEN(.vinifile)))) <> '\' THEN
SET VAR vinifile = (.vinifile + '\BigFile.LFF')
ELSE
SET VAR vinifile = (.vinifile + 'BigFile.LFF')
ENDIF
IF ((CHKFILE(.vinifile)) = 1) THEN
PROPERTY lbini load_from_file &vinifile
else
Pause 2 using 'Couldn''t Find File'
Return
endif
> 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
> > > > >
> > > >
> > >
> >
>
