I have a few PDA benchmarks at:
http://sqlite.phxsoftware.com/forums/623/ShowPost.aspx
They are for the SQLite ADO.NET 2.0 wrapper of course, but they can give you
a rough idea.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 19, 2006 8:39
Hi,
Does anyone have experience use SQLite on a Palm or Pocket-PC handheld?
I want the speed of an indexed database. I need faster data access than I get
from the Palm files on my Palm Tungsten T3. I can give more details, but the
main point is, as I sai, I nee help using SQLite on hanhels.
Bill
Stefan de Konink <[EMAIL PROTECTED]> wrote:
> SQLite version 2.8.16
> Enter ".help" for instructions
> sqlite> \;
> Segmentation fault
>
> Probably some minor thing.
>
Here's what I get:
SQLite version 2.8.16
Enter ".help" for instructions
sqlite> \;
SQL error: unrecognized token: "\"
--
D.
SQLite version 2.8.16
Enter ".help" for instructions
sqlite> \;
Segmentation fault
Probably some minor thing.
Stefan
Hi,
How do I subtract two dates and get the answer in minutes?
--
Cheers,
Dr Gerard Hammond
Bioinformatic Analyst
Garvan Institute of Medical Research, Sydney, Australia.
If you're not part of the solution, you're part of the precipitate.
So I first had these commands:
create table blah (b INTEGER, c INTEGER);
insert into blah values(400,300);
insert into blah values(360,250);
select a,max(b-a) from blah where c=a and a > 200 and a < 500;
That didn't work: 'a' doesn't exist. So I looked in the help and changed the
last line to
I tried without using a bound column name, that took care of it. Thanks
Jay Sprenkle wrote:
On 5/19/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote:
Hello,
I've been staring at this line for quite a while now, and can't
figure out what the problem is. I know the database is created and
Kevin Piciulo <[EMAIL PROTECTED]> wrote:
> Hello,
> I've been staring at this line for quite a while now, and can't
> figure out what the problem is. I know the database is created and
> open. The following returns SQLITE_ERROR.
>
> sqlite3_prepare(m_dbDataBase, "UPDATE Users SET ? = ?
On 5/19/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote:
Hello,
I've been staring at this line for quite a while now, and can't
figure out what the problem is. I know the database is created and
open. The following returns SQLITE_ERROR.
sqlite3_prepare(m_dbDataBase, "UPDATE Users SET ? = ?
Hello,
I've been staring at this line for quite a while now, and can't
figure out what the problem is. I know the database is created and
open. The following returns SQLITE_ERROR.
sqlite3_prepare(m_dbDataBase, "UPDATE Users SET ? = ? WHERE user_id ==
?;", -1, , NULL);
My guess is
Anish,
So my problem of retrieving 1,000,000 random records 1,000,000 times
works fine for 15 bytes. But it is taking too long a time for 1k
records. It is almost taking 102 seconds for retrieving 50,000 records
of size 1k. Can u suggest me a way for reducing the time taken for the
same? I
Actually, I thought it would fix my problem but it seems like it persists.
What seems to happen is that the generate parse.h file stops at token ID
#136. I can hack my way through although it does not make sense to me why
TK_SPACE would not be generated from the parse.y file.
In case it makes
It works like a champ. Thanks.
> > Suppose I have two tables, A and B. A has two columns: score,
> > location. B has two columns leftLocation, rightLocation.
> >
> > I need the maximum score located outside all entries in
> table B. B is
> > a small table, say less than 100 entries.
>
>
Alas, it's nowhere near so simple. There will be other processes that
*can* be writing the file at the same time, so we still need an
advisory locking mechanism.
In case you were wondering, we're trying to implement row-level
access control (using views and triggering write operations
Mike Ashmore <[EMAIL PROTECTED]> wrote:
> Hello all,
> I'm working on a system in which I'm using SQLite to open a number of
> database files and to perform operations on aggregate views of those
> files.
>
> The problem I've got is, some of the files I want SQLite to open and
> SELECT
On 5/19/06, Mike Ashmore <[EMAIL PROTECTED]> wrote:
[...]
Since locking will require me to invoke (slow) IPC mechanisms, I
don't want to send any more lock messages off to my lock server than
absolutely necessary; any suggestions on how I should approach that?
Try to look at the os_win.c file
Hello all,
I'm working on a system in which I'm using SQLite to open a number of
database files and to perform operations on aggregate views of those
files.
The problem I've got is, some of the files I want SQLite to open and
SELECT from, I can only acquire read access to. And the
Brannon King
wrote:
Suppose I have two tables, A and B. A has two columns: score,
location. B has two columns leftLocation, rightLocation.
I need the maximum score located outside all entries in table B. B is
a small table, say less than 100 entries.
select max(score) from A where not
George Ionescu wrote:
Hello Noel,
Hello George
I'm reposting this message because I have the feeling that you missed the
original one.
I don't plan to replace the normal indexing, I plan to have a set of
function to create a (memory ?) index. But how do I retrieve the data
without
Hi Dennis,
I corrected one problem of mine, but is left with another. As
you told me, I tried creating index for the seq_number. But I came to
know that if we are creating a table and assigning primary key to a
particular column (here seq_number), we do not want to create index for
that
Hello Noel,
I'm reposting this message because I have the feeling that you missed the
original one.
>I don't plan to replace the normal indexing, I plan to have a set of
>function to create a (memory ?) index. But how do I retrieve the data
>without doing a select where rowid = xxx ?
If you're
Martin Pfeifle wrote:
Hello Noel,
I think you can find more information on the computation of the upper hull values in
[FFS00] "Implementing Geospatial Operations in an Object-Relational Database
System".
Yes I'm already reading that.
For testing, we used oracle, where we had transient
Hi,
Is the database really corrupt, or are you getting
a spurious error? You can tell if the database is
truely corrupt or not by running
PRAGMA integrity_check;
I will check this.
And yes, every thread uses its own sqlite3* ;)
Are you really sure of this? In my experience most of
Dear Thomas Budeism
What is your problem. Why write insulting me. What the hell is wrong
with you. Are you pompous because you feel you know everything about
Sqlite. When i first posted this e-mail i realised it was not concise
and i reposted, but thanks to those on the forum that understand and
Martin Pfeifle wrote:
Hi,
I think the simplest solution would be to put a spatial index on top of the
B-tree, that's what e.g. Oracle does in their Spatial Cartridge.
Basically you store the index data in relations and index these relations by
B-trees.
In this case, you do not have to change
25 matches
Mail list logo