-
Bug
-
Resolution: Done
-
Major
-
fuse-7.x-GA
-
%
-
Not applicable
-
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.