4 Replies Latest reply: May 14, 2014 4:40 AM by 994122 RSS

    Search in LOV is taking time

    AnnPricks E

      Hi All,

       

        We are facing performance issue with search in forms LOV. LOV returns 200K records with order. It is working fine in CLI (Oracle forms 6i).

       

      Can you someone guide something to move on or tell me the process like how it will process after giving search text?

       

      Need to know, what happens, once LOV populated(All values present in memory) and what happens, once entering some text for searching in LOV(Filtering happened in memory)

       

       

       

      Thanks,

      Ann

        • 1. Re: Search in LOV is taking time
          Zlatko Sirotic

          Surely you know that you can increase the fetch size for records group (default is 20) and that you can use the Filter Before Display property on the LOV.

           

           

          But, I think the only real way with such a large number of data is  - use independent Forms module LOV, instead of the built-in LOV.

           

           

          Regards

          • 2. Re: Search in LOV is taking time
            AnnPricks E

            Zlatko Sirotic wrote:

             

            Surely you know that you can increase the fetch size for records group (default is 20) and that you can use the Filter Before Display property on the LOV.

             

             

            But, I think the only real way with such a large number of data is  - use independent Forms module LOV, instead of the built-in LOV.

             

             

            Regards

            fetch size for records group (default is 20) ---> Already changed it and check.. No use for that...

             

            Filter Before Display property on the LOV ---> I don't want this functionality.

             

            Independent Forms module LOV ---> Means? Can you explain a bit more?

             

             

             

            Thanks,

            Ann

             

            Message was edited by: AnnPricks E

            • 3. Re: Search in LOV is taking time
              Zlatko Sirotic

              Something like this (from the EMP - DEPT story):

               

              In EMP Forms module:

               

              -- KEY-LISTVAL trigger on :emp.deptno

              BEGIN

                call_form('dept_lov', NO_HIDE, NO_REPLACE, QUERY_ONLY, NO_SHARE_LIBRARY_DATA);


                IF NOT form_success THEN

                  RAISE form_trigger_failure;

                END IF;


                IF :GLOBAL.deptno_lov IS NOT NULL THEN

                  :emp.deptno := :GLOBAL.deptno_lov;

                  BEGIN

                    SELECT dname

                      INTO :emp.dname

                      FROM dept

                     WHERE deptno = :emp.deptno;

                  EXCEPTION

                    WHEN OTHERS THEN

                      ...

                  END;

                END IF;

              END;

               

               

              In DEPT_LOV Forms module:

               

              -- KEY-COMMIT trigger

              /* Sets the global variables passed back to calling form */

              BEGIN

                :GLOBAL.deptno_lov := :dept.deptno;

                exit_form;

              END;

               

               

              Regards

              • 4. Re: Search in LOV is taking time
                994122

                Hi Ann, i am also getting same issue could you please tell me what is the solution to resolve?