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.

Is anyone else seeing High CPU usage with datawindows

2 posts in General Discussion (old) Last posting was on 2000-02-22 02:20:48.0Z
Erik Toft Posted on 2000-02-17 21:47:48.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 17 Feb 2000 15:47:48 -0600
From: Erik Toft <etoft@frontierast.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Is anyone else seeing High CPU usage with datawindows
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 58
NNTP-Posting-Host: gateway.frontierast.com 207.136.162.226
Message-ID: <347_38AC6C84.1523ACA9@frontierast.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28444
Article PK: 160462

This is a re-post of a previous message.
I know I'm a pest, but I really would like some help answering these questions.  Is the java datawindow just inherently CPU intensive while it is being displayed?  Is there a good way "around" this...a different control, JTable, a custom JScrollpane, etc?

Erik Toft

We are working on a monitoring application, using PowerJ and Jaguar, that
will take a "live feed" of data, and display the rows of data so that they
scroll up from the bottom.  That is, as new rows come in, they are added to
the bottom of the list, and older data is "pushed" up.  We have been
successful in using a grid style data window to do this, however, as the
number of rows grows, so does the CPU usage.  It eventually gets to the
point that the rest of the app is affected...windows open slower, and such.

We need the grid so that users can change column order and such.  We want to
use the datawindow grid for ease of programmability (we are old PowerBuilder
folks).  Is there a magic bullet that will help us out with the CPU
performance.

Here are some more details...   The Datawindow is always available, though
it is not always displayed.  Whether or not it is being displayed, the
thread that "feeds" it continues to add records to it.  When it is not being
displayed, the CPU usage is much lower during these adds.  When it is being
displayed, the adds cause the the CPU to spike up greatly, even pinging
100%.  The thread is used to retrieve data from a Jaguar component.  Once
retrieved, it is populated into a datastore, then the rows are copied to the
bottom of the DataWindow.

Does anyone know if this is easily fixable?  Is there a more efficient way
to display the rows? (Remember the CPU is only hit hard if the datawindow is
being displayed, so I don't think the overall set up is the culprit -- maybe
it's not the best design, but it does not seem to effect the performance.)

Any help or suggestions will be appriciated.

Erik Toft


Dave Wolf [Sybase] Posted on 2000-02-22 02:20:48.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: Is anyone else seeing High CPU usage with datawindows
Date: Mon, 21 Feb 2000 21:20:48 -0500
Lines: 165
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0011_01BF7CB1.86139870"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: PPPa43-ResaleAnnapolis1-1R7308.saturn.bbn.com 4.48.176.104
Message-ID: <347_A4HuzvNf$GA.183@forums.sybase.com>
References: <347_38AC6C84.1523ACA9@frontierast.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28237
Article PK: 160109

Erik,

At this point I would pursue with support.  Seems no one else has experience in this.

Dave Wolf
Internet Applications Division
 
Erik Toft <etoft@frontierast.com> wrote in message news:38AC6C84.1523ACA9@frontierast.com...
This is a re-post of a previous message.
I know I'm a pest, but I really would like some help answering these questions.  Is the java datawindow just inherently CPU intensive while it is being displayed?  Is there a good way "around" this...a different control, JTable, a custom JScrollpane, etc?

Erik Toft

We are working on a monitoring application, using PowerJ and Jaguar, that
will take a "live feed" of data, and display the rows of data so that they
scroll up from the bottom.  That is, as new rows come in, they are added to
the bottom of the list, and older data is "pushed" up.  We have been
successful in using a grid style data window to do this, however, as the
number of rows grows, so does the CPU usage.  It eventually gets to the
point that the rest of the app is affected...windows open slower, and such.

We need the grid so that users can change column order and such.  We want to
use the datawindow grid for ease of programmability (we are old PowerBuilder
folks).  Is there a magic bullet that will help us out with the CPU
performance.

Here are some more details...   The Datawindow is always available, though
it is not always displayed.  Whether or not it is being displayed, the
thread that "feeds" it continues to add records to it.  When it is not being
displayed, the CPU usage is much lower during these adds.  When it is being
displayed, the adds cause the the CPU to spike up greatly, even pinging
100%.  The thread is used to retrieve data from a Jaguar component.  Once
retrieved, it is populated into a datastore, then the rows are copied to the
bottom of the DataWindow.

Does anyone know if this is easily fixable?  Is there a more efficient way
to display the rows? (Remember the CPU is only hit hard if the datawindow is
being displayed, so I don't think the overall set up is the culprit -- maybe
it's not the best design, but it does not seem to effect the performance.)

Any help or suggestions will be appriciated.

Erik Toft