IT. Expert System.

public final class SQLiteDebug
extends Object

• Nested Class Summary

  Nested Classes

  Modifier and Type	Class and Description
  static class	SQLiteDebug.DbStats contains statistics about a database
  static class	SQLiteDebug.PagerStats Contains statistics about the active pagers in the current process.

• Field Summary

  Fields

  Modifier and Type	Field and Description
  static boolean	DEBUG_LOG_SLOW_QUERIES True to enable database performance testing instrumentation.
  static boolean	DEBUG_SQL_LOG Controls the printing of informational SQL log messages.
  static boolean	DEBUG_SQL_STATEMENTS Controls the printing of SQL statements as they are executed.
  static boolean	DEBUG_SQL_TIME Controls the printing of wall-clock time taken to execute SQL statements as they are executed.

• Method Summary

  Methods

  Modifier and Type	Method and Description
  static void	dump(Printer printer, String[] args) Dumps detailed information about all databases used by the process.
  static SQLiteDebug.PagerStats	getDatabaseInfo() return all pager and database stats for the current process.
  static boolean	shouldLogSlowQuery(long elapsedTimeMillis) Determines whether a query should be logged.

  • Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

• Field Detail

  • DEBUG_SQL_LOG

    public static final boolean DEBUG_SQL_LOG

    Controls the printing of informational SQL log messages. Enable using "adb shell setprop log.tag.SQLiteLog VERBOSE".

  • DEBUG_SQL_STATEMENTS

    public static final boolean DEBUG_SQL_STATEMENTS

    Controls the printing of SQL statements as they are executed. Enable using "adb shell setprop log.tag.SQLiteStatements VERBOSE".

  • DEBUG_SQL_TIME

    public static final boolean DEBUG_SQL_TIME

    Controls the printing of wall-clock time taken to execute SQL statements as they are executed. Enable using "adb shell setprop log.tag.SQLiteTime VERBOSE".

  • DEBUG_LOG_SLOW_QUERIES

    public static final boolean DEBUG_LOG_SLOW_QUERIES

    True to enable database performance testing instrumentation.

• Method Detail

  • shouldLogSlowQuery

    public static final boolean shouldLogSlowQuery(long elapsedTimeMillis)

    Determines whether a query should be logged. Reads the "db.log.slow_query_threshold" system property, which can be changed by the user at any time. If the value is zero, then all queries will be considered slow. If the value does not exist or is negative, then no queries will be considered slow. This value can be changed dynamically while the system is running. For example, "adb shell setprop db.log.slow_query_threshold 200" will log all queries that take 200ms or longer to run.

  • getDatabaseInfo

    public static SQLiteDebug.PagerStats getDatabaseInfo()

    return all pager and database stats for the current process.

    Returns:

    SQLiteDebug.PagerStats

  • dump

    public static void dump(Printer printer,
            String[] args)

    Dumps detailed information about all databases used by the process.

    Parameters:

    printer - The printer for dumping database state.

    args - Command-line arguments supplied to dumpsys dbinfo