> 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
>
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
* 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
Sent: 25 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
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
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
6 matches
Mail list logo