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

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 He

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

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. Tha

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

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 ha

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

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 ha

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

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] sqlite3: sqlite3_step() return SQLITE_FULL error.

Hi sir, Thanks a lot. It is working fine with the same path and with multiprocess. Thanks and regards Deepak On Wednesday 13 May 2015 06:44 PM, Richard Hipp wrote: > On 5/13/15, Deepak Hegde wrote: >> I have gone through the document and it says, it is not thread safe. >> W

[sqlite] sqlite3: sqlite3_step() return SQLITE_FULL error.

processes? Can we have actual database path and this temporary path same? Thanks a lot. Thanks and Regards Deepak On Wednesday 13 May 2015 10:45 AM, Richard Hipp wrote: > On 5/12/15, Deepak Hegde wrote: >> Hi everyone, >> >> I am facing a issue and details are as below: &g

[sqlite] sqlite3: sqlite3_step() return SQLITE_FULL error.

Hi everyone, I am facing a issue and details are as below: 1) Database table have around 15 table. One of the table have around 66000 entries and this table have about 25 columns. 2) This table with 66000 entry have field called TITLE with TEXT type with table name AUDIO. 3) When I run a query