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]
