That's not exactly correct. On modern systems, unless you exhaust memory
you'll never hit the journal (in which case you'd need a journal- but
read on). What you really want is to run the database without syncing.
You _can_ comment this code out in os.c- but I wouldn't recommend it.
The time is so
will someone have mercy on an ignorant beginner?
The old yahoo digest could be saved as a single text
file, which I did, trying to build a sort of
'unofficial FAQ' for myself.
The new digest, will only save the 'contents' page,
and each post must be saved individually.
Does someone know of a way
Hello,
I am aware that:
1) Reading from the database doesnt involve opening a journal file.
2) Writing (INSERT, UPDATE etc) to the database opens a journal file on the disk.
3) PRAGMA default_synchronous = OFF; (0) is to turn on sync ON or OFF.
I am writing to a database file every 200ms on
Monday, October 27, 2003, 9:22:57 AM, D. Richard Hipp wrote:
> If you think about how a disk driver works, you'll quickly realize
> that to truly commit a transaction to the disk surface requires at
> least one revolution of the platter. So for a 5400 RPM disk drive,
> you will get (at most) 90 tr
hello everybody:
I am newbie to both sql and sqlite and i am testing sqlite for a specifc
multi-variate application for in-memory database.
>From the documentation I see that it is not possible to do alter table and
add new columns. But the documentation mentions deleting and adding the
table wit
On Sun, 26 Oct 2003 23:36:55 -0500
"Mrs. Brisby" <[EMAIL PROTECTED]> wrote:
> It's good to use null-terminated in many cases; especially in collating
> and sorting. It helps to understand that in those cases you stop
> processing _after_ you see the terminator (and treat the terminator as
> it is:
> Danny Reinhold wrote:
> > DRH tested inserts with and without transactions on several
> > DBMSs. PostgreSQL and MySQL where faster _without_
> > explicit transactions.
> > That looks a bit strange to me...
> If you are referring to Test 1 and Test 2 at
http://www.sqlite.org/speed.html,
> please l
Danny Reinhold wrote:
DRH tested inserts with and without transactions on several
DBMSs. PostgreSQL and MySQL where faster _without_
explicit transactions.
That looks a bit strange to me...
If you are referring to Test 1 and Test 2 at http://www.sqlite.org/speed.html,
please look again. The transa
Hi!
> I am putting finishing touches on quite a large application that uses
Sqlite
> for the single user edition. My experience has been that inserting data
is
> quite slow in comparison to most other dbs. All other operations are
faster
> than any other db. It appears that Sqlite is highly opt
Jonas Forsman / Axier.SE wrote:
Has anyone tested and concluded that sqlite is faster for small databases (<5000 records)
so I don't sit here in vain, trying to optimize for something that just can't be done?
http://www.sqlite.org/speed.html.
--
D. Richard Hipp -- [EMAIL PROTECTED]
Allan Edwards wrote:
If my instincts and research is correct, most other databases simply cache
the transactions in memory to give the appearance that they are inserting
very quickly, but the truth is they are probably not quite as safe as Sqlite
since it writes the data to disk immediately upon re
I am putting finishing touches on quite a large application that uses Sqlite
for the single user edition. My experience has been that inserting data is
quite slow in comparison to most other dbs. All other operations are faster
than any other db. It appears that Sqlite is highly optimized for S
On 27 Oct 2003, at 5:20, Greg Obleshchuk wrote:
So if anyone is using SQLite in a web application that is used by lots
of
people I would love to here about any problems or just of your success.
I have a *very* large scale web application using SQLite as a backend,
but we segment it sensibly. Cro
Hi again,
> > The file extension doesn't matter.
> I think it matters.
I meant: SQLite does not force you to use a specific extension.
It will work with .sqlite, .db, . files and even with
files that don't have an extension.
So technically the extension doesn't matter...
> > You should either use
<[EMAIL PROTECTED]> wrote :
> Hi,
>
>> Is there a recommended file extension for sqlite database files ? If not,
>> are there any suggestions or a commonly used extension ? What about
> .sqlite
>> or .db ?
> The file extension doesn't matter.
I think it matters.
> You should either use an exten
> select * from mytable where a like 'b%';
> may be slow - even if a is an indexed column.
> select * from mytable where a >= 'ba' and a <= 'bz';
> may be very fast.
Ahhh, sorry, I meant:
select * from mytable where a > 'a' and a < 'c';
should be better...
- Danny
--
Danny Reinhold
Reinhold S
Hi,
> Is there a recommended file extension for sqlite database files ? If not,
> are there any suggestions or a commonly used extension ? What about
.sqlite
> or .db ?
The file extension doesn't matter.
You should either use an extension that explains what kind of data
is stored in the file (for
Hi!
I have recently converted a "problem application" from MS-Access to
SQLite
in Visual Basic but the performance is really worse then with Access.
I have not
changed much in the application code except for a few things that
should be in favour
to sqlite, like implementing
Hi,
Is there a recommended file extension for sqlite database files ? If not,
are there any suggestions or a commonly used extension ? What about .sqlite
or .db ?
Thanks,
Bertrand Mansion
Mamasam
-
To unsubscribe, e-mail: [E
What about transactions? Are you useing them?
--
Regards
Michal Zaborowski (TeXXaS)
http://sqlite4delphi.sourceforge.net/
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi,
I have recently converted a "problem application" from MS-Access to SQLite
in Visual Basic but the performance is really worse then with Access. I have not
changed much in the application code except for a few things that should be in
favour
to sqlite, like i
Hello,
v t <[EMAIL PROTECTED]>
27/10/2003 05:16 PM
To: "Mrs. Brisby" <[EMAIL PROTECTED]>
cc: sqlite <[EMAIL PROTECTED]>
Subject:Re: [sqlite] Journalling
> I am trying to use sqlite in a context where I will be using it to store
some configuration a
I am trying to use sqlite in a context where I will be using it to store some
configuration about a system. I want to try to minimize the disk access. Since
journalling uses a file on the disk, I wanted to turn it off. I am not worried about
rolling back the database to a known state in case of
23 matches
Mail list logo
