Speed slowdown issue while opening edit page in model

[BrikozO]

Checklist

• The bug is reproducible against the latest release or master.
• There are no similar issues or pull requests to fix it yet.

Describe the bug

Hello! I am using sqladmin and there is a problem: when i am creating model which linked with other model (many to many, many to one, doesn't matter) and create more than 1000 objects in DB, speed of page loading extremely go down.

Steps to reproduce the bug

For example, i have table users:

class User(SQLAlchemyBaseUserTableUUID, Base):
    roles: Mapped[list['Role']] = relationship(secondary='user_role', back_populates='users')

Roles and user_role (many to many):

class Role(Base):
    name: Mapped[str] = mapped_column(unique=True, nullable=False)

    users: Mapped[list['User']] = relationship(secondary='user_role', back_populates='roles')

    def __str__(self):
        return self.name


user_role = Table(
    'user_role',
    EmptyBase.metadata,
    Column('user_id', ForeignKey('user.id'), primary_key=True),
    Column('role_id', ForeignKey('role.id'), primary_key=True),
)

I create 3000 roles to test it and link with one user. Try to open page and then - it loads very very slow :(

Expected behavior

No response

Actual behavior

No response

Debugging material

No response

Environment

Python 3.12.12

sqladmin 0.21.0 (i am trying to use 0.23 but there is a problem with uuid, i don't think that there is a big difference for my case)

Additional context

Is there any options to optimize some code inside library? I saw same question in another issue: #704

But it's very old, and there are no any status update yet

[mmzeynalli]

Can you please share your admin model code?

[BrikozO]

class UserAdmin(ModelView, model=User):
    column_list = [User.id, User.email]
    page_size = 50

    form_ajax_refs = {
        "roles": {
            "fields": ("name",),
            "order_by": "id",
            "page_size": 20,
        }
    }

I am trying to provide page size param (claude says that shall helps :)) but nothing changes

Oh, i think i need to provide more details - i need customization on this page (add, delete roles, etc) and provide ajax refs param for this

[BrikozO]

Also, there is another bug - if i am trying to delete or add something - this message appears:

[arturbent0]

Hi, i would like to help with this issue if that's okay @mmzeynalli

[mmzeynalli]

@arturbent0 sure, go ahead, it is all yours. Do please let us know if you abandon working on it, so we work on it ourselves. Thanks!