Hi,
Neelamegam Appadurai wrote:
Can anyone please help me how to increase the performance on windows
enviroment
One thing you can do is to increase the page size from 1024 to 4096.
That seems to match either Windows' swapfile-pagesize or the default
page size of NTFS (there is disagreement over which it is that causes
the speed increase). This has given a speed increase for me. Not a
factor 2, mind you, but still a speed increase.
Also, you might try increasing the SQLite page cache size on Windows.
HTH
Ulrik Petersen
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark