Re: [sqlite] Please Need Advice on 64 Bits Platform
Hi, IBM : powerpc-ibm-aix5.1.0.0 I did a lot of cleanup in environnemnts variables. then 1 ) export OBJECT_MODE=64 2) I stick with a simple configure ./../sqlite-3.2.7/configure --disable--shared --disable-tcl --disable-threadsafe --prefix=$PREFIX 3) in the Makefile put -q64 -qlonglong for the xlc compiler 4) in ./libtool forced ar with -X64 flag results: SQLite Works fine . I did some basics tests (inserts,simple selects, create temp tables ..) I think , Now people here, will certainly consider this very great Engine to suit there needs.. and replace the . home data format. Thansks all and thanks drh. I will post if i have trouble. Hamid. Jarosław Nozderko wrote: I've just built SQLite 3.2.7 on HP-UX 11 in 64-bit mode. Loading 1000 000 records into a simple table (using .read from SQL script with inserts, 1 in a single transaction) took 5 min 40 s (the same in 32-bit - 06:29) and creating index 56 s (01:14 for 32-bit). Unfortunately, this is heavily loaded server, so results above may not be precise. Regards, Jarek Hamid Benhocine <[EMAIL PROTECTED]> wrote: I want just to know if the Engine is 64 bits ready SQLite is designed to work on 64-bit machines. There have been a few alignment problems in the past but those have all been worked out now, I believe. I do not have a 64-bit machine to test on, but reports from users are that SQLite works when compiled in 64-bit mode. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Please Need Advice on 64 Bits Platform
I've just built SQLite 3.2.7 on HP-UX 11 in 64-bit mode. Loading 1000 000 records into a simple table (using .read from SQL script with inserts, 1 in a single transaction) took 5 min 40 s (the same in 32-bit - 06:29) and creating index 56 s (01:14 for 32-bit). Unfortunately, this is heavily loaded server, so results above may not be precise. Regards, Jarek > Hamid Benhocine <[EMAIL PROTECTED]> wrote: > > I want just to know if the Engine is 64 bits ready > > SQLite is designed to work on 64-bit machines. There have > been a few alignment problems in the past but those have all > been worked out now, I believe. I do not have a 64-bit > machine to test on, but reports from users are that SQLite > works when compiled in 64-bit mode. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > >
Re: [sqlite] Please Need Advice on 64 Bits Platform
I have an AMD 64 machine myself. Do I need to pass any special to compile in 64 bit mode? Bob [EMAIL PROTECTED] wrote: Hamid Benhocine <[EMAIL PROTECTED]> wrote: I want just to know if the Engine is 64 bits ready SQLite is designed to work on 64-bit machines. There have been a few alignment problems in the past but those have all been worked out now, I believe. I do not have a 64-bit machine to test on, but reports from users are that SQLite works when compiled in 64-bit mode. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Please Need Advice on 64 Bits Platform
Hamid Benhocine <[EMAIL PROTECTED]> wrote: > I want just to know if the Engine is 64 > bits ready SQLite is designed to work on 64-bit machines. There have been a few alignment problems in the past but those have all been worked out now, I believe. I do not have a 64-bit machine to test on, but reports from users are that SQLite works when compiled in 64-bit mode. -- D. Richard Hipp <[EMAIL PROTECTED]>
[sqlite] Please Need Advice on 64 Bits Platform
Hi all, I am always on the lookout for simple yet powerful software development tools and SQLite definitely falls into this category. It is a very great software. I tested the software a lot to replace our home data format (for Meteroligical Observations). The engine is very very fast for insertion of millions of records of satellite data. All the job was carried on Linux, SGI IRIX64 (front ends) The software was compiled in 32 bits mode. I did also some tests on our SuperComputer IBM (Aix v 5.1) and SQlite work great when Compiled in 32 b mode (-q32 -qlonglong VisualAge xlc flags etc). Because every peace of software we use on IBM must compile in 64 bits mode, ( I did not succeed to run Sqlite When Compiled iin 64 bits mode And I'm not a Sofware Engeneer) I want just to know if the Engine is 64 bits ready (the boss langage) or Can we call Sqlite (Complied 32 bits) from 64 bits applications. Any advice is Welcome. I worked very hard to push Sqlite to replace our home data format (Sqlite will do Solve a lot of our pbs .) Thanks A lot. Hamid