Are you wrapping the transactions in between Begin/End Transactions?
BEGIN TRANSACTION;
INSERT INTO table (foo) VALUES (bar);
INSERT INTO table (foo) VALUES (par);
INSERT INTO table (foo) VALUES (tar);
INSERT INTO table (foo) VALUES (far);
..
INSERT INTO table (foo) VALUES (car);
INSERT INTO
Hello,
I would like to compile the sqlite3odbc v. 0.65 from C.Werner and require
the sqlite-3.0.7 source for it. I tried searching for it in the internet
without any success. I can't even log on to the CVS Repository und
www.sqlite.org with the password: anonymous.
Can anyone point me to the
On Sat, 19 Nov 2005, Matthias Teege wrote:
Christian Smith schrieb:
Index the pairs table, like I do in my schema. You might want to index by
id and field as these are primarily what you use to read data in this
Does it make any difference if the index is unique or not?
Yes. You'll want a
On Mon, 21 Nov 2005, Shane Baker wrote:
I'm sure I must be doing something wrong. This is my first attempt at
working with SQLite.
We'll see...
I have a simple table, with 7 columns. There are 6 integers and a BLOB,
with the primary key being on an integer. When I try to run inserts (one
No, as I mentioned in my original message, I am not wrapping them. I
don't want to test an unrealistic scenario for my application. In my
application, there are multiple sources that will be inserting into the
database and pooling the information for a bulk insert won't work.
I understand that
Thank you very much for the feedback. I understand your point, hardware
takes a deterministic amount of time.
I have been basing my assumptions on these sources:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations (See
Transactions and performance)
Igor Tandetnik wrote:
From: Dennis Cote [EMAIL PROTECTED]
I don't know of a way to do what you want with a user defined
function, but your example can be solved quite simply using SQL. The
following query will return a table with the required results.
select * from test order by col desc
Does anyone have any working solutions for calculating the mode of a set
of values in SQLite?
In SQL For Smarties, Celko gives two solutions, neither of which seem to
work in SQLite:
1)
SELECT salary, COUNT(*) AS frequency
FROM Payroll
GROUP BY salary
HAVING COUNT(*)
= ALL (SELECT
On Fri, Nov 18, 2005 at 04:25:12PM -0700, Dennis Cote wrote:
Is there any reasonable way to accomplish this? Or am I left with
defining a new function type that returns a handle to a temp table,
and new parsing logic to wrap the right OP codes around that function?
I don't know of a way to
Not totally sure, the descriptions of the error just sounded different...But
could be related...
-Original Message-
From: Rob Lohman [mailto:[EMAIL PROTECTED]
Sent: Monday, November 21, 2005 12:33 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unable to load DLL Help!
How can you
Tim Martin wrote:
Does anyone have any working solutions for calculating the mode of a
set of values in SQLite?
I'm not exactly sure what mode is. From your examples, it seems you
want to get an element that occurs most often. This should do it:
select salary, count(*) occurs
from payroll
Hi,
I am using sqlitebrowser, but it eats up a lot of memory. For some
reason it decides to cache query results and has a caching policy which
works well for DBs that fit in memory, but doesn't otherwise.
I am looking to patch it. Meanwhile, if anyone has seen similar patches
or knows of a
Igor Tandetnik [EMAIL PROTECTED] wrote:
Tim Martin wrote:
Does anyone have any working solutions for calculating the mode of a
set of values in SQLite?
I'm not exactly sure what mode is. From your examples, it seems you
want to get an element that occurs most often. This should do it:
I have sqlite-3.0.8.tar.gz. Will that work?
On 11/21/05, Sami Islam [EMAIL PROTECTED] wrote:
Hello,
I would like to compile the sqlite3odbc v. 0.65 from C.Werner and require
the sqlite-3.0.7 source for it. I tried searching for it in the internet
without any success. I can't even log on to
FYI:
If you have a very small number of rows in the table and index will
make it slower,
rather than faster.
On 11/21/05, Wilfried Mestdagh [EMAIL PROTECTED] wrote:
Hi Bert,
'select distinct Name ' +
'from Rx ' +
'where RxDT = ' + DT + ' ' +
'order by Name'
One thing is not yet
[EMAIL PROTECTED] wrote:
Igor Tandetnik [EMAIL PROTECTED] wrote:
Tim Martin wrote:
Does anyone have any working solutions for calculating the mode of a
set of values in SQLite?
I'm not exactly sure what mode is. From your examples, it seems
you want to get an element that occurs most often.
Dennis Cote wrote:
Igor Tandetnik wrote:
From: Dennis Cote
I don't know of a way to do what you want with a user defined
function, but your example can be solved quite simply using SQL. The
following query will return a table with the required results.
select * from test order by col desc
You can't get any lighter than the sqlite3 tool that ships with SQLite3.
Can you be more specific in terms of what you need?
Eno Thereska wrote:
Hi,
I am using sqlitebrowser, but it eats up a lot of memory. For some
reason it decides to cache query results and has a caching policy which
Something with a GUI would be ideal. I agree that the sqlite3 tool is
very lightweight, unfortunately it has no GUI.
Thanks,
Eno
juan perez wrote:
You can't get any lighter than the sqlite3 tool that ships with SQLite3.
Can you be more specific in terms of what you need?
Eno Thereska
Eno Thereska [EMAIL PROTECTED] wrote:
Something with a GUI would be ideal. I agree that the sqlite3 tool is
very lightweight, unfortunately it has no GUI.
It is not clear what you mean by GUI. If you mean something
that displays in a separate window rather than in your shell
window, then
select salary, count(*) occurs from payroll
group by salary having occurs =
(select count(*) c from payroll group by salary
order by c desc limit)
OR
select salary, count(*) from payroll group by salary
having count(*) = (select max(cnt) from
(select count(*) cnt from
I'm still on SQlite 2.8, and I use sqlitecc.exe; I think I saw an
announcement that a version was available for SQlite v3.
On 11/21/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Eno Thereska [EMAIL PROTECTED] wrote:
Something with a GUI would be ideal. I agree that the sqlite3 tool is
Sorry, my emailer messed things up, try it again
0OpenVirtual10keyinfo(1,BINARY)
1Goto031
2Integer00
3OpenRead02
4SetNumColumns02
5Integer00
6OpenRead23keyinfo(1,BINARY)
7Integer1
Hi,
On Mon, 21 Nov 2005 10:56:41 -0500 (EST)
Shane Baker [EMAIL PROTECTED] wrote:
I just need to figure out why my performance is about 30x slower than what
others are reporting when using the library in similar ways.
Are you using sqlite on windows or MacOS X?
As I tested, sqlite performs
Thank you very much. I am happy to hear that the performance I am seeing
is in line with what others have observed. I am running this on Windows
XP.
On Tue, 22 Nov 2005, Akira Higuchi wrote:
Hi,
On Mon, 21 Nov 2005 10:56:41 -0500 (EST)
Shane Baker [EMAIL PROTECTED] wrote:
I just need to
25 matches
Mail list logo