Sleep caused by SQLite during execution

Is there a similar SQL expression that sleeps like MS SQL WAITFOR sqlite?

Or, is there a way to make sqlite SQL queries run for a long time without adding many rows to the database?

This is a test, so you need to use the db driver to run the query.

SQLite has no built-in functions, but in most languages, you can create user-defined functions:

import sqlite3
import time
< br />con = sqlite3.connect(":memory:")
con.create_function("sleep", 1, time.sleep)
c = con.cursor()
c. execute("SELECT sleep(1.23)")

Is there a similar SQL expression to sleep like MS SQL WAITFOR sqlite?

Or, is there a way to make sqlite SQL queries run for a long time without adding many rows to the database?

This is a test, so you need to use the db driver to run the query.

SQLite has no built-in functions, but in most languages , You can create user-defined functions:

import sqlite3
import time

con = sqlite3.connect(":memory :")
con.create_function("sleep", 1, time.sleep)
c = con.cursor()
c.execute("SELECT sleep(1.23)")

Leave a Comment

Your email address will not be published.