Re: [sqlite] sqlite3_analyzer source code

On Tue, 15 Apr 2014 22:34:40 +0200, Marco Bambini wrote: > If I remember correctly, sqlite3_analyzer is a python script... > I am not able to find its source code since in the download > page there is a binary app only. > > Any help? The sources are available in the online

Re: [sqlite] sqlite3_analyzer source code

On Tue, Apr 15, 2014 at 4:34 PM, Marco Bambini wrote: > If I remember correctly, sqlite3_analyzer is a python script... I am not > able to find its source code since in the download page there is a binary > app only. > It is a TCL script. The source code is here:

[sqlite] sqlite3_analyzer source code

If I remember correctly, sqlite3_analyzer is a python script... I am not able to find its source code since in the download page there is a binary app only. Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

Re: [sqlite] Database access slowness on specific WinCE devices

On 15/4/2014 3:36 PM, Joe Mistachkin wrote: It might be useful to measure the processor and storage performance of the device, using some external benchmarking tool, and then compare it against the other devices you have. If the disk performance is indeed slower on this particular device,

Re: [sqlite] cannot set connection while a datareader is active

Hello Joe, i'm here for try but i cannot find how to test _activeReader method as you say...could you tell me how to test it? 2014-04-15 10:19 GMT+02:00 rava : > How could i do this? By debugging and adding a watch to the object? > > > > Joe Mistachkin

[sqlite] Bug report: .import csv (wiki) documentation error (sqlite 3.7.17)

Hi, while sqlite documentation on .import is generally a bit sparse (or I haven't found it), searching for it prominently yields this wiki page: http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles The information given there seems out of date and partly incorrect. Contrary to "[...]

Re: [sqlite] Problems with executereader in System.Data.SQLite

On 15 Apr 2014, at 10:14am, Ralf wrote: > Yes. Everything is Working as expected when i access the DB with any Browser. > It is just the powershell environment Then the chances are that the problem is with PowerShell, not SQLite. Simon.

Re: [sqlite] Problems with executereader in System.Data.SQLite

On 15. April 2014 09:46:43 MESZ, Joe Mistachkin wrote: > >Ralf wrote: >> >> I just tried... No change :-( >> > >Have you looked at the contents of the database using the SQLite >command >line tool for Windows? > >

Re: [sqlite] cannot set connection while a datareader is active

How could i do this? By debugging and adding a watch to the object? Joe Mistachkin ha scritto: > >Stefano Ravagni wrote: >> >> So what have i do? Need to see others setting or state? >> > >It would be useful to try and examine the internal state of the >SQLiteCommand and

Re: [sqlite] Problems with executereader in System.Data.SQLite

Ralf wrote: > > I just tried... No change :-( > Have you looked at the contents of the database using the SQLite command line tool for Windows? https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > So what have i do? Need to see others setting or state? > It would be useful to try and examine the internal state of the SQLiteCommand and see if the _activeReader member is valid. If it is valid, see if it actually refers to the data reader you are using. -- Joe

Re: [sqlite] Database access slowness on specific WinCE devices

Phua Si Jie wrote: > > The performance degrades only happen on that kind of WinCE devices. > > Any clue for further investigation? > It might be useful to measure the processor and storage performance of the device, using some external benchmarking tool, and then compare it against the other

Re: [sqlite] Problems with executereader in System.Data.SQLite

On 15. April 2014 01:55:40 MESZ, Joe Mistachkin wrote: > >Ralf Jantschek wrote: >> >> The connection as such is ok. Updates are working. It is only the >> executereader that is troubling me >> > >For database files that need a UNC path, four leading backslashes are