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)")

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 941 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.