Pentium10 Pentium10 - 1 year ago 97
Android Question

Android record exists() in database?

I am looking to the fastest and the correct way to check if a record exists in the database:

public boolean Exists(String _id) {
Cursor c=db.query(TABLENAME(), new String[] {"1"}, "_ID="+_id, null, null, null, null);
if (!c.equals(null))
return c.moveToFirst();
return false;

Do you see any problem with it?

Answer Source

Consider that mDb is your SqlLiteDatabase class

public boolean Exists(String _id) {
   Cursor cursor = mDb.rawQuery("select 1 from yourTable where _id=%s", 
        new String[] { _id });
   boolean exists = (cursor.getCount() > 0);
   return exists;
  • I keep your parameter _id as a String but I think it should be a Long.
  • select 1 is more fast than select columnName because the process doesn't need to retrieve all values from the table in the select clause.
  • you can put the string select 1 from... in a static final constant to be even faster.
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download