search

openego / ego.powerflow

A power flow app to solve AC and DC powerflow problems using PyPSA
GNU Affero General Public License v3.0
5 stars 3 forks source link

Improve slicing of PQ tables #11

Closed mariusves closed 7 years ago

mariusves commented 7 years ago

So far, the whole PQ-set is imported first and afterwards the uneeded part of the array is being deleted. This can lead to very long loading times and (temporarily) high memory usage.

Therefore, the slicing of the PQ-array shall be performed prior or during the importing process using sqlalchemy. See: http://docs.sqlalchemy.org/en/rel_0_9/dialects/postgresql.html#sqlalchemy.dialects.postgresql.ARRAY

mariusves commented 7 years ago

Added a first improvement of the PQ slicer, reduced loading times significantly.

mariusves commented 7 years ago

Closed, since so far no further improvement is needed.