csv import slow

Sergey Pashkov sergey_pashkov at valentina-db.com
Fri Oct 10 07:37:50 CDT 2014


Hi Jon,
So you have tried to import CSV file into a new table in a local Valentina
Database and it was very slow?

--
Best regards,
Sergey Pashkov.

On Fri, Oct 10, 2014 at 3:19 PM, Jonathan Evans <consultjonevans at gmail.com>
wrote:

> Hi there
> Have just used Valentina Studio's import from csv wizard to import a 9MB
> csv file with 30,000 rows into a new table. It took about one hour.
> This seems slow to me. Opening the same csv in Excel takes seconds.
> Importing into MySQL is quick also.
> 1) What are your experiences of importing medium-large csv files into
> Valentina?
> 2) Any tips for speeding up the process?
> 3) My aspiration is to import much larger csv files with 1 million + rows.
> How realistic is that?
> Thanks for your help.
> Jon
>
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-studio/attachments/20141010/d6ae1649/attachment.html>


More information about the Valentina-studio mailing list