Re: [sqlite] Virtual table used to query big external database

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

Re: [sqlite] Virtual table used to query big external database

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

Re: [sqlite] 2.8.17 --> 3.5.6 performance regression

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

Re: [sqlite] Virtual table used to query big external database

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

[sqlite] Deadlock with attached databases

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 ___

[sqlite] Virtual table used to query big external database

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

Re: [sqlite] insert of string with line breaks

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.

Re: [sqlite] Trigger's actions and callbacks

> 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

Re: [sqlite] mem5 ("buddy system") usable?

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]

[sqlite] Exception running javasqlite on kaffe for arm architecture

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

Re: [sqlite] mem5 ("buddy system") usable?

> 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

Re: [sqlite] Trigger's actions and callbacks

"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

[sqlite] Trigger's actions and callbacks

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

Re: [sqlite] sqlite-users Digest, Vol 3, Issue 99

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

Re: [sqlite] DBD::SQLite::Amalgamation?

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,