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





Reply via email to