FastAPI + Cockroachdb gives me slow requests

[luna215]

Hi,

I am using FastAPI and connecting to cockroachdb (which I am using the free plan) and my request from the API anytime I query the cockroachdb is extremely slow. My cluster is running on us-west-2 and I am located in California. I don't have the FastAPI deployed anywhere and just running it locally on my laptop which is framework laptop running ubuntu 24.04.

I also believe I have a lot of data for my queries to be this slow that some of my endpoints take about ~20s to get a response.

When I connect to a local postgreql on my machine, my requests take ~2s.

I think this is a huge difference and want to know if I am doing something wrong in how I am connecting to cockroachdb, or is this due to it being the free plan?

This is how I connecting to the database in my code

import os

from sqlalchemy import create_engine as sqlalc_create_engine
from sqlalchemy.pool import NullPool
from sqlalchemy.orm import sessionmaker

def create_engine(for_celery=False):
    certificate_path = os.path.join(os.environ["WORKDIR"], os.environ["ENVIRONMENT"] + '.crt')
    db_url_with_ssl = f"{os.environ['DATABASE_URL']}&sslrootcert={certificate_path}"
    kwargs = {
        "pool_pre_ping": True
    }

    if for_celery:
        kwargs["poolclass"] = NullPool
    engine = sqlalc_create_engine(db_url_with_ssl, **kwargs)
    return engine

def create_session(engine):
    session = sessionmaker(bind=engine)
    return session

engine = create_engine()
Session = create_session(engine)

Any help or guidance is greatly appreciated here.