Skip to content

Performance issues on related-data queries #585

@ozziest

Description

@ozziest

Null values

This is an example relation query:

select * from `users` where `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[ null, null, null, null, null, null, null, 287,  285, 286]

As you can see, sending null values doesn't make any sense. You can not create a relationship between two tables by using null.

Duplicated values

select * from `users` where `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[ null, null, null, null, null, null, null, 285,  285, 285]

On the other hand, there is no need to use duplicated values in parameters.

Metadata

Metadata

Assignees

Labels

next-releaseThe feature will be released in the next releaseperformancePerformance related issuesversion-patchIt is just a patch for the current version. It is not a new feature, nor a breaking change.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions