Using Transaction helpful in Android in my scenario?
<p>I am performing two functionalities on my Application </p>

<p>i>Save data (Insertion of data which is quite large)
ii> Data Deletion</p>

<p>I am using SQLite &amp; creating a single database object &amp; referencing it to perform the different database operations. When the application is closing , I am closing the database object.</p>

<p>While saving &amp; deleting the data , its taking approx 4-5 seconds .</p>

<p>I have the following questions:</p>

<p>i>Is opening &amp; closing the database multiple times to handle the database queries a better approach or opening &amp; closing the database only once?</p>

<p>ii>Will using transaction(read on some articles) , while inserting &amp; deleting the data , help me in minimizing the processing time taken ?</p>

<p>If so , kindly provide some sample code/hints for transaction.</p>

<p>Thanks in advance.</p>

<p>Warm Regards,</p>

<p>CB</p>
