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:

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] 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

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

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]

[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,

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

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

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

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:

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

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] 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

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] 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