On Tue, Apr 01, 2008 at 08:17:54PM -0500, Mike Owens scratched on the wall:
> The main reason why SQLite's practical limit is in the 10s of GBs as
> opposed to TBs (theoretical) is due to how it tracks dirty pages.
> [...]
> SQLite tracks dirty pages with a bitmap which is
> allocated before each
The main reason why SQLite's practical limit is in the 10s of GBs as
opposed to TBs (theoretical) is due to how it tracks dirty pages. This
is described in the "Appropriate Uses" page
(http://www.sqlite.org/whentouse.html) but I'll rehash it here for
convenience. SQLite tracks dirty pages with a bi
Mike,
You guessed correctly! I inserted a "PRAGMA synchronous = NORMAL;"
into the SQLite 3 version of my test suite, and obtained the same
performance as I observed with SQLite 2.
I should have realized that the kind of slowdown I was observing
could only be explained by extra disk I/O operation
The only limitation imposed by SQL that I can think of would be
inefficiencies in its query plan builder. That is the part that
figures out how to use the indexes available in the database in order
to execute the SQL query most efficiently. So it really depends on
what type of SQL queries you are g
Hello All,
Is it possible that SQLite deadlocks if it uses attached databases?
I am not sure, but if check_all_db_and_lock_all_of_them() is not
atomic, it can be...
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
___
Hi all!
Very often, when people ask this list why they have trouble managing in sqlite
a "big table" (50 million lines or more than 10 Go), they are told that sqlite
is an embedded database and is not meant to be used for very big
databases/tables.
I'm currently in the process of designing a
How are you verifying that the db only received one line from the
description? using sqlite3.exe or some other tool, or AIR?
SQLite itself does not have issues with storing line breaks, but it's
possible the AIR wrapper is losing them somewhere or more likely it's a
display/formatting issue.
One
> Hi, all.
>
> I have the following problem: I have some processes that access the same db
> file. When one of them would change some data inside the db it must notify
> all other processes about change AND send them changed data (or it's unique
> description).
>
> But I didn't find any method t
On Apr 1, 2008, at 2:37 PM, Richard Klein wrote:
>>
> Fair enough. But can I assume that mem5 *does* currently
> work, as far as you know? (I'd really like to use it, as
> I'm using SQLite on an embedded system.)
>
mem5 works as far as I know.
D. Richard Hipp
[EMAIL PROTECTED]
_
Hi,
I'm trying to run sqlite using the java wrapper at
http://www.ch-werner.de/javasqlite/ on an arm linux target using kaffe
1.1.7 and jamvm.
It appears that I'm having a problem with the JNI layer. I am able to
run $sqlite3 from the command line, creating/editing database files with
no probl
> On Mar 31, 2008, at 10:00 PM, Richard Klein wrote:
>> I just downloaded 3.5.7, and noticed that there is a
>> new memory allocator mem5.c, which apparently uses the
>> "buddy system" to allocate power-of-two-sized chunks
>> of memory from a static pool. This allocator is used
>> by defining SQLI
"Vladimir Volkov"
<[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I have the following problem: I have some processes that access the
> same db file. When one of them would change some data inside the db
> it must notify all other processes about change AND send them changed
> data (
Hi, all.
I have the following problem: I have some processes that access the same db
file. When one of them would change some data inside the db it must notify
all other processes about change AND send them changed data (or it's unique
description).
But I didn't find any method to perform this
Hi Dennis, may be I understand now.
I have enabled mail delivery in my sqlite users account options (which was
not enabled before), now I should receive all messages so that I can reply to
one of them.
May be it was my problem, because I have never received any message from
sqlite user m
On 3/31/08, Jim Dodgen <[EMAIL PROTECTED]> wrote:
> It makes ok, here is the output from "make test". the hang is after
> "t/06error" it never finishes
>
> DBD-SQLite-Amalgamation-3.5.7
>
> # make test
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib/l
15 matches
Mail list logo