Hi everyone
I am using CSVREAD to read data from CSV file.
I am working with a device that has only 64 MB of RAM. I have about
50,000 records in that flat data (CSV) file and each record is around
100 bytes.
Probelm is it is taking around 3 minutes to select one record.
============================================
Here is the statement I am using in my program.
sql = "SELECT * FROM CSVREAD('datafile.csv')";
rs = stmt.executeQuery(sql);;
Any clues?
Sohail
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
