TM1 Forum

Hello All

I was trying to delete 55000 rows from the relational table from existing ODBC output TI process. Inserting Data activity is fast as it should be in TM1 but deleting rows is too slow. The code for delete rows are as under:

vSql='Delete From [M1].[dbo].[Report]
Where Month=''%v2%'' and Year=''%v1%''';


ODBCOutput('production',Expand(vSql));

Is there a way to execute above code faster from ODBC output TI itself instead of following way ?

=> Alternate Way i approached:
I did achieve it through batch file where other TM1runTIs are integrated. It is fast also.

How many times are you executing the SQL? Are you using a data source within TM1? I can't see why a single DELETE ... WHERE would be slow.

are you excuting odbcoutput for delete in matadata or data tab? it should be prolog or in epilog..

Has your DB table properly been indexed?

@ escape18in

You were right. I wrote sql statement to delete rows in prolog but the odbc function to execute that sql query was in data tab

I put it in to prolog and i am good now.

Thank You all

Dharav