Hi Alberto, On Fri, 26 Jan 2007 19:58:20 +0000, you wrote:
>Hi > >I am trying to create indexes on some tables. I know the database is >just being used by me, and I have memory to optimize things. I am >trying to optimize things doing > >PRAGMA temp_store = MEMORY >PRAGMA cache_size = 1000000 >PRAGMA synchrinous = OFF >PRAGMA count_changes = 0 > >Is there any other pragma I can use for efficiency? PRAGMA page_size = 4096; Helps to store longish rows without having to overflow to another page. This pragma should be the first statement to execute when a new database is created. Experiment with various sizes for the best result. PRAGMA auto_vacuum = 0; This is the default, but I'm used to set important options explicitly all the time. To avoid surprises and to remind myself what I'm doing. This pragma should be issued before the first table is created. PRAGMA default_cache_size = 1000000; Will make the cache size stick to the database, so you don't have to repeat it every time it is opened. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
