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 a

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

2012-06-30 Thread Stephan Beal
On Fri, Jun 29, 2012 at 8:33 PM, Jim Morris 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) this is not necess

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] 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 Local

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 rea

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 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. Either i

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: http://support.microsoft.com/kb/927387/

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 ca

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