database - Android SQLite: Which query ("query" or "rawQuery") is faster?

Question

I am developing one android database application . I just want to know which code execute faster and what is the difference between them?

Query - 1 =

db.rawQuery("select * from user_table where user_id =" + userId, null);

Query - 2 =

db.query(USER_TABLE_NAME, ALL_COLUMNS, "user_id = " + userId, null, null, null, null);

Answer 1

Use query.

Android precompile queries and using too many different raw queries may cause performance issue.

Use rawQuery only when absolutely needed.

Also, both your example have a MAJOR security issue of SQL Injection.

You should sanitize the userId.

The most obvious thing to do is let Android do it by using:

db.query(USER_TABLE_NAME, ALL_COLUMNS, "user_id = ?", new String[] {userId}, null, null, null);