Might be obvious but make sure you do all your inserts and deletes within a single transaction as I believe this has a big impact on performance. Might bring the insert and delete times closer. -- View this message in context: http://www.nabble.com/Delete-performance-vs.-Insert-performance-t1823679.html#a4976020 Sent from the SQLite forum at Nabble.com.
- Re: [sqlite] Delete performance vs. Insert performance Cory Nelson
- Re: [sqlite] Delete performance vs. Insert performanc... Mikey C
- Re: [sqlite] Delete performance vs. Insert performanc... Christian Smith
- Re: [sqlite] Delete performance vs. Insert perfor... Jay Sprenkle
- Re: [sqlite] Delete performance vs. Insert pe... Christian Smith
- Re: [sqlite] Delete performance vs. Insert performanc... Dennis Cote
- Re: [sqlite] Delete performance vs. Insert perfor... Insun Kang
- Re: [sqlite] Delete performance vs. Insert pe... Insun Kang
- Re: [sqlite] Delete performance vs. Insert pe... Dennis Cote
- Re: [sqlite] Delete performance vs. Inser... John Stanton