hello,
I encounter a problem when export a query result to a file using ICE:

select ... into outfile ‘a.txt’ from t1,t2 where t1.id=t2.id;

It run very slowly,but the following sql is fast:

select ... into outfile ‘a.txt’ from t1;

How I improve export performence?
Thank you.

Hi !

In the first case you do a join. I do not think there is any problem with export - simply the first query must do a join and it takes time.
You can post table definitions and query log (see http://www.infobright.org/wiki/Query_Execution_Log/) if you would like to ask how to speed up the join.