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.

Best solution for the problem.

2 posts in Windows NT Last posting was on 1998-03-09 23:44:02.0Z
Sarju Patel Posted on 1998-03-09 15:55:10.0Z
From: "Sarju Patel" <sp@als.co.uk>
Subject: Best solution for the problem.
Date: Mon, 9 Mar 1998 15:55:10 -0000
Lines: 16
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <$EMvKo2S9GA.129@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5125
Article PK: 1092489

Hi everybody,

(Environment: Adaptive Server 11.5 on Windows NT)

I have got a scenario where, I have to read of whole record from an existing
table(60 columns wide) and write it back. This are random reads from the
table.

I have tried DBLib updatable cursors and Stored procedures, but neither
gives me satisfactory performance.

Has anyone got better idea to deal with the case.

Thanks in advance.


Bret Halford Posted on 1998-03-09 23:44:02.0Z
Message-ID: <35047EC2.2A4C@sybase.com>
Date: Mon, 09 Mar 1998 16:44:02 -0700
From: Bret Halford <bret@sybase.com>
Organization: Customer Service & Support
X-Mailer: Mozilla 3.0 (X11; U; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Sarju Patel <sp@als.co.uk>
Subject: Re: Best solution for the problem.
References: <$EMvKo2S9GA.129@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5124
Article PK: 1092486


Sarju Patel wrote:
>
> Hi everybody,
>
> (Environment: Adaptive Server 11.5 on Windows NT)
>
> I have got a scenario where, I have to read of whole record from an existing
> table(60 columns wide) and write it back. This are random reads from the
> table.
>
> I have tried DBLib updatable cursors and Stored procedures, but neither
> gives me satisfactory performance.
>
> Has anyone got better idea to deal with the case.

Could you be more specific about your results?

What performance are you getting?
What performance do you need?

Try it first as straight sql,
ie select * from mytable where <primary_key> = <value>.

What kind of performance are you getting there?
If it is not adequate, does showplan show proper index use,
or is a table scan occurring? Could you improve performance
with a better index?

What performance do you get when inserting/updating the row?
Again, what does showplan show? Could you improve
performance by reducing the number of indexes on the table?
Do the columns chosen for the clustered index spread writes
out, or does it cause a point or points of contention?


--
Bret Halford Imagine my disappointment
Sybase Technical Support in learning the true nature
3665 Discovery Drive of rec.humor.oracle...
Boulder, CO 80303