Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-11633

Increase the default time on SQL queries

XMLWordPrintable

    • Fuse 7.5 Sprint 53 - Blockers

      I have set up DB connection with tables which contains a following amounts of data:

      Table Number of row
      hugea 500000
      largea 10000
      mediuma 1000

      When I want to create Periodic SQL invocation step for the whole table (select * from <table>), the creation for the huge table failed. When I click on Next button, the UI shows "The query could not be completed in 15.0 seconds.". Partial workaround for this issue is adding a limit for query e.g.

      SELECT * FROM hugea LIMIT 10000
      

      However, what if the customer wants to select the whole table.

              kstam@redhat.com Kurt Stam (Inactive)
              mkralik@redhat.com Matej Kralik
              Matej Kralik Matej Kralik
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: