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.
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 timecon = sqlite3.connect(":memory :")
con.create_function("sleep", 1, time.sleep)
c = con.cursor()
c.execute("SELECT sleep(1.23)") pre>