Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Performance Delimiter Vs. Fcsvparser

 

Hi 

 

I would like to know, why would fcsvparser taking more time to complete compared to delimiter as below:

 

dbadmin=> copy fs.columnar_tbl1 from '/home/shared/300MB.csv' delimiter ',' skip 1;
Rows Loaded
-------------
261607
(1 row)

Time: First fetch (1 row): 26819.648 ms.

 

dbadmin=> copy fs.columnar_tbl2 from '/home/shared/300MB.csv' parser fcsvparser();
Rows Loaded
-------------
261607
(1 row)

Time: First fetch (1 row): 58866.387 ms.

 

 

 

Many Thanks

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.