Re: [sqlite] INDEX Types

[GB]

Maybe you could try to use a pagesize that matches the size of a disk 
allocation unit or memory page. For Windows since a typical NTFS 
partition has a clustersize of 4KiB - which happens to also be the size 
of a memory page - a pagesize of 4096 Byte seems to be a good compromise 
between pleasing the cache manager and waste of space. You could also 
investigate the effect of VACUUMing and ANALYZEing the Database. If you 
have multiple indexes on tables try compiling sqlite defining the 
SQLITE_ENABLE_STAT3 switch to get even better results from ANALYZE.

hth
gerd
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users