[sqlite] [Sqlite] Insert statement execution takes more time as DB entries increases.

2015-09-30 Thread Deepak Hegde
Hi Ryan, Since you mentioned index, I started looking into other constrains and logic i had on DB. which made me realize about the trigger. Thanks a lot. Thanks and Regards Deepak On Wednesday 30 September 2015 04:47 PM, R.Smith wrote: > > > On 2015-09-30 12:31 PM, Deepak Hegde wrote: >> On

[sqlite] [Sqlite] Insert statement execution takes more time as DB entries increases.

2015-09-30 Thread Deepak Hegde
Hi Ryan, Thanks a lot for your support. I had a trigger to update the one of the column in audio table on insert to audio table. That made this delay. Thanks and Regards Deepak On Wednesday 30 September 2015 04:01 PM, Deepak Hegde wrote: > Hi Ryan, > > Please find my reply below. Thanks a lot.

[sqlite] [Sqlite] Insert statement execution takes more time as DB entries increases.

2015-09-30 Thread Deepak Hegde
Hi Ryan, Please find my reply below. Thanks a lot. Thanks and Regards Deepak On Wednesday 30 September 2015 03:30 PM, R.Smith wrote: > > > On 2015-09-30 11:46 AM, Deepak Hegde wrote: >> Hi All, >> >> I have a to copy entry from on database to another which have the >> similar structure. >> >>

[sqlite] [Sqlite] Insert statement execution takes more time as DB entries increases.

2015-09-30 Thread Deepak Hegde
Hi Ryan, Please find my reply below. Thanks a lot. Thanks and Regards Deepak On Wednesday 30 September 2015 03:30 PM, R.Smith wrote: > > > On 2015-09-30 11:46 AM, Deepak Hegde wrote: >> Hi All, >> >> I have a to copy entry from on database to another which have the >> similar structure. >> >>

[sqlite] [Sqlite] Insert statement execution takes more time as DB entries increases.

2015-09-30 Thread Deepak Hegde
Hi All, I have a to copy entry from on database to another which have the similar structure. So I am using the method of ATTACH the DB and INSERT statement to insert the 200 entries at a time. I have observed that as the entries in the copied database increases event though I am inserting 200

[sqlite] [Sqlite] Insert statement execution takes more time as DB entries increases.

2015-09-30 Thread R.Smith
On 2015-09-30 12:31 PM, Deepak Hegde wrote: > On Wednesday 30 September 2015 03:30 PM, R.Smith wrote: >> >> On 2015-09-30 11:46 AM, Deepak Hegde wrote: >>> Hi All, >>> >>> I have a to copy entry from on database to another which have the >>> similar structure. >>> >>> So I am using the method of

[sqlite] [Sqlite] Insert statement execution takes more time as DB entries increases.

2015-09-30 Thread R.Smith
On 2015-09-30 11:46 AM, Deepak Hegde wrote: > Hi All, > > I have a to copy entry from on database to another which have the > similar structure. > > So I am using the method of ATTACH the DB and INSERT statement to insert > the 200 entries at a time. > I have observed that as the entries in the