niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Sybase
Performance issue
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
sharona
*nix forums beginner


Joined: 24 Jun 2005
Posts: 6

PostPosted: Tue Jul 18, 2006 12:04 pm    Post subject: Performance issue Reply with quote
I have just added a new column on an existing table.

This column is getting updated at an average rate of 25,000 rows per
day.

The table is written to and read from by a Sybase Stored Procedure. I
am finding that each week the sproc grinds to a halt and the IO goes
through the roof. I have to reorg the index relating to the new column
and then sp_recompile the sproc.

Does anyone know why this is happening? Is there a chance that I have
a size dependent sql query somewhere in the sproc that needs to be
re-written?

Thanks.
Back to top
Carl Kayser
*nix forums beginner


Joined: 25 May 2005
Posts: 42

PostPosted: Tue Jul 18, 2006 2:00 pm    Post subject: Re: Performance issue Reply with quote
"sharona" <shari.arman@morganstanley.com> wrote in message
news:1153224269.972312.54210@m73g2000cwd.googlegroups.com...
Quote:

I have just added a new column on an existing table.

This column is getting updated at an average rate of 25,000 rows per
day.

The table is written to and read from by a Sybase Stored Procedure. I
am finding that each week the sproc grinds to a halt and the IO goes
through the roof. I have to reorg the index relating to the new column
and then sp_recompile the sproc.

Does anyone know why this is happening? Is there a chance that I have
a size dependent sql query somewhere in the sproc that needs to be
re-written?

Thanks.


Offhand, I am overwhelmed with the information that you have provided. It's
too much to absorb.

set sarcasm off
go

What ASE version are you running? Are there delete and/or inserts as well?
Dose the table use All Pages, Data Pages, or Data Row locking? The new
column is of what type? The table composition is what? The indexes are?

The stored procedure "writes" to the table and then reads from it? Does it
have subroutines? Are you sure that the stored procedure(s) don't have some
design flaws?

You have said that you periodically reorg the index (so it looks like DPL or
DRL) and do sp_recompile. Apparently it helps? A lot?
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Mon Dec 01, 2008 10:23 pm | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Performance and Consistency ?? likun.navipal@gmail.com Berkeley DB 4 Fri Jul 21, 2006 4:24 am
No new posts AIX performance tuning jpzhai@gmail.com AIX 5 Fri Jul 21, 2006 2:27 am
No new posts TLS cert issue Nick Smith Postfix 3 Thu Jul 20, 2006 7:40 pm
No new posts Root relay issue Johnson, S Postfix 4 Thu Jul 20, 2006 6:50 pm
No new posts Weird MemoryError issue jedi200581@yahoo.co.uk python 4 Wed Jul 19, 2006 3:58 pm

Hotel Portal France, Italy, UK | Credit Card | Internet Advertising | Bad Credit Mortgages | Personal Car Finance
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1825s ][ Queries: 16 (0.0978s) ][ GZIP on - Debug on ]