On Fri, Dec 17, 2010 at 8:29 AM, Richard Hipp <d...@sqlite.org> wrote: > I also observe that compiling for 64-bit using vs2010 (not an option with my > ancient version 2.95.3 gcc cross-compiler) that the queries are an > additional 2x faster. I was surprised at the dramatic performance increase > in going from 32-bit to 64-bit. Is such a speed-up typical?
Perhaps you've got a lot of register spills, or branch-heavy code that can now use cmov? If you mean 2x while still using the standard malloc() -- in 64-bit Windows, a low-frag heap is used by default. It can give a significant performance boost to allocation-heavy apps. Perhaps you could try enabling it in 32-bit. I generally try to avoid malloc() and use my own pools/arenas, but I'd also be curious to know what pattern is causing malloc() to behave poorly. It's easy to make SQLite CPU-bound, so any efficiency improvement would be a plus. -- Cory Nelson http://int64.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users