Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

shared memory drivers for Open-Client

8 posts in Product Futures Discussion Last posting was on 2002-02-13 20:39:29.0Z
J Posted on 2002-01-24 13:11:00.0Z
From: J <rs2@rocketmail.com>
Date: Thu, 24 Jan 2002 08:11:00 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: shared memory drivers for Open-Client
Message-ID: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums>
Lines: 39
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:880
Article PK: 94409

re shared memory drivers for Open-Client

Apologies, this is my second posting on this topic, but to my surprise
there was NOT a single reply to my previous posting. If there none this
time, I'll keep my mouth shut until I have my own independent comparitive
figures to publish on this one. (I'm restiricted in using what I've
wittnessed)

A single change in architecture for local clients, (where O/client is on
the same host as the server), could make the world of a difference in
performance terms. The client then does not go through the network layers
(if local), and communicates directly via shared memory. This will only
benefit clients on the same host as the server, but judging on the
performance it buys comparable products, it would be especially benificial
for back-end processes / batches.

This is definitely more than a nice to have, and with an application server
right next to ASE it would make it competitive with MSSQL, ( which, in this
configuration, ASE currently is not ! )

This feature has the promise of a huge performance benefit one could now
get by having you app server on the same E10K (or other host-server) for
example. I thought it would a major engineering challenge, but I'm told it
may be less work than I thought. I also understand that IQ has this
already.

We're talking order of magnitude for a single user connection, even for a
relatively high number of user connections! It will benefit both
response-time and throughput. (less work by ASE, and the host, and the
client)

ANY FEEDBACK on this one. I'm told it is NOT currently a priority, which
absolutely amazes me.
Has ANYONE at Sybase bothered to think what a difference this could make
for replication server- , EP- , CIS- , SDS- and ASE-performance ?
Where is the EP strategy, which relies on a large number of different
components to act together, on this one?

The lack of interest in this feature simply does not make sense to me.

J


Carel Cornelius Posted on 2002-02-13 20:39:29.0Z
From: "Carel Cornelius" <carel@sybase.co.za>
References: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums>
Subject: Re: shared memory drivers for Open-Client
Date: Wed, 13 Feb 2002 22:39:29 +0200
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <BUrAW8MtBHA.52@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 158.76.48.22
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:769
Article PK: 94298

J,

If you don't mind trying this (instead of waiting for shared memory
drivers), create more than one listener on ASE. This is done by adding more
than one "master" entry in the interfaces file, one on the actual server's
IP address, and one on localhost (127.0.0.1). Ensure that the "localhost"
entry is the first in the interfaces file. Remember that you also need a
localhost "query" entry, also at the top.

I believe that connections to localhost is not routed through all the
network interface layers as a normal IP address would be, and should thus be
faster.

Compare results of large query result sets or BCPs etc. between the two,
and I'm sure you should get better results. Your App should also benefit by
connecting to "localhost" instead of the actual IP.

This may be out of place in this thread, but is worth a try.

Regards

Carel


girish Posted on 2002-02-01 21:59:40.0Z
From: girish@sybase.com
Date: Fri, 1 Feb 2002 16:59:40 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: shared memory drivers for Open-Client
Message-ID: <FCE1FC74FDD079FA0078D1C385256B53.006AF77285256B4C@webforums>
References: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums>
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:812
Article PK: 94343

Check out the ASE-EJB support in ASE-12.5 and let me know if you expect
something similar to this.

-girish


Bret Halford Posted on 2002-02-01 23:41:06.0Z
Message-ID: <3C5B2792.F6A75779@sybase.com>
Date: Fri, 01 Feb 2002 16:41:06 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: shared memory drivers for Open-Client
References: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums> <FCE1FC74FDD079FA0078D1C385256B53.006AF77285256B4C@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 7
NNTP-Posting-Host: 157.133.80.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:810
Article PK: 94339

Here is the documentation on it:

http://manuals.sybase.com:80/onlinebooks/group-as/asg1250e/ejbserv

-bret

girish@sybase.com wrote:

> Check out the ASE-EJB support in ASE-12.5 and let me know if you expect
> something similar to this.
>
> -girish


j Posted on 2002-02-04 17:07:34.0Z
From: J
Date: Mon, 4 Feb 2002 12:07:34 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: shared memory drivers for Open-Client
Message-ID: <18B1E0DBFD8A972F005E139185256B56.000409F685256B54@webforums>
References: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums> <FCE1FC74FDD079FA0078D1C385256B53.006AF77285256B4C@webforums> <3C5B2792.F6A75779@sybase.com>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:809
Article PK: 94337

