Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dave Laansma
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Monday, February 11, 2013 9:02 AM To: U2 Users List Subject: Re: [U2] : Evaluating DCOUNT David, You're correct that the remove is faster, and it is because it maintains an internal pointer to the next item, as opposed

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Tom Whitmore
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Tuesday, February 12, 2013 1:21 PM To: 'U2 Users List' Subject: Re: [U2] : Evaluating DCOUNT Hey Allen, The REMOVE so fast How fast is it?! Match Game throwback that I suspect the time it takes

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dave Laansma
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Tuesday, February 12, 2013 1:43 PM To: U2 Users List Subject: Re: [U2] : Evaluating DCOUNT Hi, When you have more than about 1,000 values in a field, changing the value mark to a field mark, is significant. I had

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Wjhonson
: Tue, Feb 12, 2013 10:43 am Subject: Re: [U2] : Evaluating DCOUNT Hi, When you have more than about 1,000 values in a field, changing the value mark to a field mark, is significant. I had a program that needed to work through two fields with over 20,000 values. Initially, I left the strings

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Wols Lists
: [U2] : Evaluating DCOUNT Hi, When you have more than about 1,000 values in a field, changing the value mark to a field mark, is significant. I had a program that needed to work through two fields with over 20,000 values. Initially, I left the strings as value delimited, used a for/next

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Mecki Foerthmann
...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Tuesday, February 12, 2013 1:21 PM To: 'U2 Users List' Subject: Re: [U2] : Evaluating DCOUNT Hey Allen, The REMOVE so fastHow fast is it?! Match Game throwback that I suspect the time it takes to interpret the difference between a VM and AM

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Wjhonson
: [U2] : Evaluating DCOUNT On 12/02/13 19:04, Wjhonson wrote: Correct me if I'm misunderstanding you Tom, but you said that field marks are indexes so the first scan resolves where each field begins. That is not correct, at least not literally. Count or Raising or Lowering or Scanning

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Tom Whitmore
-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 12, 2013 3:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] : Evaluating DCOUNT Yes it keeps track of the position of the current field (only), not each field. It's not indexed. Its just a one value pointer

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dan Fitzgerald
Subject: Re: [U2] : Evaluating DCOUNT My understanding is that UniVerse keeps track of the location of each attribute the first time is hits an attribute. U2 support will need to provide a definitive answer. I do know that we have found field marks are measurably faster than value marks

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Wjhonson
It keeps track of the location of the last attribute touched. Not each one. -Original Message- From: Tom Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 12, 2013 1:46 pm Subject: Re: [U2] : Evaluating DCOUNT My understanding

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Wjhonson
Archive http://u2-universe-unidata.1073795.n5.nabble.com/ -Original Message- From: Dan Fitzgerald dangf...@hotmail.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Feb 12, 2013 2:07 pm Subject: Re: [U2] : Evaluating DCOUNT I don't know if the old list archives

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Jeffrey Butera
On 02/11/2013 12:14 AM, Peter Cheney wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes =

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Laansma
To: u2-users@listserver.u2ug.org Subject: Re: [U2] : Evaluating DCOUNT On 02/11/2013 12:14 AM, Peter Cheney wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Jeffrey Butera
] On Behalf Of Jeffrey Butera Sent: Monday, February 11, 2013 7:55 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] : Evaluating DCOUNT On 02/11/2013 12:14 AM, Peter Cheney wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Laansma
Butera Sent: Monday, February 11, 2013 8:35 AM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] : Evaluating DCOUNT David is correct (re: performance). Most of our app here have MV lists under 40-50 so it's not a huge issue. If you app has hundreds+ this could be a big challenge. Jeff

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Israel, John R.
Of Jeffrey Butera Sent: Monday, February 11, 2013 8:35 AM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] : Evaluating DCOUNT David is correct (re: performance). Most of our app here have MV lists under 40-50 so it's not a huge issue. If you app has hundreds+ this could be a big challenge. Jeff

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Allen Egerton
: Monday, February 11, 2013 7:55 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] : Evaluating DCOUNT On 02/11/2013 12:14 AM, Peter Cheney wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Dave Davis
Sent: Monday, February 11, 2013 12:15 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] : Evaluating DCOUNT Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Tony Gravagno
I have multiple views on this category of inquiry: I think only an engineer at RocketSoftware can answer this question. Some people actually use the non-optimization to their benefit. They count on the fact that the expression will be evaluated on every iteration, whether it's a DCount, Field,

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Wjhonson
Yes it's assigned to a buffer and then decremented until it matches. The assign only takes place once. -Original Message- From: Ross Ferris ro...@stamina.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Sun, Feb 10, 2013 11:05 pm Subject: Re: [U2] : Evaluating DCOUNT

Re: [U2] : Evaluating DCOUNT

2013-02-11 Thread Wjhonson
You can also use a SELECT/SELECTV and then use a READNEXT in the loop -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Feb 11, 2013 5:30 am Subject: Re: [U2] : Evaluating DCOUNT I would HOPE

[U2] : Evaluating DCOUNT

2013-02-10 Thread Peter Cheney
Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes = dcount(array,@fm) for i = 1 to totalattributes

Re: [U2] : Evaluating DCOUNT

2013-02-10 Thread Rick Nuckolls
The only way that this could not be an issue is if the compiler and the smarts and determined ahead of time that the array was invariant. My bet is solidly on plan b. -Rick On Feb 10, 2013, at 9:14 PM, Peter Cheney peter.che...@firstmac.com.au wrote: Hi Everyone, Does a DCOUNT get

Re: [U2] : Evaluating DCOUNT

2013-02-10 Thread Ross Ferris
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Monday, February 11, 2013 4:53 PM To: U2 Users List Subject: Re: [U2] : Evaluating DCOUNT The only way that this could not be an issue is if the compiler and the smarts and determined ahead of time that the array was invariant