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 there any solution to speed up the query .It is a simple join query
on 2 csv files .
--
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.
