One reason might be that SQLite does not usually include anything that
can be just as well implemented externally.
I could be missing something, because I'm not really sure of the advantages
of stored procedures, but it seems to me that an implementation could be
created without modifying
> I can imagine a protocol that will improve performance by keeping track
> of whether the database was updated, which would allow a quick
> determination whether a program's cache was still valid. The idea is to
> increment a 'version number' in the database file as soon as a program
> obtains a
Sean Heber wrote:
>
>
> My database file is only around 4MB and I have set the
> default_cache_size to 5. From what I've read, that should
> translate to almost 50MB of cache size which would be more than
> enough to keep the entire database in memory, I'd think. Yet it
> doesn't seem
I just recently switched from sqlite 2.8.14 to
3.2.2. Since switching, I've seen a few
SQLITE_CORRUPT errors returned from sqlite_exec.
However, almost all queries work - this error seems to
only indicate a transient condition.After
receiving the error, my process closes the connection
At 3:34 PM -0400 6/14/05, D. Richard Hipp wrote:
On Tue, 2005-06-14 at 20:18 +, [EMAIL PROTECTED] wrote:
I have textual data that may look like integers (eg. "0325763213").
On insertion, any leading "0" will vanish. How do I prevent this
and make the data be inserted verbatim?
Simple
My program has a lot of simple select queries. Most of them are of
the "select count() from... " variety. These are very simple queries
where there is a single WHERE clause and the columns referenced are
either a primary key column or another indexed column.
I would expect the database
[EMAIL PROTECTED] wrote:
I have textual data that may look like integers (eg. "0325763213").
On insertion, any leading "0" will vanish. How do I prevent this
and make the data be inserted verbatim?
Simple illustration:
sqlite3 test 'create table t ( k text unique, v text);'
perl -e
I have textual data that may look like integers (eg. "0325763213").
On insertion, any leading "0" will vanish. How do I prevent this
and make the data be inserted verbatim?
Simple illustration:
sqlite3 test 'create table t ( k text unique, v text);'
perl -e 'use DBI; $db = DBI->connect(
Thaks for the suggestions!
I'm going to try to do the query without the LIMIT keyword, and then
only use the rows I need.
I'm not sure if you can get a "pointer" and then only fetch the rows you
need in TCL, but I'll see if that is possible.
The program I'm writing must be able to run on rather
9 matches
Mail list logo