CD
Cloudflare Developers•3d ago
jepcd

Hi folks, I'm testing out hyperdrive (no

Hi folks, I'm testing out hyperdrive (no cache) and am noticing almost 3x higher query latencies than without. Note: Worker in YYZ connecting to a planetscale db in ca-central-1 wrote up a quick little benchmark (source) and 
{
  "runs": 10,
  "results": {
    "directWithPgbouncer": {
      "averageQueryTime": 10.45,
      "averageConnectionTime": 115,
      "averageTeardownTime": 10.2,
      "averageTotalTime": 229.7
    },
    "hyperdriveWithPgbouncer": {
      "averageQueryTime": 28.2,
      "averageConnectionTime": 1.8,
      "averageTeardownTime": 0,
      "averageTotalTime": 283.8
    }
  }
}
{
  "runs": 10,
  "results": {
    "directWithPgbouncer": {
      "averageQueryTime": 10.45,
      "averageConnectionTime": 115,
      "averageTeardownTime": 10.2,
      "averageTotalTime": 229.7
    },
    "hyperdriveWithPgbouncer": {
      "averageQueryTime": 28.2,
      "averageConnectionTime": 1.8,
      "averageTeardownTime": 0,
      "averageTotalTime": 283.8
    }
  }
}
effectively means that any worker that makes more than ~5 queries would actually be slower with hyperdrive. 10 vs 30ms is not a big deal either way, but I was surprised to see it increase. Is this expected? 👀
3 Replies
knickish
knickish•3d ago
There is a known issue related to Hyperdrive placements around YYZ. We're planning to fix this before the end of the year.
jepcd
jepcdOP•3d ago
gotcha, yeah seemed like it. will keep an eye out for the fix. Thanks! fwiw, I'm also seeing +20ms on queries from other canadian colos like YVR and YYC
AJR
AJR•3d ago
Around YYZ == "in canada" for these purposes. You're almost certainly getting bounced down to ORD or IAD for your connection pool

Did you find this page helpful?