Django app taking too long to upload data into postgresql database

38 views

Skip to first unread message

Guillermo Yáñez Feliú

unread,

Mar 15, 2019, 2:45:52 PM3/15/19

to Django developers (Contributions to Django itself)

Hello,

I’m working in a project that consists in converting a local postgresql database (that uses sqlalchemy as the ORM) into a web application, in which I upload excel sheets, read them, do some small cleaning and then upload selected data into a postgresql database using Django’s ORM. The idea is to have the data in a server instead of in every user’s machine.

Everything is ok but data loading is taking too long since, I think, I am using panda’s dataframes to easily structure, read and save the data. In the local version of the library, I used lists and was way faster.

I don’t if it’s related to Sqlalchemy, Django, lists or dataframes. Any suggestions on how to read spreadsheets data and upload it into a postgresql database using Django?

Thanks a lot.

Adam Johnson

unread,

Mar 15, 2019, 3:16:16 PM3/15/19

to django-d...@googlegroups.com

This mailing list is for the development of Django itself, not for support using Django. Please use the django-users mailing list for that, or IRC #django on freenode, or a site like Stack Overflow.

--
You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-develop...@googlegroups.com.
To post to this group, send email to django-d...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-developers.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/b8339488-0ba5-4f76-9212-be745c07ba54%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.