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.

speed issue with insert - remote vs local

2 posts in OLEDB Last posting was on 2006-02-15 17:26:17.0Z
Tom Snider Posted on 2006-02-14 21:42:36.0Z
Reply-To: "Tom Snider" <thomasgsnider@sbcglobal.net>
From: "Tom Snider" <thomasgsnider@sbcglobal.net>
Newsgroups: advantage.oledb
Subject: speed issue with insert - remote vs local
Date: Tue, 14 Feb 2006 15:42:36 -0600
Lines: 22
Organization: Tom Snider Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
NNTP-Posting-Host: 67.11.202.150
Message-ID: <43f24e04@solutions.advantagedatabase.com>
X-Trace: 14 Feb 2006 14:39:16 -0700, 67.11.202.150
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!67.11.202.150
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1145
Article PK: 1133666

I have posted this in recent past, but it disappeared and got no response,
so I'll try again.

I have a process that does around 15000-16000 inserts into a small table.
The table has only one column, PONo, char(15). The table has no indexes. The
table is attached to a 7.1 ADS database on a Windows 2003 file server with 2
gig RAM and 2 2.8 cpu's. The network is running gigabit switches and cat-5e
cable. The workstation is a Win2000 2.4 gig cpu with 1gig ram. When I run
this process that inserts into the aforementioned table, it takes over 20
minutes. So, I created a free table on the same drive as the database files.
Then I changed the program to insert into the free table.....it took about
20 seconds.

I understand that there will be some performance degradation while going
through the ADS server; however, this seems way out of line.
Can somebody let me know if this is normal or not.

Thanks,

tom snider


Mark Wilkins Posted on 2006-02-15 17:26:17.0Z
From: "Mark Wilkins" <tired@of.spam>
Newsgroups: advantage.oledb
References: <43f24e04@solutions.advantagedatabase.com>
Subject: Re: speed issue with insert - remote vs local
Date: Wed, 15 Feb 2006 10:26:17 -0700
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 198.102.102.12
Message-ID: <43f36379@solutions.advantagedatabase.com>
X-Trace: 15 Feb 2006 10:23:05 -0700, 198.102.102.12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.12
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1146
Article PK: 1133667

Hi Tom,

Can you provide some code that demonstrates the issue? I tried the obvious
things (loop and use a parameterized SQL statement to insert 20,000 records
into the described table). I do not see any difference in speed between the
dictionary bound table and the free table. The 20 seconds you describe for
the free table should be the speed for both cases.

Mark Wilkins
Advantage R&D

"Tom Snider" <thomasgsnider@sbcglobal.net> wrote in message
news:43f24e04@solutions.advantagedatabase.com...
>I have posted this in recent past, but it disappeared and got no response,
> so I'll try again.
>
> I have a process that does around 15000-16000 inserts into a small table.
> The table has only one column, PONo, char(15). The table has no indexes.
> The
> table is attached to a 7.1 ADS database on a Windows 2003 file server with
> 2
> gig RAM and 2 2.8 cpu's. The network is running gigabit switches and
> cat-5e
> cable. The workstation is a Win2000 2.4 gig cpu with 1gig ram. When I run
> this process that inserts into the aforementioned table, it takes over 20
> minutes. So, I created a free table on the same drive as the database
> files.
> Then I changed the program to insert into the free table.....it took about
> 20 seconds.
>
> I understand that there will be some performance degradation while going
> through the ADS server; however, this seems way out of line.
> Can somebody let me know if this is normal or not.
>
> Thanks,
>
> tom snider
>
>