TI sql query too long

[StoneDX]

Hello,

I am currently working on dimensions using TI with ODBC SQL query on a SQL Server Database.
My problem is that all my requests on TI are extremely long compared with SQL query directly on the database.
For example my 20 seconds query becomes more than an hour on TI.

I don't really understand what append but I am seriously frustrated, looking at my hourglass on my TI window.

If anyone has an idea of my issue…

Thanks in advance

StoneDX

[George Regateiro]

Can you provide a little more info on the environment?

1) Are the SQL box and TM1 Server on the same LAN or are they connected by a WAN? - This will have some effect but it should not account for all the difference.

2) Have you tried running the query through Excel on the TM1 Server? If so what were the results.

3) When you say it is taking an hour is that for the entire process to run (with your logic) or is this just get TI to refresh the variables and such?

4) Is there anyone else developing on the TM1 server at the time that could be running processes?

[StoneDX]

I found why it was so long.

Execution plans in TM1 are not the same than in SQL Server.
That's why my SQL requests were so long in TM1 and not in SQL Server.

Have to work now to optimize my SQL requests

Thank you.