Thanks, no network to worry about but I'll bear in mind the slashes.
Regards,
Alastair.
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Saturday, July 17, 2004 1:52 PM
Subject: [RBG7-L] - Re: Slow combo box in form; oops forgot to change the
subject
>
> ----- 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
> > > > > >
> > > > >
> > > >
> > >
> >
>
