[sqlite] configure syntax error on HP

I'm trying to compile 3.5.9 on an HP-UX 11i v1 machine but I can't get past step one... I unpacked the amalgamation, cd'd to the directory, and ran './configure' - that didn't work so I tried 'sh ./configure' like the install instructions suggest. I got a syntax error right away.

Re: [sqlite] configure syntax error on HP

>On Jun 18, 2008, at 5:38 PM, Andrea Connell wrote: > >> I'm trying to compile 3.5.9 on an HP-UX 11i v1 machine but I can't get >> past step one... >> >> I unpacked the amalgamation, cd'd to the directory, and ran >> './configure' - that didn't work so I tried

Re: [sqlite] configure syntax error on HP

. Richard Hipp Sent: Wednesday, June 18, 2008 6:58 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] configure syntax error on HP On Jun 18, 2008, at 7:12 PM, Andrea Connell wrote: > I want to use the C API with a C++ class but when I try compiling... > > $ aCC -AA +W829

[sqlite] Performance on HP

Now that I have SQLite compiled on HP, I am starting to test performance. So far it's pretty disappointing though. I am comparing performance of SQLite versus an in-house directory access system. I have the same table structure and data for each of them. The code reads some data from an input

Re: [sqlite] Performance on HP

will make a difference, but should it be this dramatic? Thanks, Andrea -Original Message- From: Andrea Connell Sent: Friday, June 20, 2008 11:23 AM To: sqlite-users@sqlite.org Subject: Performance on HP Now that I have SQLite compiled on HP, I am starting to test performance. So far it's

Re: [sqlite] Performance on HP

[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, June 20, 2008 12:28 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Performance on HP Hi Andrea, I'm interested in your query: Andrea Connell wrote: > char * qry = "SELECT * FRO

Re: [sqlite] Performance on HP

Database Subject: Re: [sqlite] Performance on HP You are measuring the speed of the respective machines. Benchmark each one to get relative performance. Andrea Connell wrote: > > Sorry somehow I sent that before I was quite finished. I'm just > wondering if there is anything else I s

Re: [sqlite] Performance on HP

>Have you tried compiling with the profiler and seeing where the time is being spent? I compiled with the profiler and used prof to analyze the mon.out file. The program took 47 seconds to run, but the results only account for .39 seconds I do compile sqlite3.c into sqlite3.o then link it into

Re: [sqlite] Performance on HP

>> The program took 47 seconds to run, but the results only account for >> .39 seconds > > Most likely all the time is being spent in IO related system calls > - read(), write() and fsync(). > > Dan. Thanks for the idea Dan. How can I confirm this or try reducing the time spent? I use the

Re: [sqlite] sqlite DB creation performance

Creation time would be a bit faster if you don't create the index until AFTER importing the data. That way it doesn't have to worry about keeping things in their proper order on every insert. -Andrea -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

Re: [sqlite] Performance on HP

TECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrea Connell Sent: Monday, June 23, 2008 11:48 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Performance on HP >> The program took 47 seconds to run, but the results only account for >> .39 seconds > >

Re: [sqlite] Performance on HP

>On Jun 30, 2008, at 2:37 PM, Andrea Connell wrote: > >> Any ideas? It's driving me crazy why SQLite is this much slower on >> UNIX >> boxes, while other applications maintain their speed. > >What filesystem are you using on the unix boxes? Are you *sure* you >

[sqlite] View with Dynamic Fields ?

I'm not sure if what I want is possible to do in SQL, but I -am- sure that one of you will know. Given two tables - one with questions to ask applicants and one with an applicant's answer to a particular question - I want to make a flattened view with all of an applicant's answers in one row.

Re: [sqlite] View with Dynamic Fields ?

Harold Wood wrote: >my approah would be a table for applicants, then the table for answers would have the applicantid and the questionid as well as the answer. > >CREATE TABLE tblApplicants (applicantid int, applicantname varchar(100)); >now just do a select joining the tables > >select

Re: [sqlite] View with Dynamic Fields ?

hris On Tue, 8 Jul 2008, Andrea Connell wrote: > I'm not sure if what I want is possible to do in SQL, but I -am- sure > that one of you will know. > Given two tables - one with questions to ask applicants and one with > an applicant's answer to a particular question - I want to mak

Re: [sqlite] View with Dynamic Fields ?

Of Dennis Cote Sent: Tuesday, July 08, 2008 5:08 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] View with Dynamic Fields ? Andrea Connell wrote: > > I am still holding a shred of hope for a trigger that can recreate the > view whenever the questions table is modif

Re: [sqlite] View with Dynamic Fields ?

with Dynamic Fields ? On Wed, Jul 09, 2008 at 12:32:27PM -0700, Andrea Connell wrote: > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote > > > > Andrea Connell wrote: > > > I am still holding a shred of hope for a trigger that can