Drizzle Serverless performance

You can get immense benefits with serverless functions like AWS lambdas or Vercel Server functions(they're AWS lambdas based), since they can live up to 15mins and reuse both database connections and prepared statements
On the other hand edge functions tend to clean up straight after they're invoked which leads to little to no perf benefits

To reuse your database connection and prepared statements - you just have to declare them outside of handler scope

const databaseConnection = ...;
const db = drizzle(databaseConnection);
const prepared = db.select().from(...).prepare();
 
// AWS handler
export const handler = async (event: APIGatewayProxyEvent) => {
  return prepared.execute();
}