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]
