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.

message delivery performance

4 posts in QAnywhere Last posting was on 2008-07-24 09:17:07.0Z
Mirco Simoni Posted on 2008-07-17 13:36:38.0Z
From: Mirco Simoni <mirco.simoni@ianywhere.com>
Organization: Sybase
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: message delivery performance
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <487f4ae6$1@forums-1-dub>
Date: 17 Jul 2008 06:36:38 -0700
X-Trace: forums-1-dub 1216301798 10.22.241.152 (17 Jul 2008 06:36:38 -0700)
X-Original-Trace: 17 Jul 2008 06:36:38 -0700, vip152.sybase.com
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:269
Article PK: 10492

Hi,

SA 9.0.2.3575
QAnywhere tutorial example.
1 VMWare and 1 PC


The environment has been set up following the QAnywhere tutorial. When
we send messages between the two machines, the delivery delay is between
3 and 20 seconds.
If we add -policy automatic, messages are delivered to the server
immediately but the server does not redirect them back to the other
client immediately.
The workaround is to set ianywhere.qa.server.autoRulesEvaluationPeriod=1000

But this means that the server checks every second the queue. We think
it is too heavy. IS there any way to get the same result but event-based
? For example, we use the system stored procedure sa_send_udp and wrote
a trigger for ml_qa_delivery table that sends a message to the client.
This seems to work if the consolidated database is SQL Anywhere. In
production, ASE will be used. Is there any way to use the same
workaround in ASE or is there any other workaround ?

Thank you,
Mirco


Mirco Simoni Posted on 2008-07-18 13:58:02.0Z
From: Mirco Simoni <mirco.simoni@ianywhere.com>
Organization: Sybase
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: message delivery performance
References: <487f4ae6$1@forums-1-dub>
In-Reply-To: <487f4ae6$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4880a16a$1@forums-1-dub>
Date: 18 Jul 2008 06:58:02 -0700
X-Trace: forums-1-dub 1216389482 10.22.241.152 (18 Jul 2008 06:58:02 -0700)
X-Original-Trace: 18 Jul 2008 06:58:02 -0700, vip152.sybase.com
Lines: 2
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:270
Article PK: 10491

I think we can use the ASE system procedure called sp_sendmsg.


Andy Quick Posted on 2008-07-18 15:45:22.0Z
From: "Andy Quick" <andy.quick@sybase.com>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
References: <487f4ae6$1@forums-1-dub>
Subject: Re: message delivery performance
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4880ba92$1@forums-1-dub>
Date: 18 Jul 2008 08:45:22 -0700
X-Trace: forums-1-dub 1216395922 10.22.241.152 (18 Jul 2008 08:45:22 -0700)
X-Original-Trace: 18 Jul 2008 08:45:22 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:272
Article PK: 10493

You should NOT have to send UDP messages with system procedures and triggers
with QAnywhere. That is taken care of by the QAnywhere notifier that is
running in the MobiLink server.

Are your QAnywhere clients always online in your test scenario? There was a
shortcoming in 9.0.2 where push notifications were not retried if the first
attempt to notify the client failed because it was not connected to the
network. There is a workaround for that that I can give you, if you wish.

If your clients are always connected to the network, the push notification
should be sent immediately by the server to the destination client when a
message is received for that client. I would like to see a MobiLink server
log (using -v+ verbosity) and QAnywhere client logs (also with -v+) covering
a time when a message is sent by one client to another and there is a long
delay. Also, the message ID of the delayed message would be helpful.

Thanks,

Andy Quick
iAnywhere Solutions Engineering

"Mirco Simoni" <mirco.simoni@ianywhere.com> wrote in message
news:487f4ae6$1@forums-1-dub...
> Hi,
>
> SA 9.0.2.3575
> QAnywhere tutorial example.
> 1 VMWare and 1 PC
>
>
> The environment has been set up following the QAnywhere tutorial. When we
> send messages between the two machines, the delivery delay is between 3
> and 20 seconds.
> If we add -policy automatic, messages are delivered to the server
> immediately but the server does not redirect them back to the other client
> immediately.
> The workaround is to set
> ianywhere.qa.server.autoRulesEvaluationPeriod=1000
>
> But this means that the server checks every second the queue. We think it
> is too heavy. IS there any way to get the same result but event-based ?
> For example, we use the system stored procedure sa_send_udp and wrote a
> trigger for ml_qa_delivery table that sends a message to the client. This
> seems to work if the consolidated database is SQL Anywhere. In production,
> ASE will be used. Is there any way to use the same workaround in ASE or is
> there any other workaround ?
>
> Thank you,
> Mirco


Bas Biesheuvel (bbiesheuvel Posted on 2008-07-24 09:17:07.0Z
Sender: 74b3.48884252.1804289383@sybase.com
From: Bas Biesheuvel (bbiesheuvel@anwb.nl)
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: message delivery performance
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48884893.7624.1681692777@sybase.com>
References: <4880ba92$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Jul 2008 02:17:07 -0700
X-Trace: forums-1-dub 1216891027 10.22.241.41 (24 Jul 2008 02:17:07 -0700)
X-Original-Trace: 24 Jul 2008 02:17:07 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:273
Article PK: 10494

Hello Andy,

I am the original creator of the sybase case connected to
this problem, we are having the QAnywhere difficulties. Ive
had contact with Mirco, but while browsing the sybase forum,
I noticed that he is relaying my questions to you. Would it
be possible to communicate with you directly? No offence to
Mirco, but we would like to solve our issue as soon as
possible and if you have more in-depth experience with this
sort of problems, you might be able to help us.

Please let me know.
Kind regards,
Bas Biesheuvel
ANWB (Netherlands)