I repeat: do some analysis on your log to see what the actual timesuckers
are.
-- Curt
At 01:54 AM 5/1/99 +0530, Deepak Kumar Adhikary wrote:
>Thanks Grace for the detail analysis.
>
>The queries which we have are as follows : I have got rid of one data
>object as 2 combo boxes are being populated with the same data exactly.
>
>1. select NVL(substr(A,0,2), 'null' ) from (select distinct A from
>tabA ) order by A
>2. Same query as above
>3. select NVL(B,'null' ) from ( select distinct B from tabB )
>group by B order by B
>4. select NVL ( C, 'null' ) from ( select distinct C from tabA)
>order by C
>5. select NVL( substr(A,7,length(A)), ' ' ) from (select distinct A
>from tabA ) order by A
>
>Regarding the limit on maximum no. of rows a combo box can show, there's
>no problem with about 1350 rows. Is there any such limit at all ? Only
>thing is that it takes to much time. We have oracle database running on
>an unix server to which my Windows NT ND application server connects. I
>have tested it out ( the same queries, in fact with 5 data objects ) on
>ND 5.0 where it used to take somewhere between 30 seconds to 3 mins
>depending on the network load and the load on oracle which was okay for
>testing purposes.
>
>At present we are just converting an existing livewire application to
>ND. It contains server side javascripts intermingled with client side
>javascripts as well. The livewire fetches the same screen in about 10 -
>30 seconds as it runs on the unix server itself where the database is
>also there. So at this stage we can't change the screen design as such.
>We have to make an exact copy of the application on ND
>
>Still it is taking around 10 minutes to get the screen on ND4. Do you
>have any idea as to why is there so much difference in data fetching
>between ND 5 & ND 4.1.3. ? Do we need to do any settings on the ND 4
>application server ?
>
>Do you think the queries can be still be optimised to be more efficient
>?
>
>As for the maximum no of rows fetched I was able to solve it by setting
>the 'Maximum records to retrieve' setting in the RDBMS Service in the
>Command Center. What I found here was that inspite of the changes I made
>from 5000 to 7000 it was still fetching a max of 5000 records.The change
>got reflected only after restarting my machine. Doesn't the command
>centre settings take effect immediately after saving them ? Well it did
>for the log service as soon as I checked the logging levels for the CP
>, RDBMS & Log services.
>
>Any help would be highly appreciated.
>
>Thanks
>Deepak
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Curt Springer
>[mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 29, 1999 3:59 AM
> To:
>[EMAIL PROTECTED]
> Subject: Re: [ND] ND4 - Taking too much time to
>load page with associated data obje cts
>
> Also, you haven't told us how long any operation is
>taking. There's still
> no basis for anybody to say whether the problem is the
>time it requires
> the dbms to execute each query and return the results to
>ND, the time it
> takes for ND to compose the page, both, or neither. You
>can get things
> timed to the millisecond in the log.
>
> -- Curt Springer, Team ND
>
>
> At 04:47 PM 4/28/99 -0500, Grace Frederick wrote:
> >You failed to show us the queries generated for each of
>the data objects.
> >(If you don't want to show us the exact query with
>table names, etc for
> >security reasons, just modify the queries to show
>TABLEA, TABLEB, TABLEC for
> >table names and COLA, COLB, COLC for column names.)
> >
> >That said:
> >
> >Using conservative estimates, let's assume that each of
>the items in the
> >combo box is 10 characters long. If items for each of
>the rows from the
> >data object results are generated, the HTML for number
>of characters
> >required for each of the combo boxes would be roughly
>(assuming around 20
> >characters for the HTML required for the options and
>approx 50 characters
> >for the SELECT HTML)
> > Rows Char for options Total
> > cb1 1350 27000 27050
> > cb2 1400 28000 28050
> > cb3 60 1200 1250
> > cb4 300 6000 6050
> > cb5 1400 28000 28050
> > ------------
> > total 90450
> >
> >
> >Believe it or not, that takes awhile for ND to generate
>(to be fair, it
> >would take a long time to generate in any language with
>any server!) Those
> >characters also have to be transfered and rendered,
>which will only increase
> >the wait. The number of characters required will
>increase even further if
> >the combo box items are created by appending data
>fields (like [LAST_NAME],
> >[FIRST_NAME]). (Also remember that any form elements
>which are displayed
> >inside a table will not be displayed until the entire
>table can be
> >displayed.)
> >
> >Take note that these estimates don't include the
>remaining page content
> >(including the session key, which is another 700
>characters, give or take a
> >few!)
> >
> >I don't think that browserse will even display all of
>the entries anyay. I
> >found a forum listing from Peter Cheung indicating
>200-300 was the limit,
> >but I can't seem to find the standard that governs this
>particular point.
> >I've experienced combo boxes not displaying all entries
>when over 1300 items
> >are in the combo box (back in my young, newbie ND
>days), so I know that
> >there IS a limit.
> >
> >IME, even a combo box with 200 entries borders on
>unusable, though. I
> >greatly encourage you to rethink the design. Even if
>your users won't mind
> >waiting, they will mind searching through the results
>to find the right
> >entry in a combo box with 1000 entries!
> >
> >As for the variations in number of rows returned from a
>data object, you
> >might want to check:
> >- 'Maximum records to retrieve' setting in the RDBMS
>Service (through the
> >Command Center)
> >- 'Default Max Rows' property for the data object
>through the Studio
> >
> >Hope that helps.
> >
> >-- Grace
> >
> >
> >
> >
> >
> >----- Original Message -----
> >From: Deepak Kumar Adhikary <[EMAIL PROTECTED]>
> >To: Curt Springer <[EMAIL PROTECTED]>;
>Grace Frederick
> ><[EMAIL PROTECTED]>;
>
>><[EMAIL PROTECTED]>
> >Sent: Wednesday, April 28, 1999 3:42 PM
> >Subject: Re: [ND] ND4 - Taking too much time to load
>page with associated
> >data obje cts
>
> >
> >
> >> Thanks Grace & Curt.
> >>
> >> What I have in my page is 5 combo boxes which are
>bound to 5 data
> >> objects. Each of the data object queries against
>tables and the returned
> >> number of rows are approx 1350, 1400, 60, 300 & 1400
> >>
> >> I have put the logging service and it shows the
>following messages :
> >>
> >> Execute SQL command : query ....
> >> Scrolling cursor capability already disabled
> >> Enter rw get sequential cursor
> >> Leave rw get sequential cursor
> >> Obtained valid sequential cursor
> >> Enter sequential cursor fetch
> >> Cannot fetch row 1346 ( rows_offset = 0 row_count =
>5000 )
> >> Fetched 1346 rows out of 5000 requested
> >>
> >> The same thing repeats for the next dataobject. Can
>you make anything
> >> out of this ?
> >>
> >> Also I have set the maximum rows to fetch to 7000.
>Inspite of that it is
> >> truncating it to a max of 5000. This happens in
>another page where an
> >> executeImmediate is done by writing a query. Only
>5000 records are
> >> fetched while actually there are about 6300 records
>in the table.
> >>
> >> Regards,
> >> Deepak
> >>
> >>
> >> -----Original Message-----
> >> From: Curt Springer
> >> [mailto:[EMAIL PROTECTED]]
> >> Sent: Wednesday, April 28, 1999 7:31 PM
> >> To:
> >>
>[EMAIL PROTECTED]
> >> Subject: Re: [ND] ND4 - Taking too much time to
> >> load page with associated data obje cts
> >>
> >> As Grace said, turn on logging. At least in the CP
> >> service and the RDBMS
> >> service (in the command center), go to the 'logging'
>tab
> >> and click the
> >> options under 'timing'.
> >>
> >> This could be any number of things, and one or more
>of
> >> us will probably be
> >> able to help you once we know what the problem is (if
>it
> >> isn't obvious to
> >> you), but you have to tell us what is really
>happening.
> >>
> >> -- Curt Springer, Team ND
> >>
> >> At 07:11 AM 4/28/99 -0500, Grace Frederick wrote:
> >> >How many rows are being returned for each of the
>data
> >> objects? How many
> >> >data fields does each data object have? (Use
>logging
> >> to find out exactly
> >> >what query is going to the database.) When
>comboboxes
> >> are generated, every
> >> >row returned from the data object will be processed,
> >> and that can take a
> >> >long time.
> >> >
> >> >Warning: if the result sets are too large, like over
> >> 1000 items or so
> >> >(forget the exact number but it's been discussed in
>the
> >> forum in the past),
> >> >HTML will be generated for all items but they won't
>all
> >> get displayed.
> >> >Also, usability decreases dramatically as the number
>of
> >> comboboxes entries
> >> >increase.
> >> >
> >> >Hope that helps.
> >> >
> >> >-- grace
> >> >
> >> >----- Original Message -----
> >> >From: Deepak Kumar Adhikary <[EMAIL PROTECTED]>
> >> >To:
> >>
><[EMAIL PROTECTED]>
> >> >Cc: <[EMAIL PROTECTED]>
> >> >Sent: Tuesday, April 27, 1999 11:31 PM
> >> >Subject: [ND] ND4 - Taking too much time to load
>page
> >> with associated data
> >> >obje cts
> >> >
> >> >
> >> >> Hi,
> >> >>
> >> >> I have a page which has a few combo boxes filled
>from
> >> the database using
> >> >> data objects. The data objects are bound to the
>page.
> >> >>
>
> >> >> The problem is it is taking too much time i.e. not
> >> less than 15 minutes
> >> >> to load the page even though I have a 128 MB RAM
> >> machine.
> >> >>
> >> >> Is there any tuning which can be done on the ND
> >> application server side
> >> >> ?
> >> >> Any pointers are appreciated.
> >> >>
> >> >> Thanks
> >> >> Deepak
> >> >>
> >>
>________________________________________________________________________
> >> _
> >> >>
> >> >> For help in using, subscribing, and unsubscribing
>to
> >> the discussion
> >> >> forums, please go to:
> >> http://www.netdynamics.com/support/visitdevfor.html
> >> >>
> >> >> For dire need help, email:
>[EMAIL PROTECTED]
> >> >>
> >> >
> >>
> >>
>>_______________________________________________________________________
> >> __
> >> >
> >> >For help in using, subscribing, and unsubscribing to
> >> the discussion
> >> >forums, please go to:
> >> http://www.netdynamics.com/support/visitdevfor.html
> >> >
> >> >For dire need help, email: [EMAIL PROTECTED]
> >> >
> >>
> >>
>________________________________________________________________________
> >> _
> >>
> >> For help in using, subscribing, and unsubscribing to
>the
> >> discussion
> >> forums, please go to:
> >> http://www.netdynamics.com/support/visitdevfor.html
> >>
> >> For dire need help, email: [EMAIL PROTECTED]
> >>
>________________________________________________________________________
>_
> >>
> >> For help in using, subscribing, and unsubscribing to
>the discussion
> >> forums, please go to:
>http://www.netdynamics.com/support/visitdevfor.html
> >>
> >> For dire need help, email: [EMAIL PROTECTED]
> >>
> >
>
>________________________________________________________________________
>_
>
> For help in using, subscribing, and unsubscribing to the
>discussion
> forums, please go to:
>http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
