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.

Slow performance

2 posts in OLEDB Last posting was on 2007-04-11 10:05:48.0Z
Yves Posted on 2007-04-10 19:06:22.0Z
From: "Yves" <yves@sisym.com>
Newsgroups: Advantage.OLEDB
Subject: Slow performance
Date: Tue, 10 Apr 2007 15:06:22 -0400
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 74.210.132.226
Message-ID: <461bdf18@solutions.advantagedatabase.com>
X-Trace: 10 Apr 2007 13:01:44 -0700, 74.210.132.226
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!74.210.132.226
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1214
Article PK: 1133735

Hi,

I use the following connection string to the database.
Is there something that I can change to optimize the performance?

I'm using 8.10.0.6 (ADS).

I have 4 computers with the same hardware on the network (Windows XP SP2).
2 of the 4 computers have some problem to connect and retrieve the
information.
After the connect, I retrieve a table with 20 records.
Sometime, it tooks more than 10 seconds to retrieve the information.

Regards,

Yves

Connection string :

Provider=Advantage.OLEDB.1;Password=CAD;User ID=Cart;Data
Source=\\serveur-rao\wsymdata$\symrao\dbrao.add;Initial
Catalog="";Mode=ReadWrite;Extended Properties="";Advantage Character Data
Type=ADS_ANSI;Advantage Compression="";Advantage Encryption
Password="";Advantage Filter Options=IGNORE_WHEN_COUNTING;Advantage Locking
Mode=ADS_PROPRIETARY_LOCKING;Advantage Security
Mode=ADS_CHECKRIGHTS;Advantage Server Type=ADS_REMOTE_SERVER |
ADS_AIS_SERVER;Increment User Count=FALSE;Show Deleted Records in DBF Tables
with Advantage=FALSE;Stored Procedure Connection=FALSE;Advantage Table
Type=ADS_ADT;Trim Trailing Spaces=FALSE;Use NULL values in DBF Tables with
Advantage=FALSE


Joachim Duerr (ADS) Posted on 2007-04-11 10:05:48.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Slow performance
Newsgroups: Advantage.OLEDB
References: <461bdf18@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <461ca4ec@solutions.advantagedatabase.com>
Date: 11 Apr 2007 03:05:48 -0700
X-Trace: 11 Apr 2007 03:05:48 -0700, 130.214.79.11
Lines: 22
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1215
Article PK: 1133736


Yves wrote in <461bdf18@solutions.advantagedatabase.com>:

> I have 4 computers with the same hardware on the network (Windows XP
> SP2). 2 of the 4 computers have some problem to connect and retrieve
> the information. After the connect, I retrieve a table with 20
> records. Sometime, it tooks more than 10 seconds to retrieve the
> information.

I guess the discovery consumes most of the time. If you add following
to your ads.ini, it'll bypass the discovery:

[serveur-rao]
lan_ip=192.168.1.1
lan_port=6262

(please use your server's IP address and port!)

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com