Re: Forms 3.0 Any one still using it ???

engsys_at_merlion.singnet.com.sg wrote:

: Hi there,
 

: If anyone is using forms 3.0, i have a question.
: I have a form which fetches data from different tables
: into the form by a cursor and populates it into the form.
: It fetches records upto 80 or 90 faster and then onwards
: it takes about a second for each record fetched.
 

: Can anyone suggest something to speed up the
: fetch.

Create a join view on your tables. If you are using Oracle 6 you should be careful to list tables in the FROM clause with the table yielding the fewest rows last if your tables are indexed. I have the impression that Oracle 7 takes care of that from itself.

Then change you block to a block referencing your view and make your fields database fields.

: thanks in advance.
 

: prasad.

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+   Christian Mondrup                                                     +
+   Computer Programmer                                                   +
+   Scandiatransplant, Skejby Hospital, University Hospital of Aarhus     +
+   Brendstrupgaardsvej                                                   +
+   DK 8200 Aarhus N                                                      +
+   Denmark                                                               +
+                                                                         +
+   Phone:   +45 89 49 53 01                                              +
+   Telefax: +45 89 49 60 07                                              +
+   E-Mail:  scancm_at_biobase.dk                                            +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++