But there is a limit (3.4.0) which stops at 32KB. the compile macro would do?
regards ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ***************************************************************************************** ----- Original Message ----- From: Joe Wilson <[EMAIL PROTECTED]> Date: Monday, September 17, 2007 12:11 pm Subject: Re: [sqlite] Sqlite insertion performance > --- RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > > But with large cache there is too much fragmentation observered > (pgin/pgout)> over a period of time. Do u see this behaviour? > > Fragmentation is not a function of page cache size, but yes, > I also see this fragmentation if the secondary index exists before > the inserts. If you create the index after your inserts, you will > have far less (or no) fragmentation. > > See the merge-sort point in: > > http://www.sqlite.org/cvstrac/wiki?p=ToDo > > > My CacheSize: 32KB, PgSize: 8KB (to the limits) > > Try a page size of 32768 and a value of half your RAM for cache size. > > > > ____________________________________________________________________________________ > Need a vacation? Get great deals > to amazing places on Yahoo! Travel. > http://travel.yahoo.com/ > > ------------------------------------------------------------------- > ---------- > To unsubscribe, send email to [EMAIL PROTECTED] > ------------------------------------------------------------------- > ---------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
