sqlite - Performance Considerations

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 7,18 ****
  
  When doing lots of updates/inserts on a table it is a good idea to contain them within a transaction,
  
! begin;
! insert into table values (..);
! insert into table values (..);
! insert into table values (..);
! ....
! commit;
  
  This will make SQLite write all the data to the disk in one go, vastly increasing performance. 
  
--- 7,18 ----
  
  When doing lots of updates/inserts on a table it is a good idea to contain them within a transaction,
  
!   begin;
!   insert into table values (..);
!   insert into table values (..);
!   insert into table values (..);
!   ....
!   commit;
  
  This will make SQLite write all the data to the disk in one go, vastly increasing performance.