[sqlite] Horrendous slowdown when updating versions

Hi all, I was running a system using an old sqlite3.dll (version 3.0.8, I believe). Updating to the latest version (3.6.23) causes my program to run incredibly slowly. As an example, selecting approximately 30,000 records was taking 10 seconds with the old dll, and with the updated version

Re: [sqlite] Nested Inner Join Help

n the same transaction be able to reference c2, or does the reference only persist in the statement in which c2 was defined? Ed Igor Tandetnik wrote: > Ed Hawke wrote: > >> All I meant was that in a database you have defined tables with >> defined column names. These are defin

Re: [sqlite] Nested Inner Join Help

mplicated. Ed Igor Tandetnik wrote: > Ed Hawke wrote: > >> By run-time defined fields I meant column names that SQL would not >> recognise until the query was executed >> > > I don't get the distinction. Could you give an example of column names > that SQL would

Re: [sqlite] Nested Inner Join Help

Thank you again Igor. By run-time defined fields I meant column names that SQL would not recognise until the query was executed, and therefore are only defined when the statement is "run". I am aware that this is probably not the correct terminology. Ed Igor Tandetnik wrote:

Re: [sqlite] Nested Inner Join Help

= b2.ID) join C c2 on (b2.Column1 = c2.ID) join D d2 on (b2.Column2 = d2.ID); where d2.ID = ? Would that work? Regards, Ed Igor Tandetnik wrote: > Ed Hawke > <edward.ha...@hawkeyeinnovations.co.uk> wrote: > >> To clarify this (I hope) if my table set-up is:

Re: [sqlite] Nested Inner Join Help

umn1, C.Column1 > FROM A > INNER JOIN B ON A.Column3 = B.ID <http://b.id/> > INNER JOIN C ON B.Column2 = C.ID <http://c.id/> > > ? > > On Thu, Jul 2, 2009 at 2:53 PM, Ed Hawke > <edward.ha...@hawkeyeinnovations.co.uk > <mailto:edward.ha...@hawkeyeinnovation

[sqlite] Nested Inner Join Help

Hi all, I'm having problems getting nested inner joins to work with SQLite. As far as I can tell from various resources the correct way of joining multiple tables is this: SELECT A.ID, A.Column1, A.Column2, B.Column1, C.Column1 FROM A INNER JOIN B (INNER JOIN C ON B.Column2 = C.ID) ON

[sqlite] Binding with Views

Hi all, I have an SQL application that relies on using views to allow a user to make an array of choices to filter down the information returned to them from multiple tables, without having to code complex statements to take into account the order in which they need to be applied. To speed up

[sqlite] Where to use PRAGMAs

Hi all, I'm using a C++ wrapper to SQLite (CppSQLite3) and want to be able to set the temp_store, page_size, cache_size etc. I am currently doing this directly after opening the database (but before creating any tables) with the sqlite3_exec statement, however when I come to do anything to