csv import slow

[Jonathan Evans]

Yes that's right.

On Fri, Oct 10, 2014 at 6:37 AM, Sergey Pashkov <
sergey_pashkov at valentina-db.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/6d6cd285/attachment.html>