-
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.