insert a lot of data into sqlite in android
currently, I have to insert more than 10 billions data into my android at a time. However, the problem of out of memory will crash the program. The sqlite insert test is quite simple. Just using the for loop to produce the sql insert command and wrqpped by "begin" and "commit". 

        private ArrayList<String> sqlInsertCmd = new ArrayList<String>();
        int QUERIES_TIMES = 10000000;
        private void CreateInsertQueries()
        {
            Random localRandom = new Random();
            int i = 0;
            while (i < QUERIES_TIMES)
            {
                int j = localRandom.nextInt(100000);
                sqlInsertCmd.add("insert into " + TABLE + " (a,b,c) values (" + i + "," + 
                j + ",'" + String.valueOf(j) + "')");
                ++i;
            }
        }

        Then..

        mDB.beginTransaction();
        for (int i=0; i<this.QUERIES_TIMES; i++)
        {
            mDB.execSQL(sqlInsertCmd.get(i));
        }
        mDB.setTransactionSuccessful();
        mDB.endTransaction();



Are there any ideas to avoid the out of memory?
insert a lot of data into sqlite in android
===

currently, I have to insert more than 10 billions data into my android at a time. However, the problem of out of memory will crash the program. The sqlite insert test is quite simple. Just using the for loop to produce the sql insert command and wrqpped by "begin" and "commit". 

        private ArrayList<String> sqlInsertCmd = new ArrayList<String>();
        int QUERIES_TIMES = 10000000;
        private void CreateInsertQueries()
        {
            Random localRandom = new Random();
            int i = 0;
            while (i < QUERIES_TIMES)
            {
                int j = localRandom.nextInt(100000);
                sqlInsertCmd.add("insert into " + TABLE + " (a,b,c) values (" + i + "," + 
                j + ",'" + String.valueOf(j) + "')");
                ++i;
            }
        }

        Then..

        mDB.beginTransaction();
        for (int i=0; i<this.QUERIES_TIMES; i++)
        {
            mDB.execSQL(sqlInsertCmd.get(i));
        }
        mDB.setTransactionSuccessful();
        mDB.endTransaction();



Are there any ideas to avoid the out of memory?