I am using sqlite in monodroid - I am doing a bulk insert from an external
source

I have read there is no inbuilt way of importing a whole xml file into the
sqlite database

But one can optimise a loop which inserts line by line by using
connection.BeginTransation()

Which is supposed to delay the commit until the loop is over then use
setTransationSuccessful()

However in the monodroid library mono.data.sqlite.dll does not seem to
contain the 'setTransactionSuccessful' method

Nor themethod endTransation())

Given the insert loop below can anyone tell me if I am barking up the wrong
tree trying to stall the committing of inserts in this way?  Is there any
other way to speed up a large insert loop like this?

If there is a method in Mono.Data.Sqlite for 'begintransaction()' where is
the obverse 'endtransation' or 'settransationsuccessful()'

As you can see from code below I have also tried various forms of commit.

//==================================

// connection.BeginTransaction();            

// connection is a straightforward sqlite connection the above code line is
available in monodroid

// however without some commit or endtransation nothing gets written to the
database

                for (int go = 0; go < selstr2.Count; go++)

                   {

 

                        //cc2 is the connection.command

                      cc2.CommandText = selstr2[go];   //array selstr
contains insert statements

                      cc2.ExecuteNonQuery();

                   }

               //connection.setTransationSuccessful();

               //cc2.Transaction.Commit();

     connection.Close();

//===========================================

 

I'd be grateful for any help at all - 

John Murray

 

 

 

_______________________________________________
Monodroid mailing list
Monodroid@lists.ximian.com

UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid

Reply via email to