9 replies

Perf difference on prepared statements

Hey, I made the original post on the forum and just want to add some additional details:
I think my assumption that it wasn't caching at all was incorrect. The responses just seem to be a lot slower...

For example my worker with:

await sql`select 'hello' as "message";`

await sql`select 'hello' as "message";`

usually responds in 20-50ms whereas:

await sql`select ${'hello'} as "message";`

await sql`select ${'hello'} as "message";`

usually responds in 200-300ms.

The reason I say my assumption was incorrect is the cached percentage in my hyperdrive dashboard is now showing a high percentage, so it must be something to do with how the caching is working.

I've tried with both

prepare: false

prepare: false

and

prepare: true

prepare: true

and neither seem to make a big difference to the times...

Any help here would be appreciated! My app is able to cache a large percentage of the data, so I could see some serious performance gains if I can work out what's wrong.

Cloudflare Developers•11mo ago•

9 replies

alaister

Perf difference on prepared statements

await sql`select 'hello' as "message";`

await sql`select 'hello' as "message";`

usually responds in 20-50ms whereas:

await sql`select ${'hello'} as "message";`

await sql`select ${'hello'} as "message";`

prepare: false

prepare: false

and

prepare: true

prepare: true

Perf difference on prepared statements

Similar Threads

Perf difference on prepared statements

Similar Threads

Similar Threads

Similar Threads