[prev in list] [next in list] [prev in thread] [next in thread]
List: sqlite-users
Subject: [sqlite] About Sqlite cache
From: yoky <yokykk () gmail ! com>
Date: 2008-12-22 9:33:25
Message-ID: e3c3cc550812220133g7062166em583d290cc11c2339 () mail ! gmail ! com
[Download RAW message or body]
Hi all,
I have some question about Sqlite cache:
1. In the Sqlite docs, It's said :" If you are doing
UPDATEs<http://www.sqlite.org/lang_update.html>or
DELETEs <http://www.sqlite.org/lang_delete.html> that change many rows of a
database
and you do not mind if SQLite uses more memory, you can increase the
cache size for a possible speed improvement."
Why only UPDATEs <http://www.sqlite.org/lang_update.html> or
DELETEs<http://www.sqlite.org/lang_delete.html>? Does INSERTs or
SELECTs speed have no relationship with Sqlite cache?
2. Cache was malloced in a transaction, and was freed at the end of a
transaction, is right?
3. Please intrduce the implement of cache mechanism in Sqlite.
Thanks very much!
Yoky
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic