SQL model request is way too slow

[Kamigaku]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

import cProfile

from isomodels.models import NotableAccount
from sqlalchemy import URL, create_engine
from sqlmodel import Session, select

if __name__ == '__main__':
    connection_string = URL.create(drivername="mysql+pymysql",
                                   username="root",
                                   password="xxxxxx",
                                   host="localhost",
                                   port=3306,
                                   database="xxxxxx")
    engine = create_engine(connection_string)
    with Session(engine) as session:
        pr2 = cProfile.Profile()
        pr2.enable()
        all_models = session.exec(select(NotableAccount)).all()
        pr2.disable()
        pr2.print_stats(sort="cumtime")
        print(len(all_models))


class NotableAccount(SQLModel, table=True):
    twitter_id: str
    handle: str  # @ttv_kamigaku
    username: str  # Kamigaku
    ranking: int = Field(sa_column=Column(SMALLINT))
    emoji: Optional[str]

    # region Foreign keys
    category_id: int = Field(foreign_key="notablecategory.id")
    # endregion Foreign keys

    id: Optional[int] = Field(default=None, primary_key=True)

    # region Relationship (access to the foreign key model)
    category: NotableCategory = Relationship(back_populates="members")
    followings: List["NotableFollowing"] = Relationship(sa_relationship_kwargs={"cascade": "delete"},
                                                        back_populates="notable_account")
    # endregion Relationship (access to the foreign key model)

Description

Hi everyone,

I'm having some difficulty understanding with one of my SQL request as seen above because it is taking me way too much time when it shouldn't.
This SQL request take me 500ms when the database only have 2500 lines.
As you can see also, the model doesn't have a lot of complicated stuff, the only thing that could make it difficult is the "emoji" field which is a litteral emoji in the database.

I've tried to do the same request with the mysql_connector library and it took me 15ms.

I've linked some files that displays the cProfile results.
!

cProfile when running with SQLmodel
image

cProfile when running with mysql_connector

Database extract

Any idea what could be the issue?
Thanks!

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.16

Python Version

3.11

Additional Context

No response