more SQLs then expected

[tasiotas]

more SQLs then expected

[bellini666]

Hey @tasiotas ,

I think that it is because the name products is not matching the django model name, so the optimizer doesn't know where to find.

You can try 2 changes in there:

1. Define a related_name="products on the foreignkey so that it is accessible by self.products.all() instead of self.product_set.all(). Since it matches the name of the field it should work

2. If you don't want to set a related_name, try to define the field as:

    @gql.django.connection(name="products")
    def product_set(self) -> List["ProductType"]:
        return self.product_set.all()

Let me know if any of those solutions works for you. Otherwise I might need some more info to understand what might be going on there

[tasiotas]

unfortunately both solutions didn't work. Will try to get you a repro.

Thanks!

[bellini666]

unfortunately both solutions didn't work. Will try to get you a repro.

Thanks!

A repro will help a lot to understand how to properly optimize this :)

[tasiotas]

got the repro. Im new to Poetry, didn't know how to update this lib to latest, so its at 2.4.0
https://github.com/tasiotas/strawberry_debug

without optimizer I have 3 queries, with optimizer I get 6.
Just create some Project and Milestone objects and run this query:

query MyQuery {
  project(name: "one") {
    milestones {
      edges {
        node {
          name
        }
      }
    }
  }
}

[bellini666]

Hey @tasiotas ,

I just released a new version, which has a major refactoring of the relay integration by using the official one instead.

Could you check if your issue still happens in that version? I think some of the changes I've made should have fixed this.

[tasiotas]

unfortunately, its still the same behavior in v3