SQLite: Optimal PAGE_SIZE

I read that the default PAGE_SIZE value of 1024 in SQLite has been chosen merely for compatiblity between different开发者_运维技巧 platforms and operatings systems.

Since my app runs only on Windows systems, would it be safe to increase it to a larger value (like 4096) or could it have any unwanted side-effects?

The only drawback is that an ill-adjusted page-size could make your database slower. Ultimately, page_size optimization will depend on four factors:

• platform
• schema
• data
• queries (i.e. usage)

Test and compare, that's the only way.