4 Replies Latest reply: Jul 29, 2010 12:57 PM by Hamish Donald RSS

    Combining Bookmarks - very slowly.

    Hamish Donald

      While trying out set analysis syntax to combine Bookmarks (using Qv9 SR4),

      e.g. =sum( {$ * (BM01+BM02) } ForecastSales ),

      I'm getting very slow response times depending on how the Bookmarks are created.

      If BM01 is created by a macro (ActiveDocument.CreateDocBookmark false, HDBM01, BM01, 1 ) response time is 200 seconds.

      If BM01 is created manually with the same settings, as a shared server bookmark, response time is 1 second.

      Both give the same, correct, result but why the slow response on macro created server bookmarks ?

      Can I do anything about this ?

       

        • Combining Bookmarks - very slowly.
          Jonathan Dienst

          Are you sure that the bookmark created by the macro is identical to that created manually?

          Check the current selections after applying each of them.

          Hope this helps

          Jonathan

            • Combining Bookmarks - very slowly.
              Hamish Donald

              Yes - I've just checked again and the selections (only 3 fields selected) are the same.

              I've created BM01 with the macro - noted the long response - then recalled BM01 and saved manually as BM02.

              BM02 then responds in 1 or 2 seconds when used in the set analysis syntax while the original takes 3+ minutes.

              The sheet being bookmarked does contain an input field - could that be a problem ?.

              I don't see an option for 'CreateDocBookmark' to save Input Field values.

              H.

               

              • Combining Bookmarks - very slowly.
                Jonathan Dienst

                Perhaps someone else could comment on whether there is a performance difference between a document and a server bookmark?

                Jonathan

                  • Combining Bookmarks - very slowly.
                    Hamish Donald

                    After a bit more testing - comparing the Current Selections before and after the save and recalls - I've fixed the performance problem.

                    It was the Input Sum field.

                    It seems that because I had a selection on the Input Sum field being zero, then you have to clear that field in the macro before saving with 'CreateDocBookmark' .

                    Then it can be used in Set Analysis - otherwise there is a long delay.

                    I'd prefer to get the macro to save the Input Field with the bookmark ...anyone know how to do that ?

                    H.