typeorm: RelationId is too slow

Issue type:

[ ] question [x] bug report [ ] feature request [ ] documentation issue

Database system/driver:

[ ] cordova [ ] mongodb [ ] mssql [x] mysql / mariadb [ ] oracle [ ] postgres [ ] cockroachdb [ ] sqlite [ ] sqljs [ ] react-native [ ] expo

TypeORM version:

[x] latest [ ] @next [ ] 0.x.x (or put your version here)

Steps to reproduce or a small repository showing the problem: @RelationId() is too slow on big amount of related records (1k+ rows), see test in the PR.

About this issue

Original URL
State: closed
Created 4 years ago
Reactions: 1
Comments: 16 (16 by maintainers)

Commits related to this issue

fix: performance issues of `RelationId`. (#7318) * test: relationId is too slow * perf: RelationId is too slow When we join a lot of relations we can get 1k+ records from db even it is only 10 ... — committed to typeorm/typeorm by satanTime 3 years ago
Chore/flowaccount update (#2) * docs: fix small typo on package.json script example (#7408) Add missing colon in JSON property at `package.json` `"script"` example * feat: output Javascript Mig... — committed to flowaccount/typeorm by gogotaro 3 years ago

Most upvoted comments

Btw, if you need this sooner than later, you can point at your own version of Typeorm in a Git repo:

npm install git://github.com/YOURGITUSERNAME/typeorm.git#BRANCH_OR_COMMIT_HASH --save

On Apr 2, 2020, at 04:44, Michael G. notifications@github.com wrote:

Hi @pleerock, any news? I need this fix for out prod.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

dhritzkiv on Apr 2, 2020

That is exactly why I remind them time to time about the issues.

satanTime on Jan 30, 2021