Hi,
> select * from csvread('secfile.csv') b inner join
> csvread(firstfile.csv') a on b.col1=a.col1 order by a.col1
This will read the file 'secfile.csv' once, but the file
'firstfile.csv' is read once _for every row_ in the other file.
For performance reason, CSVREAD should not be used inside
select * from csvread('secfile.csv') b inner join
csvread(firstfile.csv') a on b.col1=a.col1 order by a.col1
files are around 2mb
i am using eclipse with -Xms1G -Xmx1G vm arg
for retrieving 1000 rows it is taking around 5 mins when i used in H2
console...and much more time in eclipse.
Is ther