>> For example, say you have two databases in a transaction - mine.db
>> and yours.db. A crash happens while committing the transaction
>> and the file mine.db-mjMASTER is left in the file-system.
>>
>> Following recovery, if a process tries to read mine.db, the
>> transaction on mine.db will be
On Fri, Feb 25, 2011 at 09:30:00PM -0500, Dariusz Matkowski scratched on the
wall:
> I am trying to implement a simple virtual table that reads in a file
> with two columns and "::" separator. My question is: is it necessary
> to implement xBestIndex to run a simple where clause queries?
You
hi all,
new to the list.
we are compiling the sqlite.c amalgamation file into our project, as we
want to encrypt the database, and the sqlite that comes with the iOS sdk does
not allow for that.
we are developing on iOS 4.2, and to date have tried 3 different
versions
Hi all,
I am trying to implement a simple virtual table that reads in a file with two
columns and "::" separator. My question is: is it necessary to implement
xBestIndex to run a simple where clause queries?
Thank you.
-
This
Quoth Johns Daniel , on 2011-02-25 16:21:54 -0600:
> Thank you very much for this info, Dan! Very useful.
>
> >From your description, it sounds like this requirement only applies if
> there are 3 or more databases. Is this an issue with 2 databases?
Yes, master journals
On Fri, Feb 25, 2011 at 12:04 PM, Dan Kennedy wrote:
> On 02/26/2011 12:30 AM, Johns Daniel wrote:
>> What is the reason was for having random filenames for the SQLite
>> master journal file (like mine.db-mj501CA440, mine.db-mj1C17,
>> mine.db-mj66677495, etc)?
>>
>>
this test in types3 says that the type is ""
do_test types3-2.5 {
set V [db one {SELECT '1234567890123456.0'}]
tcl_variable_type V
} {}
however when I try it from the command line i get text
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
On 02/26/2011 12:30 AM, Johns Daniel wrote:
> What is the reason was for having random filenames for the SQLite
> master journal file (like mine.db-mj501CA440, mine.db-mj1C17,
> mine.db-mj66677495, etc)?
>
> Here is the reason for this strange question. We have discovered that
> the JFFS2
What is the reason was for having random filenames for the SQLite
master journal file (like mine.db-mj501CA440, mine.db-mj1C17,
mine.db-mj66677495, etc)?
Here is the reason for this strange question. We have discovered that
the JFFS2 filesystem in Linux is leaking kernel memory each time we
I will be out of the office starting 02/24/2011 and will not return until
02/28/2011.
I will respond to your message when I return.
If necessary please contact M. Fahloul
*
The information contained in this
I had tried on sqlite version 3.7.4.
Let me check it on sqlite version 3.7.5.
Thanks,
Madhav
On Thu, Feb 24, 2011 at 9:19 PM, Richard Hipp wrote:
>
>
> On Thu, Feb 24, 2011 at 4:52 AM, Maddy wrote:
>
>> Hi,
>> I have 4 "SELECT" queries which are
thank you for the advice, I found even this:
http://www.sqlite.org/malloc.html#memstatus
that describe the possibility to set the memory usage limit
Il 25/02/2011 14.24, Marco Bambini ha scritto:
> Michele take a look at the sqlite3_status function:
> http://www.sqlite.org/c3ref/status.html
> and
Michele take a look at the sqlite3_status function:
http://www.sqlite.org/c3ref/status.html
and
http://www.sqlite.org/c3ref/c_status_malloc_count.html
--
Marco Bambini
http://www.sqlabs.com
On Feb 25, 2011, at 2:17 PM, Michele Pradella wrote:
> Do you know if is there a way to ask to the
Do you know if is there a way to ask to the sqlite library the amount of
memory that is using?
It could be useful when I have to take a look to the memory used in my
application. So I can distinguish between memory allocated by my
application itself and allocated by sqlite library.
It's
On Fri, Feb 25, 2011 at 1:51 AM, Greg Barker wrote:
> I ran my tests again, this time setting the cache_size based on the
> page_size. For some reason I wasn't able to replicate the timing I got
> before for the 1024 page size (40.2 seconds) which is really confusing me,
>
On 24 Feb 2011, at 10:51pm, Greg Barker wrote:
> What do
> you do if there could be anywhere between 30-150 columns?
I would never have any table with 150 columns. It should be possible to keep
the schema for your table in your head.
> Optimizing performance
> for an application where both
I ran my tests again, this time setting the cache_size based on the
page_size. For some reason I wasn't able to replicate the timing I got
before for the 1024 page size (40.2 seconds) which is really confusing me,
since I was careful to make sure nothing was running in the background while
I was
Average payload per entry for my test table was 409.00. Sounds about right
since the db has 4 columns and each is filled with a random string of length
100.
I've uploaded the full output from the sqlite3_analyzer for a few different
page sizes:
http://fletchowns.net/files/1024-analyzer.txt
18 matches
Mail list logo