sqlite - Performance Tuning Windows

Not logged in

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

• Contents
• No-Diff
• Text

*** 64,78 ****
  
  Now create your tables *immediately* (if you close down the SQLite command line program and reopen the DB, the page size is reset to 1024). The page size must be set before the first table is created.
  
! Once that tables made, you can't change the size.
  
! Just a note that you must also perform this command before you start a transaction (despite the optimization hint that every command should be in a transaction).
  
  Typing:
  
      PRAGMA page_size;
  
! will tell you what it is currently set at
  
  
  **Four: Clustered Indexes**
--- 64,78 ----
  
  Now create your tables *immediately* (if you close down the SQLite command line program and reopen the DB, the page size is reset to 1024). The page size must be set before the first table is created.
  
! Once that tables made, you can't change the size. It is fixed and does not need to be re-specified.
  
! Just a note that you must perform this command before you start a transaction (despite the optimization hint that every command should be in a transaction).
  
  Typing:
  
      PRAGMA page_size;
  
! will tell you what it is currently set at.
  
  
  **Four: Clustered Indexes**