Re: [sqlite] Optimizing insert or replace speed

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

Re: [sqlite] range enclosing a number

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

Re: [sqlite] Optimizing insert or replace speed

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

Re: [sqlite] [Columns] Keeping internal + beautified names?

"Gilles Ganault" schrieb im Newsbeitrag news:0sap559atknanmiv8g83pdj6f83e8ve...@4ax.com... > On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen > wrote: > >I would just use: > > > >SELECT id AS Identification FROM foobar > > Thanks. This is what I already use

[sqlite] Optimizing insert or replace speed

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

Re: [sqlite] [Columns] Keeping internal + beautified 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

Re: [sqlite] [Columns] Keeping internal + beautified names?

On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen 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

Re: [sqlite] New Book Available

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

[sqlite] Announce of the new "Versioning" extension

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

Re: [sqlite] Reading year from YYYY-MM-DD column?

On Tue, 30 Jun 2009 07:54:13 -0500, P Kishor wrote: >sqlite> SELECT strftime('%Y', '1999-12-03') AS year; Thanks guys. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to access tables in multiple sqlite databases

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

[sqlite] how to access tables in multiple sqlite databases

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

Re: [sqlite] range enclosing a number

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

[sqlite] FW: range enclosing a number

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

Re: [sqlite] range enclosing a number

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