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
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 perform
Sorry, my emailer messed things up, try it again
0OpenVirtual10keyinfo(1,BINARY)
1Goto031
2Integer00
3OpenRead02
4SetNumColumns02
5Integer00
6OpenRead23keyinfo(1,BINARY)
7Integer1
Wilfried Mestdagh wrote:
Hi Bert,
'select distinct Name ' +
'from Rx ' +
'where RxDT >= ' + DT + ' ' +
'order by Name'
One thing is not yet clear to me. That is the 'distinct'. To have this
as fast as possible I have to make also a separate index on "RxDt,
Name". Is that correct ?
Igor Tandetnik wrote:
Dennis Cote wrote:
If you have an index on col then it will also be very fast
regardless of the size of the table, *** if not it will do a single
table scan to find the three maximum values. ***
(emphasis mine).
That's obvious. What about the case when there is no
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 i
> 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 f
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, t
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 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 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
wo
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
[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 o
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 thi
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 o
"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 sh
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 b
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
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 b
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
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 CO
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 des
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")
http://blog.amber.org/2004/11/28/s
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 I
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 (
Christian Smith <[EMAIL PROTECTED]> wrote:
>
> >
> >> Now, all lookups used to implement the view are done using index lookups.
> >
> >Can I check that a query use the index?
>
>
> You can examine the output of "explain " in the sqlite shell.
> You should get something like:
>
> xx|OpenRead|xx|
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 w
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 righ
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 table
I'm trying to evaluate SQLite robustness in case of a power loss on Windows.
For my tests, I always used PRAGMA SYNCHRONOUS 2.
I noticed that if I abruptly turn the power off about one second after
issuing a commit, when I power my Windows based computer back on the last
transaction is rolled bac
I'm sure I must be doing something wrong. This is my first attempt at
working with SQLite.
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
insert per transacion - I know this is not optimal, but it
How can you be sure? It appears from that ticket that
there is something wrong with the default binary for
Windows (I've verified the relocation problem myself).
I can imagine that the more tight security on win2k3
(sp1) simply doesn't want to load the DLL when it is
not 100% "ok"? It sounds prett
31 matches
Mail list logo