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]
