Thank you everybody for the incredible help.
Maybe is better if I explain more the problem:
I need to do piecewise linear interpolations between two very large sets of
numbers. The interpolation is the reason I was using = and=). One set
represents clock ticks (46 bits integers) and the other
Sorry if you receive twice this email:
Thank you everybody for the incredible help.
Maybe is better if I explain more the problem:
I need to do piecewise linear interpolations between two very large sets of
numbers. The interpolation is the reason I was using = and=. One set
represents
Not to continue argument with Jay but just to express my opinion in comparison:
The ORDER/LIMIT approach is much more resilient to changes, however,
and should more or less behave the same no matter what you do to the
rest of the query.
Seriously, I don't believe this. There's no way to
Hi guys,
I have multiple sqlite databases in hand, and I would like to perform the
following several tasks:
. two tables with the same schema are in two dbs, and I want to apply a sql
query to the two tables efficiently (merge them into one table? Merge cost is
also considered as the total
Hi,
see http://www.sqlite.org/lang_attach.html
you attach a second database, giving it a name, and prepend this name to
the table name.
Martin
Zhenyu Guo schrieb:
Hi guys,
I have multiple sqlite databases in hand, and I would like to perform the
following several tasks:
. two tables
On Tue, 30 Jun 2009 07:54:13 -0500, P Kishor
punk.k...@gmail.com wrote:
sqlite SELECT strftime('%Y', '1999-12-03') AS year;
Thanks guys.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello!
This may be used for table versioning and replication.
Source code is available here
http://mobigroup.ru/files/sqlite-ext/
You can get from the debian repository the SQLite build with some extra
extensions:
deb http://mobigroup.ru/debian/ lenny main contrib non-free
deb-src
Hello!
On Thursday 09 July 2009 17:50:14 cmar...@unc.edu wrote:
What is the title? I am not finding a new book by van der
Laans book on Google or Amazon.
As Rick wrote to me:
The book is finished and available through the Publisher Lulu.com. It will
be available through Amazon and so on with
On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen
j...@dodgen.us wrote:
I would just use:
SELECT id AS Identification FROM foobar
Thanks. This is what I already use for displaying the results, but
then I'm stuck when I need to perform INSERT/UPDATES because I need to
get the actual columns names
For overall performance and efficiency, I recommend you keep the pretty in
the GUI where such things are traditionally implemented. Pick two of three:
COOL, Fast, Tight.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of
Good day,
Could someone explain where I'm going wrong with this?
I've identified the following query as a bottle neck in a utility I've
written.
insert or replace into main.masterlist select * from delta.masterlist d
where d.write_out_ok=0 and
d.sn not in(select M.sn from main.masterlist M
Gilles Ganault gilles.gana...@free.fr schrieb im
Newsbeitrag news:0sap559atknanmiv8g83pdj6f83e8ve...@4ax.com...
On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen
j...@dodgen.us wrote:
I would just use:
SELECT id AS Identification FROM foobar
Thanks. This is what I already use for displaying
I believe your choice of query is not good enough. Try this one:
insert or replace into main.masterlist
select d.*
from delta.masterlist d left outer join main.masterlist M on d.sn = M.sn
where d.write_out_ok=0
and d.record_updatetime = ifnull(M.record_updatetime, '')
Pavel
On Tue, Jul 14, 2009 at 07:32:25AM -0400, Pavel Ivanov scratched on the wall:
Not to continue argument with Jay but just to express my opinion in
comparison:
The ORDER/LIMIT approach is much more resilient to changes, however,
and should more or less behave the same no matter what you
Awesome, brilliant, and decisive!
New times:
No index on Delta File:
3 seconds.
Index on SN:
4 seconds.
Index on MasterList (write_out_ok, MFGID, TypeID, SN);
4 seconds.
The speedup of the one query is greater than this because the above time
figures include
1) A query to see if there are any
15 matches
Mail list logo