Re: [sqlite] Updating on 32bit os slower than 64bit?

te-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on behalf of xp [needforspeed1...@gmail.com] > Sent: Monday, July 16, 2012 10:11 AM > To: sqlite-users@sqlite.org > Subject: EXT :Re: [sqlite] Updating on 32bit os slower than 64bit? > > Michael, > > Thanks fo

Re: [sqlite] Updating on 32bit os slower than 64bit?

Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of xp [needforspeed1...@gmail.com] Sent: Monday, July 16, 2012 10:11 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Updating on 32bit os slower than 64bit? Michael, Thanks for y

Re: [sqlite] Updating on 32bit os slower than 64bit?

I've tried to set the SQLITE_THREADSAFE=2 and 1, but observed no difference. Any other flag that might affect this? Thanks -- View this message in context: http://sqlite.1065341.n5.nabble.com/Updating-on-32bit-os-slower-than-64bit-tp63292p63319.html Sent from the SQLite mailing list archive at

Re: [sqlite] Updating on 32bit os slower than 64bit?

Michael, Thanks for your reply. My /home is not NFS mounted. It is mounted locally using LVM. I just tested on another 32 bit linux system (rhel 5, not using LVM). It ran much faster than the 32 bit fedora, not as fast as the 64 bit scientific linux but close. I also tried to test on /tmp on the

Re: [sqlite] Updating on 32bit os slower than 64bit?

Could be different compilation settings for sqlite (or libs). *Jonas Malaco Filho* 2012/7/15 xp > Hi, > > I am a sqlite newbie. I would be very grateful if anyone can answer my > question or point me to the right direction. > > I have a very simple database: > >

Re: [sqlite] Updating on 32bit os slower than 64bit?

Wow...14 secs for 10 updates? That's the slowest I've ever heard by far. Is your 32-bit system using an NFS mounted /home or such? Can you run your test on /tmp instead? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop