I could not find a document explaining how to find the optimal value for the
page size parameter.
Should I set the page size to match the allocation size (cluster size) of
the file system ?
Should I set it so that each page contains exactly a given number of records
(i.e. no record is split
Hi Paolo,
i met the same problem.
I have experimented with the page size and found that the cluster size
of the file system brought the best results. However, the gain in speed
was not very big (5%)
Martin
Zibetti Paolo schrieb:
I could not find a document explaining how to find the
October 2005 11:40
To: sqlite-users@sqlite.org
Subject: [sqlite] Optimal page size
I could not find a document explaining how to find the
optimal value for the
page size parameter.
Should I set the page size to match the allocation size
(cluster size) of
the file system ?
Should I set
* Chris Schirlinger:
4096 in Win32 machines and 1024 on nix ones (I think, I am no expert
on Unix style OS's)
This depends on the file system. On Linux on x86, it's typically 4096
bytes.
According to my performance measurements, switching from page size of
1024 bytes to 4096 bytes gives a
For what it is worth I did some trials in matching page size to the
underlying virtual memory page size and was surprised to find that I did
not measure any significant performance change. My guess is that it is
the structure of the data in your application which would be sensitive
to page
For what it is worth I did some trials in matching page size to the
underlying virtual memory page size and was surprised to find that I did
not measure any significant performance change. My guess is that it is
the structure of the data in your application which would be sensitive
to