which are the factors that affect the time for conducting the importing process?

Question

When I impor a database usually takes 20-24 hours, my question is, does anybody know which are the factors that affect the time for conducting the importing process? Because I would be interested in reducing this time. Thanks in advance.

Answer 1

First, if you do not want to merge databases but just import/share a database (via a *.zolca file) you should use the `Backup` and `Restore` functions from the database menu. These functions should be fast.

If you want to merge databases, you should import the smaller database into the bigger database. A database is smaller and thus faster for the import when it has less processes and when the process are small (so you would import a unit process database into a system process database.)

Comments

Good Morning Dear msrocka:


Thank you very much for your reply, the problem might be related to other issues because I followed the backup/restore procedure as you suggest when I import a database.
Regarding the process to merge two databases it is true, the smaller one is imported faster than the bigger one. The problem comes with the bigger one. I have used both procedures, unfortunately, at least with my laptop the complete processes take 20-24 hours.
If you have another suggestion, I will appreciate it.

---

20-24 hours is really long ... which databases do you combine and in which order?

---

Hello Dear msrocka:

I need to create a zolca file, which includes the providers in all the processes considered in the product system. The process works but just after 20-24 hours. I realized it takes that long because at the beginning, I stopped the process after 8 hours-10 hours, then I tried to leave it longer than that and it worked, the complete database (including providers and product systems) is finished after 20-24 hours. I developed the database using ecoinvent 3.4 and open lca 1.6.3. Here is the procedure that I follow:

1) Create a new database
2) Backup the database that I want to import (as zolca file (2-3 hours))
3) Restore the file  (zolca file created in the previous step) in the new database
4) Wait until the process is complete (20-24 hours)
I also follow this procedure with the same database but using open lca 1.9, however, I did not get any improvement. Some colleagues also have the same issue, but they have not left the processes longer than 10 hours. If you have an advice it would be really appreciated it.