>
> Hi guys, I am working on an application using web2py framework, and I need 
> to import a csv file that has a size of 700MB. Is there a faster way to 
> import it into the database ? I have tried the database administration 
> tool, but it takes forever. 
>

Have you tried the web2py shell?

]$ python web2py.py -S <app name> -M

>>> with open(<csv file path>) as csvfile:
>>>     db.<table>.import_from_csv_file(csvfile)

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to