Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Оптимизация ORM PostgresDataService #39

Open
PashaMasalkin opened this issue Feb 5, 2019 · 0 comments
Open

Оптимизация ORM PostgresDataService #39

PashaMasalkin opened this issue Feb 5, 2019 · 0 comments
Labels
enhancement
Milestone
7.0

Comments

@PashaMasalkin
Copy link
Contributor

PashaMasalkin commented Feb 5, 2019 •
edited
Loading

Цель

Оптимизация запросов ORM PostgresDataService

Функциональные требования

При выполнении запроса к таблицам
default

Postgres берёт всю таблицу House, join'ит её со всей таблицей Client, сортирует по полю Clien.Surname, накладывает Limit.
Оптимально же было отсортировать по Client.Surname, применить Limit, заjoin'ить с таблицей House.

Исходный код

Проект на GitHub: https://github.com/Flexberry/NewPlatform.Flexberry.ORM
Ветка: develop

Полезные ссылки, скриншоты

g=posts&m=13295#post13295
@PashaMasalkin PashaMasalkin changed the title Оптимизация ORM Оптимизация ORM PostgresDataService Feb 5, 2019
@bratchikov bratchikov added this to the 6.0 milestone Oct 27, 2019
@bratchikov bratchikov modified the milestones: 6.0, 7.0 Aug 9, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
7.0
Development

No branches or pull requests
2 participants
@bratchikov @PashaMasalkin