RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-25 Thread Ross Ferris
@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Sockets are just the pipe you push/pull things through. One of the features they bring to the table is that you get to (yes, I actually said that) design your own protocol for using them reliably or pick one

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Ross Ferris
PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Thursday, 25 October 2007 12:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non- MV dbms Ross, Yes, there is a real-world application to the question, at least one

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Ross Ferris
That would be an [ad] ... but there are some people that may convince us to port Visage.DRS to UV as well -- slight tweak would go a long way to a proving parts of a solution for this scenario (but how did you know we were looking at replication to foreign databases?) Ross Ferris Stamina Software

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Ross Ferris
Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Thursday, 25 October 2007 3:11 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non- MV dbms Glen, snip

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Glen B
Well, I was actually only tasked with making the ATS more real time for our Asia sales office. Since they're entering orders during our night, they always get the short end of the stick, ATS may or may not be right; the batch updates are all timed/tuned for US timezone (and work pretty

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Glen B
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris Sent: Thursday, October 25, 2007 4:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms That would be an [ad

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}

2007-10-25 Thread Janet Bond
Sent: Wednesday, October 24, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD} As promised here is Robert Houben's input to your question Baker!!! :) For anyone who doesn't know me, I was the lead designer

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD)

2007-10-25 Thread Janet Bond
@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms Baker, Given the scenario you have just outlined, and my imaginings of the way that each of the 3 systems SHOULD work, you have no likelihood of deadlock collisions (this could be guaranteed with possibly

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD)

2007-10-25 Thread Baker Hughes
@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD) Hello Baker, We have a customer who is processing tens of thousands of transactions a day. These transactions are centralized on SQL Server so that the Oracle ESB, UniVerse and Web Systems can

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Baker Hughes
Glen, Good thoughts here as always, thanks. Right now, the UV db is not fully replicated to the MSSQL tables, rather the other way around (for the most part). The ISAM WCS tables also update UV. Therefore, at present, the UV db comes closest to being the reference, and it still runs the

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-24 Thread Ross Ferris
2007 2:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms humorIs it just me or does it smell like troll in here all of a sudden/humor Since the question as defined in the sentence below is pretty generic I'll respond in kind. Sockets

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-24 Thread Ross Ferris
by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Wednesday, 24 October 2007 5:05 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Thanks Jerry

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-24 Thread Jeff Schasny
-Directional data transfer btwn MV and non MV dbms humorIs it just me or does it smell like troll in here all of a sudden/humor Since the question as defined in the sentence below is pretty generic I'll respond in kind. Sockets. Inter process communication across disparate platforms

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-24 Thread Baker Hughes
to this science. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Wednesday, October 24, 2007 1:58 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Baker, How live

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-24 Thread Glen Batchelor
-Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Wednesday, October 24, 2007 10:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms Ross, Yes

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-24 Thread Baker Hughes
Glen, snip You always get the good ones, doncha? What does the warehouse control system use as a database? How many different O/S are we looking at here? The first idea that comes to mind is transactional queuing and inspection. A FIFO updating situation will not work, since you have logic that

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}

2007-10-24 Thread Janet Bond
@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Janet, snip/ I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}

2007-10-24 Thread Baker Hughes
@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD} As promised here is Robert Houben's input to your question Baker!!! :) For anyone who doesn't know me, I was the lead designer and developer of the PK Harmony product which we demoed at PC Labs

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Jeff Schasny
humorIs it just me or does it smell like troll in here all of a sudden/humor Since the question as defined in the sentence below is pretty generic I'll respond in kind. Sockets. Inter process communication across disparate platforms and applications is just what they were made for. Low

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Glen Batchelor
Baker, There is a happy medium between CPU overhead and bandwidth usage. If you use compression of some kind, then CPU overhead is going to be higher than an uncompressed stream. Cached disk writes are normally going to be faster than network writes, unless you have a fiber backbone or

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Kevin King
Sockets. If you have a consumer that can accept a socket connection, I believe that'll provide the most efficient throughput. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Jerry Banker
Not likely, Baker Hughes has been in the PICK arena for many moons and is one of the founders of the Texas users group. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] humorIs it just me or does it smell like troll in here all of a sudden/humor --- u2-users mailing

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
Hello Baker, Please email me. I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. Thanks, Janet Bond FusionWare

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Moderator
Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: I can setup a conference call

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Baker Hughes
:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Not likely, Baker Hughes has been in the PICK arena for many moons and is one of the founders of the Texas users group. -Original Message- From: Jeff Schasny [mailto:[EMAIL

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Baker Hughes
Janet, snip/ I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. /snip I'm not in a position to buy anything, really

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Tony G
What is the fastest and lowest cpu overhead method of transferring data between U2/MV databases, and other data sources? Our esteemed colleague and moderator Chuck Barouch has/had a product called Zeus which does/did transfers like this. If he can avoid self-censorship for a moment I would

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread George R Smith
-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] I added it in the Subject should it be somewhere else? Please accept my apologies if I have offended anyone. Janet -Original Message- From: [EMAIL PROTECTED

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
] [mailto:[EMAIL PROTECTED] On Behalf Of George R Smith Sent: Tuesday, October 23, 2007 3:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Gee Janet all you had to do was put This is not an ad, it's a fact of business in your