I am testing the capabilities of the device -- to show the customer the size of data that can be stored inside the device, how fast it can be retrieved, how fast the search works, etc.

I am using my content provider to access the `product` database table with few columns. I have already moved the code to the content provider to avoid the extra communication when inserting the test records. The following code is called via menu from an activity to fill the table with the test content

```
Uri uri = Uri.parse(DemoContentProvider.PRODUCTS_CONTENT_URI + "/insertdemo");
getContentResolver().insert(uri, null);

```

The URI is recognized in the `.insert` method of the content provider and the following private method (of the same content provider) is called to fill the table (notice the 100 thousands of items):

```
private void insertDemoProducts() {
    for (int i = 1; i <= 100000; ++i) {
        String id = Integer.toString(i);
        insertProduct(id, "Test product " + id, "100", "75.50", "70.27");
    }
}

```

The inner `insertProduct()` looks like that:

```
private void insertProduct(String code, String name, String stock,
                           String price,  String listprice) {
    SQLiteDatabase sqlDB = database.getWritableDatabase();
    ContentValues values = new ContentValues();

    values.put(ProductTable.COLUMN_CODE, code);
    values.put(ProductTable.COLUMN_NAME, name);
    values.put(ProductTable.COLUMN_STOCK, stock);
    values.put(ProductTable.COLUMN_PRICE, price);
    values.put(ProductTable.COLUMN_LISTPRICE, listprice);

    sqlDB.insert(ProductTable.TABLE_PRODUCT, null, values);
}

```

It works, but it takes *"forever"*. How can I make it faster? What is the fastest method you know to fill the table?

Just some numbers to consider: 1000 items takes about 20 seconds to be created.