ricomaster9000 / LightWeight_Java_PSQL_Framework

Lightweight Java PSQL Database interaction framework to be used effectively on micro-apps or lambdas running on Java, but can be used for traditional apps as well
MIT License
2 stars 0 forks source link

Optimisations (better code, caching) - v1.6.* #74

Open ricomaster9000 opened 1 year ago

ricomaster9000 commented 1 year ago

after fully adding db relation annotation support for one-to-one, one-to-many, many-to-one and adding automatic cascading features such as delete sub relational entities on delete etc. there has been quite a big drop in performance (30%-50%+-).

Apply more caching (but keep it light as in don't hog memory with cache) Refactor code (there has to be one or two places one can still optimise code) Add more unit tests and one or two performance based unit tests, refactor unit tests to be more organized&structured (the time has come)

ricomaster9000 commented 1 year ago

https://github.com/ricomaster9000/LightWeight_Java_PSQL_Framework/pull/81

ricomaster9000 commented 1 year ago

based on unit testing, update query operation methods take a bit longer than they should, must look into this.

Performance has been slightly increased

ricomaster9000 commented 7 months ago

Performance has again been slightly increased because of more efficient usage of HashMap and (I think) because of using the latest available versions of core dependencies https://github.com/ricomaster9000/LightWeight_Java_PSQL_Framework/pull/83 (version 1.5.0)

ricomaster9000 commented 7 months ago

update operations is the next focus, these seem to take the longest in time to perform when having a lot of relationships