Somebody try timing it with 10K names and let us know the speed differences :)

On 8/27/07, Rex Gozar <[EMAIL PROTECTED]> wrote:
> David,
>
> In terms of "which is better" for sorting inside a program, working with
> in-memory strings should be faster than writing to disk.  And with less
> than a thousand names, it probably won't be noticeably faster whether
> you UPCASE() each time you insert, or maintain a separate UPCASE'd variable.
>
> I'm guessing that you'll also have an ID value associated with the name;
> that means LOCATE'ing on values.  Field-marks in Universe (and I'm
> guessing in Unidata too) are optimized for traversing back and forth.
> Value-marks aren't, so when you INSERT a value after a LOCATE, the
> run-machine has to start at character one and find each value until it
> hits the specific value mark count.  Ideally, you should be using
> field-mark delimited lists, but practically I don't think it would be
> noticeable.
>
> rex
> -------
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to