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.

AIS speed

6 posts in Internet Server Last posting was on 2009-07-04 06:28:36.0Z
Randall Carpenter Posted on 2009-04-08 00:31:54.0Z
From: "Randall Carpenter" <randall@advancegroup.us>
Newsgroups: Advantage.Internet_Server
Subject: AIS speed
Date: Tue, 7 Apr 2009 20:31:54 -0400
Lines: 19
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: 65.190.51.149
Message-ID: <49dbf05d@solutions.advantagedatabase.com>
X-Trace: 7 Apr 2009 18:31:25 -0700, 65.190.51.149
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!65.190.51.149
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:775
Article PK: 1121026

I finally got AIS working. My app (running locally) can login to my
database 72 miles away. That's pretty cool. However, once logged in, the
response time is slow - probably too slow to use in a production
environment.

I am going to upgrade my internet access speed on both ends. The server is
accessing the 'net at 6mbs while the computer on which the app is installed
is accessing the 'net at 3 mbs. I am planning to upgrade both ends to
10mbs.

I was also wondering about my table types. Currently I am using DBF tables.
Would I get better throughput if I converted them to ADT tables? From what
I gather from studying and reading about ADS, it sounds as if ADT tables are
inherently more efficient than DBF tables. Would ADT tables possibly help
provide some speed increases when accessed through AIS?

Thanks,
Randall H. Carpenter


Josh Neider Posted on 2009-04-08 15:26:49.0Z
From: "Josh Neider" <jneider@sybase.com>
Newsgroups: Advantage.Internet_Server
References: <49dbf05d@solutions.advantagedatabase.com>
In-Reply-To: <49dbf05d@solutions.advantagedatabase.com>
Subject: Re: AIS speed
Date: Wed, 8 Apr 2009 09:26:49 -0600
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8064.206
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8064.206
NNTP-Posting-Host: 10.24.34.232
Message-ID: <49dcc21e@solutions.advantagedatabase.com>
X-Trace: 8 Apr 2009 09:26:22 -0700, 10.24.34.232
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.232
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:776
Article PK: 1121030

Hello Randall,

You may want to check out latency as a culprit for speed issues.

This knowledge base item has some tips that may help:
http://devzone.advantagedatabase.com/dz/content.aspx?Key=17&RefNo=081201-2096

Regards

Josh Neider

"Randall Carpenter" <randall@advancegroup.us> wrote in message
news:49dbf05d@solutions.advantagedatabase.com...
> I finally got AIS working. My app (running locally) can login to my
> database 72 miles away. That's pretty cool. However, once logged in, the
> response time is slow - probably too slow to use in a production
> environment.
>
> I am going to upgrade my internet access speed on both ends. The server
> is accessing the 'net at 6mbs while the computer on which the app is
> installed is accessing the 'net at 3 mbs. I am planning to upgrade both
> ends to 10mbs.
>
> I was also wondering about my table types. Currently I am using DBF
> tables. Would I get better throughput if I converted them to ADT tables?
> From what I gather from studying and reading about ADS, it sounds as if
> ADT tables are inherently more efficient than DBF tables. Would ADT
> tables possibly help provide some speed increases when accessed through
> AIS?
>
> Thanks,
> Randall H. Carpenter


Edgar Sherman Posted on 2009-04-08 18:22:04.0Z
Date: Wed, 08 Apr 2009 12:22:04 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: Advantage.Internet_Server
Subject: Re: AIS speed
References: <49dbf05d@solutions.advantagedatabase.com> <49dcc21e@solutions.advantagedatabase.com>
In-Reply-To: <49dcc21e@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <49dceb27@solutions.advantagedatabase.com>
X-Trace: 8 Apr 2009 12:21:27 -0700, 10.24.34.164
Lines: 43
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:777
Article PK: 1121031

In addition to what Josh indicated you may want to look at reducing the
amount of data brought across.

I don't know what language you use or if you have access to the source
code, but reducing the read-ahead record caching may help.

Edgar

Josh Neider wrote:
> Hello Randall,
>
> You may want to check out latency as a culprit for speed issues.
>
> This knowledge base item has some tips that may help:
> http://devzone.advantagedatabase.com/dz/content.aspx?Key=17&RefNo=081201-2096
>
>
> Regards
>
> Josh Neider
>
> "Randall Carpenter" <randall@advancegroup.us> wrote in message
> news:49dbf05d@solutions.advantagedatabase.com...
>> I finally got AIS working. My app (running locally) can login to my
>> database 72 miles away. That's pretty cool. However, once logged in,
>> the response time is slow - probably too slow to use in a production
>> environment.
>>
>> I am going to upgrade my internet access speed on both ends. The
>> server is accessing the 'net at 6mbs while the computer on which the
>> app is installed is accessing the 'net at 3 mbs. I am planning to
>> upgrade both ends to 10mbs.
>>
>> I was also wondering about my table types. Currently I am using DBF
>> tables. Would I get better throughput if I converted them to ADT
>> tables? From what I gather from studying and reading about ADS, it
>> sounds as if ADT tables are inherently more efficient than DBF
>> tables. Would ADT tables possibly help provide some speed increases
>> when accessed through AIS?
>>
>> Thanks,
>> Randall H. Carpenter
>


