Slide 15
Slide 15 text
D
1
15
export const getPresentation = async (DB: D1Database, id: string):
Promise => {
await DB.prepare('DELETE FROM Presentations').run();
const startTimePut = performance.now();
for (let i = 0; i < 100; i++) {
await DB.prepare('INSERT INTO Presentations (id) VALUES (?)’)
.bind(i.toString()).run();
}
const endTimePut = performance.now();
let putTime = endTimePut - startTimePut;
for (let i = 0; i < 100; i++) {
const value = await DB.prepare('SELECT id FROM Presentations WHERE id = ?')
.bind(i.toString())
.first();
}
const endTimeGet = performance.now();
const getTime = endTimeGet - endTimePut;
const newPresentation: Presentation = {
name: 'putTime: ' + putTime + ' - getTime: ' + getTime,
};
return newPresentation;
};