Complex SQL affect how long TI takes to open?
-
MarioRubbo
- Posts: 44
- Joined: Wed Nov 04, 2009 3:50 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007
Complex SQL affect how long TI takes to open?
Does the complexity of a SQL statement affect how long a TI process takes to open? Is there some processing/validation that takes place during the initial opening of a TI process - i.e. does it validate the SQL or reparse the variables? For one of my TI processes, the initial Data Source window takes a long time to display and the Variables window also takes a long time. My other TI processes with simple SQL are fine.
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Complex SQL affect how long TI takes to open?
I'm more or less sure that it _runs_ the SQL when you open the TI. Yes, it can be a real pain....
-
Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Complex SQL affect how long TI takes to open?
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
MarioRubbo
- Posts: 44
- Joined: Wed Nov 04, 2009 3:50 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007
Re: Complex SQL affect how long TI takes to open?
thank you for validating that I am not insane...
-
ScottW
- Regular Participant
- Posts: 152
- Joined: Fri May 23, 2008 12:08 am
- OLAP Product: TM1 CX
- Version: 9.5 9.4.1 9.1.4 9.0 8.4
- Excel Version: 2003 2007
- Location: Melbourne, Australia
- Contact:
Re: Complex SQL affect how long TI takes to open?
You might also find Vizier useful. It is a TM1 development environment that among other things includes a fully featured TI editor which only refreshes the SQL query when actually asked to do so!MarioRubbo wrote:Does the complexity of a SQL statement affect how long a TI process takes to open? Is there some processing/validation that takes place during the initial opening of a TI process - i.e. does it validate the SQL or reparse the variables? For one of my TI processes, the initial Data Source window takes a long time to display and the Variables window also takes a long time. My other TI processes with simple SQL are fine.