on Fri, 30 Nov 2007 15:21:56 -0800
Joe Wilso wrote:
I would not bother with make install on MinGW - too much hassle -
just copy out sqlite3.exe, libsqlite3.a and sqlite3.h manually
to wherever you want to put it.
Joe:So, do is there a libsqlite3.a file?Where is it?Thanks--
---
--- "A.J.Millan" <[EMAIL PROTECTED]> wrote:
> Joe Wilso wrote:
> >I would not bother with make install on MinGW - too much hassle -
> >just copy out sqlite3.exe, libsqlite3.a and sqlite3.h manually
> >to wherever you want to put it.
> Joe:So, do is there a libsqlite3.a file?Where is it?Thanks--
So
On Sun, 02 Dec 2007 10:30:32 +0300, "M. Bashir Al-Noimi"
<[EMAIL PROTECTED]> wrote:
>Hi All,
>
>
>I wondered why SQLite is so slow by comparing with another database
>drivers!, I got this conclusion by making a small test for SQLite,
>Paradox, AbsoluteDB, and M$ Access drivers.
>
>The result as
Hello,
I like to save a date for each row in my database. Later I would select
the rows with a query:
SELECT *
FROM Store_Information
WHERE Date BETWEEN 'Jan-06-1999' AND 'Jan-10-1999'
Is there a date data type in sqlite? I've not found it in the docs.
If not, I had the idea to use UNIX timesta
Hi Andreas,
I like to save a date for each row in my database. Later I would
select the rows with a query:
SELECT *
FROM Store_Information
WHERE Date BETWEEN 'Jan-06-1999' AND 'Jan-10-1999'
Is there a date data type in sqlite? I've not found it in the docs.
Store dates in this format: YYY
Hi!
Is there a way to get the column names as part of the insert statment, like
INSERT INTO DefConfig (Class,Status,Var,Type,Val,Remark) VALUES
('sgLog','enabled','Log,PID','boolean','1','default');
instead of
INSERT INTO "DefConfig" VALUES
('sgLog','enabled','Log,PID','text','1','defa
Hi All,
I'm writing a C application which runs inside of FastCGI process.
The problem is that I am getting poor performance... roughly 1000
SELECTs in 20 seconds.
It's not an indexing issue (I promise). This is true even when there are
only 2 rows. I'm not getting errors.
PHP PDO sqlite runs abo
Hi All,
I'm writing a C application which runs inside of FastCGI process.
The problem is that I am getting poor performance... roughly 1000
SELECTs in 20 seconds.
It's not an indexing issue (I promise). This is true even when there are
only 2 rows. I'm not getting errors.
PHP PDO sqlite runs abo
Don't use sqlite3_get_table. Use sqlite3_prepare_v2, sqlite3_step,
sqlite3_finalize and related APIs instead.
Mike
> -Ursprüngliche Nachricht-
> Von: Jonathan Hendler [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 2. Dezember 2007 14:10
> An: sqlite-users@sqlite.org
> Betreff: [sqlite] H
Mike,
Thank you very much - I'll do that and let the list know about the results.
One follow up question - I saw sqlite3_prepare_v2 in php code, but I
see the same slow speed with sqlite3_exec when doing inserts, deletes, etc.
Should INSERT, DELETE, etc also use sqlite3_prepare_v2 also?
- J
On Sun, 02 Dec 2007 13:42:17 +0100, Stefan Finzel
<[EMAIL PROTECTED]> wrote:
>Hi!
>
>Is there a way to get the column names as part of the insert statment, like
>
>INSERT INTO DefConfig (Class,Status,Var,Type,Val,Remark) VALUES
>('sgLog','enabled','Log,PID','boolean','1','default');
>
>instead of
Using the deprecated API get_table is very likely the problem.
Jonathan Hendler wrote:
Hi All,
I'm writing a C application which runs inside of FastCGI process.
The problem is that I am getting poor performance... roughly 1000
SELECTs in 20 seconds.
It's not an indexing issue (I promise). This
Sorting the returned 30 000 records maybe takes 3-4 seconds?
/Jonas
On 12/2/07, Ofir Neuman <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have some performance problem when adding ORDER BY to my query, hope you
> can help me speed things up.
>
> This is my table:
>
> TABLE1
> {
> ID TEXT
> ParentI
Hi All,
I have some performance problem when adding ORDER BY to my query, hope you
can help me speed things up.
This is my table:
TABLE1
{
ID TEXT
ParentID TEXT
ModifiedDate INTEGER
}
ID is the PK of the table and i also have an index on ParentID.
Current number of records in table: 40,00
Sqlite uses an epoch based date like the Unix timestamp, but realised in
a 64 bit floating point number. It has a set of inbuilt functions to
process these timestamps. See date.c for full details.
Using the FP format of the date and time will work well in your application.
You can add date f
Ofir Neuman wrote:
Hi All,
I have some performance problem when adding ORDER BY to my query, hope you
can help me speed things up.
This is my table:
TABLE1
{
ID TEXT
ParentID TEXT
ModifiedDate INTEGER
}
ID is the PK of the table and i also have an index on ParentID.
Current number of re
Thank you, I'm working on updating the code now.
http://www.sqlite.org/c3ref/free_table.html does not mention it was
depricated and the page was updated 3 days ago.
Am I looking in the wrong place?
John Stanton wrote:
> Using the deprecated API get_table is very likely the problem.
>
> Jonathan H
On Dec 2, 2007, at 12:01 PM, Ofir Neuman wrote:
Hi All,
I have some performance problem when adding ORDER BY to my query,
hope you
can help me speed things up.
This is my table:
TABLE1
{
ID TEXT
ParentID TEXT
ModifiedDate INTEGER
}
ID is the PK of the table and i also have an index
The slowness had something to do with the way I was compiling.
I'm new to GCC and on MacOSX.
I was compiling with dmalloc, and gdb for debugging - (-ggdb -DDMALLOC
-DDMALLOC_FUNC_CHECK ) but even when I removed those I experienced the
same issues. Why? Who knows - my test code also used Cutest, an
Hi,
Thank you very much Dennis for the reply.
I will try the method suggested by you.
Best Regards,
A.Sreedhar.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 01, 2007 1:31 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite:Deletion in
20 matches
Mail list logo