jrgemignani commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1779709262
@I33Buckler Your `create_stop_times` function is **O(N^3)** and that is inside a doubly nested loop that also does **SELECT**s from tables for each level. This can lead to as much as **O(N^5)** (possibly more) runtime for the whole process. Even without considering the 2 external loops which could be **O(N^2)**, just the **O(N^3)** for `create_stop_times` is bad enough to make what you are doing only viable for small datasets. You need to rewrite your code to make it more efficient. At this moment, this does not appear to be an Apache AGE issue. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