Thanks for that guys,

Quite useful...
This is a feature which will benefit back-end type tasks hugely,
and the bank / Telco's I've worked with will most definitely not use JAVA
to perform those function.

Thanks for the response anyway.
Anyone else ?


Pablo Sanchez Posted on 2002-02-04 17:14:37.0Z
From: "Pablo Sanchez" <pablo@dev.null>
References: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums> <FCE1FC74FDD079FA0078D1C385256B53.006AF77285256B4C@webforums> <3C5B2792.F6A75779@sybase.com> <18B1E0DBFD8A972F005E139185256B56.000409F685256B54@webforums>
Subject: Re: shared memory drivers for Open-Client
Date: Mon, 4 Feb 2002 10:14:37 -0700
Lines: 27
Organization: High-Performance Database Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <qNVn8AarBHA.141@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 207.225.105.222
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:808
Article PK: 94336


<J> wrote in message
news:18B1E0DBFD8A972F005E139185256B56.000409F685256B54@webforums...
> Thanks for that guys,
>
> Quite useful...
> This is a feature which will benefit back-end type tasks hugely,
> and the bank / Telco's I've worked with will most definitely not use
JAVA
> to perform those function.

I agree, I prefer a cleaner implementation as well.

> Thanks for the response anyway.
> Anyone else ?

Nope, I was waiting on the sidelines for something... too bad,
Informix and Oracle offer it... I don't think it's a difficult thing
to do but with limited resources at Sybase, I understand if it's not
high on the list.
--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Independent Contractor, available for short-term and long-term
contracts


j Posted on 2002-02-06 14:32:49.0Z
From: J
Date: Wed, 6 Feb 2002 09:32:49 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: shared memory drivers for Open-Client
Message-ID: <7BE06D500DC44A55004FE89C85256B58.006442E685256B56@webforums>
References: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums> <FCE1FC74FDD079FA0078D1C385256B53.006AF77285256B4C@webforums> <3C5B2792.F6A75779@sybase.com> <18B1E0DBFD8A972F005E139185256B56.000409F685256B54@webforums> <qNVn8AarBHA.141@forums.sybase.com>
Lines: 36
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:800
Article PK: 94327

J

This is a conversation worth having, to hammer some sense into the
"prioritisers".
Humiliating... Every other db seems to have it.

I'm busy compiling comparable figures, and feel like shoving it up a few
big noses.
Once the "important" accounta know what they are missing they will start
shouting too.

><J> wrote in message
>news:18B1E0DBFD8A972F005E139185256B56.000409F685256B54@webforums...
>> Thanks for that guys,
>>
>> Quite useful...
>> This is a feature which will benefit back-end type tasks hugely,
>> and the bank / Telco's I've worked with will most definitely not use
>> JAVA to perform those functions.
>>
>I agree, I prefer a cleaner implementation as well.

> Thanks for the response anyway.
> Anyone else ?

Nope, I was waiting on the sidelines for something... too bad,
Informix and Oracle offer it... I don't think it's a difficult thing
to do but with limited resources at Sybase, I understand if it's not
high on the list.
--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Independent Contractor, available for short-term and long-term
contracts


Pablo Sanchez Posted on 2002-02-06 16:15:04.0Z
From: "Pablo Sanchez" <pablo@dev.null>
References: <5A2698F68C1670A900486AF185256B4B.00486B1785256B4B@webforums> <FCE1FC74FDD079FA0078D1C385256B53.006AF77285256B4C@webforums> <3C5B2792.F6A75779@sybase.com> <18B1E0DBFD8A972F005E139185256B56.000409F685256B54@webforums> <qNVn8AarBHA.141@forums.sybase.com> <7BE06D500DC44A55004FE89C85256B58.006442E685256B56@webforums>
Subject: Re: shared memory drivers for Open-Client
Date: Wed, 6 Feb 2002 09:15:04 -0700
Lines: 25
Organization: High-Performance Database Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <DVjbCpyrBHA.141@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 207.225.105.222
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:799
Article PK: 94328


<J> wrote in message
news:7BE06D500DC44A55004FE89C85256B58.006442E685256B56@webforums...
> J
>
> This is a conversation worth having, to hammer some sense into the
> "prioritisers".
> Humiliating... Every other db seems to have it.
>
> I'm busy compiling comparable figures, and feel like shoving it up a
few
> big noses.
> Once the "important" accounta know what they are missing they will
start
> shouting too.

grassroot efforts are always a good thing. You might contact your
Sybase sales critter and apply pressure through her/him.
--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Independent Contractor, available for short-term and long-term
contracts