Thank you for putting me on the right track! Now I know how to attack the
issue.
Also this pragmas may help me:
PRAGMA default_cache_size = Number-of-pages;
PRAGMA cache_size = Number-of-pages;
PRAGMA page_size = bytes;
PRAGMA max_page_count = N;
Regards,
Samuel
----- Original Message ----
From: Israel Lins Albuquerque
<israel...@polibrasnet.com.br>
[]
>The size of cache is used to reduce the disk access . If
the record is less than 100 bytes >on 1024 will contain aprox. 10 records if
you table has no more than 10.000 you will >need 976 pages
>In my case I take the amount of memory, split 30% of it
to sqlite using a proportionality >to the size of the database for each
attach
----- Original Message ----
From: Jay A. Kreibich <j...@kreibi.ch>
[]
> A smaller page size will often lower I/O performance.
> It depends quite a bit on the OS and filesystem you're using.
> you need to know your data and your environment.
__________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr!
http://www.flickr.com/gift/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
