DEV Community

Kazi Priom
Kazi Priom

Posted on

Adding new columns - lowCalAlt_update5

Image description

Image description

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.

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more