You're much better off copying the data into temporary tables before doing a
join.
CVSREAD is only intended to be used for importing data, it's not fast when
doing a join.
Dsp Dsp wrote:
> select * from csvread('secfile) b inner join csvread('firstfile.csv')
> a on a.col1=b.col1 order by a.col1
>
> This query is taking very long time to execute...Is there any
> solutions?
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
