Home >Backend Development >Python Tutorial >Adding new columns - lowCalAlt_update5

Adding new columns - lowCalAlt_update5

Patricia Arquette
Patricia ArquetteOriginal
2024-11-30 05:43:15212browse

Adding new columns - lowCalAlt_update5

Adding new columns - lowCalAlt_update5

While I still needed information about the missing columns in the CSV files found in the NutritionIX DB, I went ahead and added the columns I had access to. These included brand_name, ss_metric_qty, ss_metric_unit, item_id. However, the insertion process took a lot longer than it should have. I have some theories:

  1. The insertion is being done in a Python for-loop. This might be causing a lot of overhead.
  2. I am adding one row at a time instead of all at once
  3. Indexing in PostgreSQL

Please let me know what you think. I will be doing my own research with another python script.

The above is the detailed content of Adding new columns - lowCalAlt_update5. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn