[U2] Pick Pocket Guide
My briefcase was stolen and in it was one of these small JES Pick Pocket Guides. While I have access to all of the docs I need via the internet, I still refer to this for some efforts. With no distraction, could anyone donate or offer to sell me one of these. I don't recall the vintage of the one I had but it wasn't Microdata (or another flavor) specific. Probably good old solid R90. Thanks in advance, Mark Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Index slowing performance?
I know next to nothing about UniData, but perhaps the extra step of opening and reading the index takes longer than scanning the entire base file. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Sunday, March 21, 2010 1:03 PM To: U2 Users List Subject: [U2] Index slowing performance? Unidata 7.1.8 on Solaris 9 I've got a subroutine which performs a query, parses some data and then returns a result to the calling process. The routine was consistently taking 20 milliseconds - not too bad but certainly not great - I have other routines that usually take under 10 milliseconds. After re-reading my code, I realize the query the routine was executing wasn't indexed so I created an index on the field used in the query and made no changes to the subroutine at all. Now when I execute my code it consistently takes 33-35 milliseconds. So I'm trying to explain why creating an index would slow performance instead of increase it. The file in question is small - only 239 records to query against - so I understand why it doesn't benefit from an index as a file with 1,000,000 records might. But I'm not clear why performance would degrade. Any insight appreciated. For those who like details: File.. H08.CR.EVAL.QUES Alternate key length.. 20 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 2 (2 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr XCEQ.TYPE D TxtYes No Yes Yes S 3 XCEQ.ORDERD NumYes No Yes Yes S 4 and the query is: SELECT H08.CR.EVAL.QUES WITH XCEQ.TYPE EQ "foo" BY XCEQ.ORDER Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "Life is a giant weenie roast and I'm the biggest weenie." Rose, The Golden Girls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using JDBC on Unidata 7.1 on HPUX
Does JSON really equate directly to a java object ?? It certainly equates
directly to a javascript object (a very different beast indeed), it being
Java Script Object Notation. Do you not need a json parser for Java, as you
would for .net etc.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
Sent: 21 March 2010 00:32
To: 'U2 Users List'
Subject: Re: [U2] Using JDBC on Unidata 7.1 on HPUX
Hi Bruce:
If you don't want to flatten or normalize you U2 files you can use JSON
format. It is an
open standard for languages like Java, JavaScript, jQuery, Ruby, Python,
PowerShell, C#,
and PHP to name just a few.
When we looking at transferring data between sites, programs and the WEB,
JSON
was much easier to understand in Java because it maps into Java Objects
directly.
Here is a sample of a file read using JSON:
[{"IdCode":"32828","TypeCode":"14","Length":"28'","Cubes":"720","MfgDate":"0
3/01/2009",
"VehicleNo":"","Year":"2005","LicenseNo":"","MfgCode":"AJ","AssignedTerminal
":"0",
"Permits":["DIA"],["FCA"]],"XLr8Company":"01","XLr8NewItem":"0","XLr8CheckSu
m":"62138"}]
If you equated this to a variable oData, the IdCode field would be
oData.IdCode. The
multivalve field Permits would be referenced by oData.Permits[0] and
oData.Permits[1].
Then your data transmissions would match an industry standard.
Regards,
Doug
www.u2logic.com
"U2WebLink(tm) for Java"
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Index slowing performance?
Unidata 7.1.8 on Solaris 9 I've got a subroutine which performs a query, parses some data and then returns a result to the calling process. The routine was consistently taking 20 milliseconds - not too bad but certainly not great - I have other routines that usually take under 10 milliseconds. After re-reading my code, I realize the query the routine was executing wasn't indexed so I created an index on the field used in the query and made no changes to the subroutine at all. Now when I execute my code it consistently takes 33-35 milliseconds. So I'm trying to explain why creating an index would slow performance instead of increase it. The file in question is small - only 239 records to query against - so I understand why it doesn't benefit from an index as a file with 1,000,000 records might. But I'm not clear why performance would degrade. Any insight appreciated. For those who like details: File.. H08.CR.EVAL.QUES Alternate key length.. 20 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 2 (2 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr XCEQ.TYPE D TxtYes No Yes Yes S 3 XCEQ.ORDERD NumYes No Yes Yes S 4 and the query is: SELECT H08.CR.EVAL.QUES WITH XCEQ.TYPE EQ "foo" BY XCEQ.ORDER Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "Life is a giant weenie roast and I'm the biggest weenie." Rose, The Golden Girls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Terminal Emulator and Telnet Client for a MacBook Pro
Yes. Parallels only runs on the Intel Macs. For the PowerPC Macs the option was VirtualPC. (Before Microsoft acquired it. Don't know if they kept it available for Mac after that.) It was slow, but for the most part worked. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Mar 20, 2010, at 8:42 AM, Anthony W. Youngman wrote: > In message <005901cac75f$0852b8e0$18f82a...@com>, Kevin Gusler > writes >> Has anyone tried running SBClient 5.3.4 - 5.4.4 in Parallels on a Mac? Are >> there any issues? We are running (windows) SB+ 5.3.4 and Universe 10.3.3 and >> have a few users that wish to use Macs for their client pc's. Just wondered >> if there was a downside. > > How new are the Macs? Does parallels only run on the new Intel Macs? (Sorry, > I don't use a Mac, don't know when the switchover was. But there are probably > still a fair few Power Macs still in general circulation.) >> >> Thanks in advance. > > Cheers, > Wol > -- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
