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
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,
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
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
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
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
>
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:
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
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:
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
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
--- "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--
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--
13 matches
Mail list logo