Hi folks,
I need an online visualization of inventory data stored in an oracle database of TIVOLI Inventory within SC.
To do that, I created several forms (and corresponding files) fitting to certain views within the TIVOLI database and display these forms as virtual joins. Everything works fine, except of one single form fitting to a harddisk view within TIVOLI Inventory. To visualize this single view within SC takes ages (about 70 seconds). The views are all pretty similar but the harddisk view takes its data from two tables which are joined by 3 (!) keys. I thought, this could be the reason of the delay, but if I state the select statement on the Inventory database host, it's very fast and makes no problems.
Has anybody any idea, why this view is so slowly when used out of SC??? Any reply is very welcome! Thanks in advance, Kai
I need an online visualization of inventory data stored in an oracle database of TIVOLI Inventory within SC.
To do that, I created several forms (and corresponding files) fitting to certain views within the TIVOLI database and display these forms as virtual joins. Everything works fine, except of one single form fitting to a harddisk view within TIVOLI Inventory. To visualize this single view within SC takes ages (about 70 seconds). The views are all pretty similar but the harddisk view takes its data from two tables which are joined by 3 (!) keys. I thought, this could be the reason of the delay, but if I state the select statement on the Inventory database host, it's very fast and makes no problems.
Has anybody any idea, why this view is so slowly when used out of SC??? Any reply is very welcome! Thanks in advance, Kai