Could anyone elaborate on the optimization around Field-marks. A while
back, I started avoiding traditional references to dynamic arrays
(arraycounter) within loops because of the inefficiencies of having to
traverse the array from the first character to the desired attribute
during each
Hi Dan,
I tried some experiments a few years ago and convinced myself that UniData
does not have field hints as supported in UniVerse. This may have changed
but I cannot recall seeing any announcement of this.
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone,
David,
Doubtless you'll have coded this by now, but certainly in the situation you
describe, I'd store just the 'as typed' case version of the list on disk,
then immediately after read, I'd create an in memory 'all uppercase' version
in one go - just UPCASE the whole attribute - and I'd probably
Attribute by Value?? g
Thanks for all the feedback guys n gals!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis
Sent: Tuesday, August 28, 2007 9:22 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [ud] Question on Alpha Sorting
Subject: RE: [U2] [ud] Question on Alpha Sorting...
The issue for me is that I am using the list of employees within a program -
so Virtual Dictionaries are not an option - displaying the data. I
certainly don't want to sort it on use each time, which means I need to do
an insert BY AL -- but in order
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
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
jjuser ud2 wrote:
Somebody try timing it with 10K names and let us know the speed
differences :)
Thanks for volunteering, jjuser!
But seriously, David's email said he had 500 names, 1/20th of your
suggested test sample. My point was that the user probably wouldn't
perceive the difference
I think I would want to encapsulate that logic in one place. Probably
write a function or subr to be called from any pgm or referenced by a
dictionary V-item.
Store the names as typed in the data record, and NOT repeated as
all-caps. Then maybe index the V-item upcased subroutine result. That
Hmm...doing it programmatically...multi-dimensional array?
DAVINCI,LEONARDO
Doe,John
Jesse,Sally
becomes
[1] [2]
DAVINCI,LEONARDO DAVINCI,LEONARDO
Doe,John DOE,JOHN
Raphael,Sally RAPHAEL,SALLY
And then you can sort by
PROTECTED] On Behalf Of jjuser ud2
Sent: Friday, August 24, 2007 2:47 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [ud] Question on Alpha Sorting...
Hmm...doing it programmatically...multi-dimensional array?
DAVINCI,LEONARDO
Doe,John
Jesse,Sally
becomes
[1
Duplicating data in the way you suggest is something I detest! The chance of
mis-typing the name the second time is just too great and then there is all
that extra disk space consumed.
I would prefer to see the names, as typed, stored in one attribute. I would
then use a virtual field (is that
I don't know if it's the same in UD, but in UV I'd just create a extra DICT
item with an MCU in the output convert field, sort on that, but display the
original.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Friday, August 24,
be
very fast and clean, provided you set up the subroutine cleanly.
BobW
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Friday, August 24, 2007 2:15 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [ud] Question on Alpha Sorting
David:
Create a virtual dictionary that upper cases the name. Then you sort by the
UCNAME
but display the normal name. This works for me.
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David
Wolverton
Sent: Friday, August 24, 2007 10:51 AM
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Friday, August 24, 2007 12:51 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [ud] Question on Alpha Sorting...
I have a need to sort people by LastName,FirstName.
The issue is that
I don't know about UD but in UV isn't there a way to turn off the case
sensitivity?
Eric
-Original Message-
From: David Wolverton [mailto:[EMAIL PROTECTED]
Sent: Friday, August 24, 2007 10:51 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [ud] Question on Alpha Sorting...
I have a
, August 24, 2007 5:48 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [ud] Question on Alpha Sorting...
David:
Create a virtual dictionary that upper cases the name. Then
you sort by the UCNAME but display the normal name. This
works for me.
Bill
---
u2-users mailing list
u2
18 matches
Mail list logo
