Re: [U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Tony Gravagno
Side comment: I understand what Wil is saying and I think he has a valid point. But I believe the value of the point is now insignificant. The tiny bit of contention that Will brings up here is about just how much disk access is done by any given process. Eliminate disk reads and the process speed

Re: [U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Wjhonson
To be more clear, although there may be some slight differences, if all the pieces are all in memory for the duration of the select or selects, those differences in timing will be so tiny, that it won't make any difference in real life. The most critical improvement in speed, is simply adding

Re: [U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Wjhonson
I didn't miss it. The point of the request, was from the beginning to the ending. Of course the first *portion* will be quick and use few disk reads. I was discussing the full example. -Original Message- From: Wols Lists To: u2-users Sent: Fri, Mar 8, 2013 2:43 pm Subject: Re: [

Re: [U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Wols Lists
On 08/03/13 22:07, Wjhonson wrote: > If your file is small enough, and your system idle enough that the file > remains *in memory* for all possible scenarios below, than you may not notice > speed issues. > > However, the monster in the kitchen, is the number of DISK READS you are > doing. If

Re: [U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Rutherford, Marc
Jeffery, I would say #1 does the trick. Any U2 TCL query evaluates from left to right. When one term eliminates the record the query on that record stops, and the query continues to the next record. So #1 is exactly your most effective, leaving the complex i-descriptor to evaluate only the

Re: [U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Wjhonson
If your file is small enough, and your system idle enough that the file remains *in memory* for all possible scenarios below, than you may not notice speed issues. However, the monster in the kitchen, is the number of DISK READS you are doing. If your prior reads get cycled out before they are

Re: [U2] Unidata WHEN/ASSOCIATED

2013-03-08 Thread Wjhonson
You can already return record ids with a SELECT that have some multi-value which matches, just by using the WITH command. -Original Message- From: Jeffrey Butera To: u2-users Sent: Fri, Mar 8, 2013 12:49 pm Subject: Re: [U2] Unidata WHEN/ASSOCIATED On 03/08/2013 03:47 PM, Da

Re: [U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Wols Lists
On 08/03/13 21:03, Jeffrey Butera wrote: > While I'm on a roll... I often look at how to make queries run faster. > In short, we index all the commonly used data fields we can and (of > course) it makes world of difference. However, I have some questions > about optimal ways to query data using

[U2] Unidata index and short-circuit evaluation

2013-03-08 Thread Jeffrey Butera
While I'm on a roll... I often look at how to make queries run faster. In short, we index all the commonly used data fields we can and (of course) it makes world of difference. However, I have some questions about optimal ways to query data using a mix of indexed data, non-indexed data and i

Re: [U2] Unidata WHEN/ASSOCIATED

2013-03-08 Thread Jeffrey Butera
On 03/08/2013 03:47 PM, David A. Green wrote: Jeff, This could be a good enhancement. How do you want it to work? 1. SELECT just the IDs or whatever the SAVING clause points to. Or 2. SELECT the IDs,MV pointers that match But until it goes through I'm sure someone has already written the code

Re: [U2] Unidata WHEN/ASSOCIATED

2013-03-08 Thread David A. Green
Jeff, This could be a good enhancement. How do you want it to work? 1. SELECT just the IDs or whatever the SAVING clause points to. Or 2. SELECT the IDs,MV pointers that match But until it goes through I'm sure someone has already written the code to do it in a UniBasic program. David A. Green

[U2] Unidata WHEN/ASSOCIATED

2013-03-08 Thread Jeffrey Butera
Stupid question: is there a good reason why WHEN/ASSOCIATED can only be used with LIST and not SELECT? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecoll

Re: [U2] bdt in juno

2013-03-08 Thread Aaron Titus
I don't remember off the top of my head but its contained in the slides for the webinar. They are freely downloadable in PDF form. *Aaron Titus* Senior Software Engineer F.W. Davison & Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Mar 8, 2013 at 12:12 PM, Symeon Breen wrote: > URL

[U2] [Announcement]Spectrum Conference Discount Deadline TODAY

2013-03-08 Thread Intl Spectrum
== International Spectrum Conference and Exhibition Phoenix 2013 - April 15th-18th == Today is the last day to get the (March 8th) discount. Don't miss out on saving y

Re: [U2] bdt in juno

2013-03-08 Thread Symeon Breen
Found it at http://updates.rocketsoftware.com/u2/ -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 08 March 2013 17:13 To: 'U2 Users List' Subject: RE: [U2] bdt in juno URL please of the update site ?? -Original Message- From: u2-users-boun...@listserver

Re: [U2] bdt in juno

2013-03-08 Thread Doug Averch
http://updates.rocketsoftware.com/u2/ On Fri, Mar 8, 2013 at 10:12 AM, Symeon Breen wrote: > URL please of the update site ?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] bdt in juno

2013-03-08 Thread Symeon Breen
URL please of the update site ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: 08 March 2013 16:47 To: U2 Users List Subject: Re: [U2] bdt in juno I did this yesterday using the eclipse software u

Re: [U2] bdt in juno

2013-03-08 Thread Aaron Titus
I did this yesterday using the eclipse software update installation site that rocket has. There is a webinar on rocket's web site that explains exactly how to to it. *Aaron Titus* Senior Software Engineer F.W. Davison & Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Mar 8, 2013 at 7:

Re: [U2] bdt in juno

2013-03-08 Thread Symeon Breen
That's good to hear Doug - what url did you use for the plugin, or did you do it manually ? If manually did you coppy everything in the plugins directory or just certain pieces ? Thnaks Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@lists