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: