Re: [U2] Converting from mvBase to Universe

2009-07-22 Thread regalitare
Nailing ports on Windows is a critical issue.? IANA port rules specify well-known and registered ports?ports should NOT be used without registration.? At a minimum, a good OS would leave them alone at least for requests for "dynamic" or "random" port numbers.? However, Windows will grab ANYTHING

Re: [U2] Converting from mvBase to Universe

2009-07-22 Thread Don Robinson
Curt, RE: "nailed" ports. After a lot of hair pulling, I solved this problem on Unix but I don't know if it can be done on Windows and certainly not the same way. On Unix, UV uses a file named unohist but IIRC, on Windows, it uses the PID as the port #. I have a couple of ideas so contact me

Re: [U2] Performance reports on 4 Terabyte files vs Distributed Files

2009-07-22 Thread Ross Ferris
G'day Baker, Just thinking in the sandbox, with no 4Tb databases to be found, BUT (as usual) there may be many aspects to the answer My initial thoughts would be that avoiding running a subroutine to determine part file for EVERY write and non-sequential READ would represent a saving "per transac

Re: [U2] Universe just quits

2009-07-22 Thread Ross Ferris
"Real" Indexing should win - compound key based on wo...@id, index on word and then traverse keys in Basic (or via a select) ... saves having to juggle your own key blocks for larger intersects/more popular words Ross Ferris Stamina Software Visage > Better by Design! >-Original Message-

Re: [U2] FW: Universe just quits

2009-07-22 Thread Hona, David
Harold, Is there any reason you don't use the UV command AUTOLOGOUT to time out idle sessions? It does what you want already from within UV already (and can be setup individually or globally for all UV sessions) and doesn't have the problem of just looking at terminal keyboard input idle time

Re: [U2] FW: Universe just quits

2009-07-22 Thread Gregor Scott
The "who" command's interpretation of idle is solely based on terminal activity: "Is there any input coming from the user?" type of activity. Any unix process that does not have terminal i/o will register as idle in the "who" output. Gregor -Original Message- From: u2-users-boun...@listse

Re: [U2] FW: Universe just quits

2009-07-22 Thread Oaks, Harold
Thanks to all who made suggestions. I'm definitely going to use some of them to improve processing. Good news: Universe is not at fault! So why did the process just end? Because a background process we run logs out processes idle for more than 3 hours. To determine idle time we check the 7

Re: [U2] Performance reports on 4 Terabyte files vs Distributed Files

2009-07-22 Thread Tony G
> From: Baker Hughes > Does anyone have any real life examples of performance > gains from converting your large file to 64 bit files? > > Does anyone have a performance comparison of 64 bit > files vs. distributed files. > > I wonder if a 4 terabyte file responds better/faster > than a distr

Re: [U2] which files have triggers

2009-07-22 Thread Clifton Oliver
November/December 2007. www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx Regards, Clif On Jul 13, 2009, at 12:23 PM, Brian Leach wrote: Hi George I wrote about this in one of the back issues of Spectrum (you can download these from www.intl-spectrum.com). -Original Message-

[U2] Performance reports on 4 Terabyte files vs Distributed Files

2009-07-22 Thread Baker Hughes
Does anyone have any real life examples of performance gains from converting your large file to 64 bit files? Does anyone have a performance comparison of 64 bit files vs. distributed files. I wonder if a 4 terabyte file responds better/faster than a distributed/part file? SELECTs, WRITES, oth

Re: [U2] Universe just quits

2009-07-22 Thread Oaks, Harold
Brian: I really like these suggestions and will give it a go. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, July 22, 2009 8:44 AM To: 'U2 Users List' Subject: Re: [U2]

Re: [U2] Universe just quits

2009-07-22 Thread Brian Leach
Harold You might want to look at splitting out some of those index records, e.g. where you have 10,000 fields in an index for CRIME, split this into CRIME, CRIME-1, CRIME-2 etc. with a maximum number of entries per index. Otherwise you are not going to get efficient storage at those sizes: if they

Re: [U2] Universe just quits

2009-07-22 Thread jpb-u2ug
Sounds like a job for indexing. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 4:54 PM To: U2 Users List Subject: Re: [U2] Universe just quits Barry: Thanks fo

Re: [U2] FW: Universe just quits

2009-07-22 Thread Kevin King
I'm leaning towards the "string too large" theory. I'd definitely try this same thing with sequential I/O. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] FW: Universe just quits

2009-07-22 Thread Marc Harbeson
If this were windows, I would throw "memory leak" out there. I've seen certain SELECT statements in Unidata "leak" - to the point the U2 PID eventually dies a very bad death back to the shell. On windows, we can see this using process explorer. -Original Message- From: u2-users-boun...