Re: [sqlite] how to get SQLite 4 source?

2012-06-30 Thread E. Timothy Uy
Hi Darren, 1. Install Fossil - http://www.fossil-scm.org. 2. At a command prompt or console, 'fossil clone http://www.sqlite.org/src4sqlite4.fossil'. 3. (Not sure if this the right way) From here I usually 'mkdir sqlite4_src', 'cd sqlite_src', then 'fossil open ../sqlite4.fossil' Respectfully,

Re: [sqlite] An interesting (strange) issue with selects

2012-06-30 Thread Dennis Volodomanov
On 30/06/2012 12:57 PM, Kees Nuyt wrote: Is the database file in a protected folder (that is, \Program Files, or somewhere in the Windows system software tree) ? It shouldn't be. Data belongs somewhere else. Either in your userprofile/appdata or in a completely separate dirtree that Microsoft

Re: [sqlite] An interesting (strange) issue with selects

2012-06-30 Thread Marcus Grimm
Here is another theory: Maybe you run into an issue with Windows 7 Virtualization, I did run into a similar effect with the registry access/write sometime go - mainly with Windows 7 Home Editions, by reading this: http://support.microsoft.com/kb/927387/EN-US It suggests that something similar

Re: [sqlite] An interesting (strange) issue with selects [solved]

2012-06-30 Thread Dennis Volodomanov
On 30/06/2012 7:47 PM, Marcus Grimm wrote: Here is another theory: Maybe you run into an issue with Windows 7 Virtualization, I did run into a similar effect with the registry access/write sometime go - mainly with Windows 7 Home Editions, by reading this:

Re: [sqlite] An interesting (strange) issue with selects

2012-06-30 Thread Kees Nuyt
On Sat, 30 Jun 2012 18:32:58 +1000, Dennis Volodomanov i...@psunrise.com wrote: On 30/06/2012 12:57 PM, Kees Nuyt wrote: Is the database file in a protected folder (that is, \Program Files, or somewhere in the Windows system software tree) ? It shouldn't be. Data belongs somewhere else.

Re: [sqlite] An interesting (strange) issue with selects [solved]

2012-06-30 Thread Marcus Grimm
Am 2012-06-30 12:06, schrieb Dennis Volodomanov: On 30/06/2012 7:47 PM, Marcus Grimm wrote: Here is another theory: Maybe you run into an issue with Windows 7 Virtualization, I did run into a similar effect with the registry access/write sometime go - mainly with Windows 7 Home Editions, by

Re: [sqlite] An interesting (strange) issue with selects

2012-06-30 Thread Dennis Volodomanov
On 30/06/2012 8:22 PM, Kees Nuyt wrote: Mind you, there is a difference between the special folders (=symbolic path names) : AppDataFolder = Full path to the Roaming folder for the current user and CommonAppDataFolder = Full path to application data for all users. and

Re: [sqlite] SQLite4 (don't scream)

2012-06-30 Thread Jim Morris
Are there significant improvements in speed for existing SQL? How does the compiled size compare with SQLite3? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite4 (don't scream)

2012-06-30 Thread Stephan Beal
On Fri, Jun 29, 2012 at 8:33 PM, Jim Morris j...@bearriver.com wrote: Are there significant improvements in speed for existing SQL? In my _simple_ tests (which run _almost_ the same ops through mysql5, sqlite3, and now sqlite4), i'm seeing _huge_ boosts in speed in v4 (25x over v3!) BUT: a)

Re: [sqlite] System.Data.Sqlite extension function - performing INSERT

2012-06-30 Thread Joe Mistachkin
Brad Hards wrote: Is there a workaround to get at the underlying connection from my extension function class? Not easily because they are technically not associated with a particular connection (i.e. they are simply imported into each opened connection from a static list. Is there