Should I index DateTime in SQLITE?

By Sqlite

Is it possible to find a date faster> an appointment?
Generally yes, but please remember that SQLite uses only one index per table (except for the OR clause ). Always use EXPLAIN to understand how the engine handles a given query.

Is it possible to find a date faster> an appointment?

Generally speaking, yes, but please remember that SQLite uses only one index per table (except the OR clause). Always use EXPLAIN To understand how the engine handles a given query.

, , ,

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 = 946 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.