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 N

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

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

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: create table epics_channel( id integer primary key, epics_pv text unique, value_type text, -- current or voltage value real default 0.0