Joachim Duerr (ADS) Posted on 2009-04-09 10:32:28.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: AIS speed
Newsgroups: Advantage.Internet_Server
References: <49dbf05d@solutions.advantagedatabase.com> <49dcc21e@solutions.advantagedatabase.com> <49dceb27@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.110
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 10.56.66.104
Message-ID: <49ddc0ac@solutions.advantagedatabase.com>
Date: 9 Apr 2009 03:32:28 -0700
X-Trace: 9 Apr 2009 03:32:28 -0700, 10.56.66.104
Lines: 15
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.104
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:778
Article PK: 1121032


Edgar Sherman wrote:

>In addition to what Josh indicated you may want to look at reducing
>the amount of data brought across.
>
>I don't know what language you use or if you have access to the
>source code, but reducing the read-ahead record caching may help.

additionally: Verify that compression is switched on for AIS on both
ends of the line.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Rene Flores Posted on 2009-05-04 00:47:53.0Z
Date: Sun, 03 May 2009 19:47:53 -0500
From: Rene Flores <rflores@ciber-tec.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: Advantage.Internet_Server
Subject: Re: AIS speed
References: <49dbf05d@solutions.advantagedatabase.com>
In-Reply-To: <49dbf05d@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 201.144.87.40
Message-ID: <49fe3b13@solutions.advantagedatabase.com>
X-Trace: 3 May 2009 18:47:15 -0700, 201.144.87.40
Lines: 36
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!201.144.87.40
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:779
Article PK: 1121033

Randall:

Sounds pretty strange to me, I have the server connected with a
dedicated ADLS 4 mbps and the clients are 2 mbps, the app works as it
was in a 10 mpbs LAN, I mean it's perfectly useable even from more than
1000 kms away form the server.

However I think my speed is because the ADSL provider is the same
company for both, clients and servers and the communication goes inside
the same network.

Regards

Rene Flores
http://www.ciber-tec.com

Carpenter escribió:

> I finally got AIS working. My app (running locally) can login to my
> database 72 miles away. That's pretty cool. However, once logged in,
> the response time is slow - probably too slow to use in a production
> environment.
>
> I am going to upgrade my internet access speed on both ends. The server
> is accessing the 'net at 6mbs while the computer on which the app is
> installed is accessing the 'net at 3 mbs. I am planning to upgrade both
> ends to 10mbs.
>
> I was also wondering about my table types. Currently I am using DBF
> tables. Would I get better throughput if I converted them to ADT
> tables? From what I gather from studying and reading about ADS, it
> sounds as if ADT tables are inherently more efficient than DBF tables.
> Would ADT tables possibly help provide some speed increases when
> accessed through AIS?
>
> Thanks,
> Randall H. Carpenter


Dmitry Merkotan Posted on 2009-07-04 06:28:36.0Z
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Newsgroups: Advantage.Internet_Server
References: <49dbf05d@solutions.advantagedatabase.com>
Subject: Re: AIS speed
Date: Sat, 4 Jul 2009 09:28:36 +0300
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 80.73.0.193
Message-ID: <4a4ef67f@solutions.advantagedatabase.com>
X-Trace: 4 Jul 2009 00:28:15 -0700, 80.73.0.193
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.73.0.193
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:781
Article PK: 1121035

"Randall Carpenter" <randall@advancegroup.us> ???????/???????? ? ????????
?????????: news:49dbf05d@solutions.advantagedatabase.com...

>I finally got AIS working. My app (running locally) can login to my
>database 72 miles away. That's pretty cool. However, once logged in, the
>response time is slow - probably too slow to use in a production
>environment.
>
> I am going to upgrade my internet access speed on both ends. The server
> is accessing the 'net at 6mbs while the computer on which the app is
> installed is accessing the 'net at 3 mbs. I am planning to upgrade both
> ends to 10mbs.
>
> I was also wondering about my table types. Currently I am using DBF
> tables. Would I get better throughput if I converted them to ADT tables?
> From what I gather from studying and reading about ADS, it sounds as if
> ADT tables are inherently more efficient than DBF tables. Would ADT
> tables possibly help provide some speed increases when accessed through
> AIS?
>

Hi, Randall.
Have you solved your problem?
We have speed issues too.
Have you measured internet traffic speed during AIS connection?

--
Dmitry Merkotan

SoftPro system administrator

Ukraine