Slow Response Time for D1 Select Request

T

toadfans•8/26/24, 3:49 AM

I am experiencing performance issues with a D1 select request in my application. I implemented a simple D1 select demo using Hono, and I noticed that while the SQL execution time is quite fast (0.1269 ms), the overall request cost is significantly slower, taking 519 ms.

Here’s the code snippet I’m using:

export const wellKnownApp = new Hono<CloudlinkHonoEnv>().get('/readyz', async (c) => {
  const startTime = new Date();
  const select = await c.env.DB_SOL_CORE.prepare('SELECT 1;').all();
  const cost = new Date().getTime() - startTime.getTime();

  return c.json({
    select,
    cost
  });
});

export const wellKnownApp = new Hono<CloudlinkHonoEnv>().get('/readyz', async (c) => {
  const startTime = new Date();
  const select = await c.env.DB_SOL_CORE.prepare('SELECT 1;').all();
  const cost = new Date().getTime() - startTime.getTime();

  return c.json({
    select,
    cost
  });
});

export const wellKnownApp = new Hono<CloudlinkHonoEnv>().get('/readyz', async (c) => {
  const startTime = new Date();
  const select = await c.env.DB_SOL_CORE.prepare('SELECT 1;').all();
  const cost = new Date().getTime() - startTime.getTime();

  return c.json({
    select,
    cost
  });
});

export const wellKnownApp = new Hono<CloudlinkHonoEnv>().get('/readyz', async (c) => {
  const startTime = new Date();
  const select = await c.env.DB_SOL_CORE.prepare('SELECT 1;').all();
  const cost = new Date().getTime() - startTime.getTime();

  return c.json({
    select,
    cost
  });
});

The response data shows the following:

{
  "select": {
    "success": true,
    "meta": {
      "served_by": "v3-prod",
      "duration": 0.1269, // in milliseconds
      "changes": 0,
      "last_row_id": 0,
      "changed_db": false,
      "size_after": 1511424,
      "rows_read": 0,
      "rows_written": 0
    },
    "results": [
      {
        "1": 1
      }
    ]
  },
  "cost": 519 // in milliseconds
}

{
  "select": {
    "success": true,
    "meta": {
      "served_by": "v3-prod",
      "duration": 0.1269, // in milliseconds
      "changes": 0,
      "last_row_id": 0,
      "changed_db": false,
      "size_after": 1511424,
      "rows_read": 0,
      "rows_written": 0
    },
    "results": [
      {
        "1": 1
      }
    ]
  },
  "cost": 519 // in milliseconds
}

{
  "select": {
    "success": true,
    "meta": {
      "served_by": "v3-prod",
      "duration": 0.1269, // in milliseconds
      "changes": 0,
      "last_row_id": 0,
      "changed_db": false,
      "size_after": 1511424,
      "rows_read": 0,
      "rows_written": 0
    },
    "results": [
      {
        "1": 1
      }
    ]
  },
  "cost": 519 // in milliseconds
}

{
  "select": {
    "success": true,
    "meta": {
      "served_by": "v3-prod",
      "duration": 0.1269, // in milliseconds
      "changes": 0,
      "last_row_id": 0,
      "changed_db": false,
      "size_after": 1511424,
      "rows_read": 0,
      "rows_written": 0
    },
    "results": [
      {
        "1": 1
      }
    ]
  },
  "cost": 519 // in milliseconds
}

I have enabled

smart placement

smart placement

smart placement

smart placement in the worker.

Account ID: 75d8d68ecf8f9e8155f1ccc7dad82e00
Database ID: 4a7faf39-103c-48ea-af9d-501b4e58b55f
CF-Ray: 8b90c47e89218529-HKG

M

Max (@rozenmd)•8/26/24, 12:24 PM

do you mind linking me your demo's URL (or a repo with a repro)? would help us trace this

MMax (@rozenmd)do you mind linking me your demo's URL (or a repo with a repro)? would help us t...

T

toadfans•8/27/24, 8:19 AM

Sure, here is the minimal source code of our app:

https://github.com/toadfanszz/reproduce-d1-latency

And the production api in our app:

https://cloud-staging.turbx.io/.well-known/readyz

GitHub

GitHub - toadfanszz/reproduce-d1-latency

Contribute to toadfanszz/reproduce-d1-latency development by creating an account on GitHub.

M

Max (@rozenmd)•8/27/24, 9:44 AM

thanks!

Slow Response Time for D1 Select Request

Similar Threads

Similar Threads

Similar Threads