Gregory,
in addition to Rogers suggestions I'd suggest that you limit the max number
of rows property in the data object.
Also, I noticed that order by statements can take some time. You can check
this if you use SQL*Plus to run the query. If you have large table and
issue a query with order by, you'll notice that it takes some time until the
records are starting to show up. If you omit the order by, the query is much
faster.
Axel
Gregory Bohmer <[EMAIL PROTECTED]> schrieb in im Newsbeitrag:
[EMAIL PROTECTED]
> Hi all,
>
> We have a very large table in our Oracle database that we are
> trying to hook up a DataObject to. The table (actually it's a view)
> has 34 columns and 13,000 rows. The execution of the
> DataObject takes around 3 minutes - regardless of the dynamic
> criteria added. Has anyone seen this type of poor performance?
> What are other people's experience working with tables
> approaching this size?
>
> Thanks for all input...
>
> -Gregory, HHMI
>
>
_________________________________________________________________________
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]
