tring literals. My concern is, though,
that this might break many existing applications.
What opinion do you, gentle users, have of this matter?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlit
her than a file. You do not have to modify any of the
core SQLite code to do this, but you do need to write your own VFS
module, which will require that you have a deep understanding of how
the SQLite core operates.
D. Richard Hipp
[EMAIL PROTECTED]
_
havior is unchanged when extended result
codes are disabled, fixing legacy test cases, writing new test cases,
and so forth. This is at least one full day's worth of uninterrupted
work to get right. And the benefit does not seem worth the effort
right now. We have bigger fish to fry.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
meaningful speed comparison, then speed1.test
should probably be modified to set PRAGMA synchronous=OFF.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
fferent
machines, please at least audit the speed1.test script first to see if
it is appropriate for the job.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s" as
having its own address space - but not everybody does - and there are
people who don't that really want to be able to run SQLite on their
systems.)
(6) New test harnesses and requirements-based test cases that give
100% branch coverage and that can be run on embedded syst
iguration management system (used to control the
documentation of SQLite - see http://www.fossil-scm.org/ for details
and http://www.sqlite.org/docsrc/timeline for an example) calls
system() after sqlite3_open() in multiple places and it works just
fine on Linux, OSX, various other flav
;" -
> this one is failing.
>
Works when I try it.
But I'm not running on windows. Do you really need two backslashes in
the filename? Should there be just a single backslash? You do not
quote backslashes in SQL strings as you do in C.
D. Richard Hipp
[EMAIL PROTECTED]
tabase.
>
> Regards
> Daniel
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
at would explain where the memory
is going, would it not? We will need quite a bit more information
from you if we are to help you debug your problem.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
CREATE INDEX newidx1 ON fs_main(fs_itemtype, fs_textid);
See http://www.sqlite.org/optoverview.html#like_opt
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 15, 2008, at 12:33 PM, Jeff Godfrey wrote:
>
> I'm writing a Tcl-based application that manages a pool of separate
> SQLite database files. ... Is it safe for me to blindly open the
> other database
> and grab the record I need?
Yes.
D. Richard H
gt; after
> values?
Generate an equivalent database in a disk file. Then run the disk
file through the sqlite3_analyzer utility which you can download from
the website.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-
TTACHed database). Change cache sizes using separate cache_size
pragmas for each attached database.
Please also note that in the next release (SQLite version 3.6.2) the
cache_size pragma will probably become a no-op. We are working on
alternative mechanisms to control the amount of cache
gt; set
> before the error. So I've been wondering if there's any halfway nice
> and
> clean solution for this, or if I'm maybe just missing an existing
> feature.
Lemon does not have any feature that will provide the application with
access to the follow-set
gt; mapelements_rtree.NELON>=7900 and
> mapelements_rtree.SWLON<=8000 and
> mapelements.ID=mapelements_rtree.ID;
Please try changing the last term as shown below (add a "+" before the
r-tree ID column):
mapelements.ID = +mapelements_rtree.ID
Let us kn
u type:
make sqlite3_analyzer
The sqlite3_analyzer.exe for windows is built by cross-compiling. You
can maybe get this to build natively on windows, but it will likely
require some work.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailin
On Aug 18, 2008, at 2:17 PM, Darren Landrum wrote:
> An object of the class Preset will have the functions to load a
> database into memory
Why do you want to load the database into memory? Why not just open
it and use it off of disk?
D. Richard Hipp
[EMAIL PRO
ould be the combination of the OS disk
cache and SQLite's internal page cache will make actual disk I/O
relatively rare, even for an on-disk database.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.
ny
reason why that wouldn't work.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 19, 2008, at 9:37 AM, Jeffrey Becker wrote:
> So in the cases where the lock cant be acquired, the built in vfs
> implementations return SQLITE_BUSY?
>
Yes
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sql
> execute a simple PRAGMA
> statement. If anyone knows of a solution to this problem I would
> appreciate the help.
>
What else have you changed other than 3.5.7 -> 3.6.1? If you pull
out 3.6.1 and recompile with 3.5.7 again does the problem go away?
I do not recall making any
On Aug 19, 2008, at 11:14 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
wrote:
> Are there
> any problems with creating the database with 3.5.7 and then reading
> it with 3.6.1?
There are not suppose to be any difference. Nobody else has reported
differences.
D
a AS b, b AS a WHERE a=2;
SELECT a AS x, b AS x WHERE x=1;
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e SQLite
website) over that file and post the results. The sqlite3_analyzer
utility will give us additional information that might suggest ways of
reducing the size of the database file.
See also http://www.hwaci.com/sw/sqlite/prosupport.html#compress
D. Richa
28MB figure? The sqlite3_analyzer output you
posted tells me that the total database size is a little over 9MB, not
28MB.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
ge by the application. It is not at
all clear to me that SQLite was using all 28 MB. What does
sqlite3_memory_highwater() tell you?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
On Aug 20, 2008, at 2:22 PM, Brown, Daniel wrote:
> sqlite3_memory_highwater() ~ 25673060
> sqlite3_memory_used() ~ 23222709
>
OK. I'll have a look....
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@s
'm seeing the in-memory database use about
15% more space than the on-disk database. I'm not sure what you are
doing to get 3x memory usage.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s been fixed since 3.6.1 that causes it to
use less memory.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
(~2MB)
http://www.fossil-scm.org/index.html (~6MB)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 13, 2008, at 10:59 AM, Dennis Cote wrote:
> D. Richard Hipp wrote:
>>
>> (2) Formal and detail requirements that define precisely what SQLite
>> does.
>>
>> http://www.sqlite.org/draft/tokenreq.html
>> http://www.sqlite.org/draft/syntax.ht
re passing strings into windows APIs.
Thus the older SQLite bugs and the bugs in your code cancelled each
other out. When the bug in SQLite was fixed, the cancellation went
away and the bug was expressed.
D. Richard Hipp
[EMAIL PROTECTED]
___
sq
abase causes the freed disk space
to go onto a freelist to be used on the next INSERT. The space is not
returned to the OS and the file size is not reduced. To reduce the
database file size run VACUUM or enable auto_vacuum.
D. Richard Hipp
[EMAIL PROTECTED]
__
would slow down performance due
to the added cost of checking type constraints at each step.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
be trading perhaps 250KB of code
space for a heap space savings of less than 1KB.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ay, but I'm still
> left with the last three.
>
> Am I just out of luck?
>
Run this command:
sqlite3 old.db .dump | sqlite3 new.db
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
and again in the SELECT clause. This looks like a bug.
>
OK. Even though this kind of thing is probably an abuse of SQL, I'm
working on ticket #3343. Just for the record, I'd like everybody to
know that the following is really, really hard to do correctly and is
going to r
the code
and make it more maintainable and reliable moving forward. Nearly 5000
non-comment lines of core code (about 11.3%) have changed from the
previous release. Nevertheless, there should be no application-visible
changes, other than bug fixes.
D. Richard Hipp
[EMAIL PROTECTED
column in SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sep 4, 2008, at 8:56 PM, Darren Duncan wrote:
> D. Richard Hipp wrote:
>> One occasionally sees SQLite schemas of the following form:
>>
>> CREATE TABLE meta(id LONGVARCHAR UNIQUE PRIMARY KEY, );
>>
>> In other words, one sometimes finds a PRIMARY K
that I've finally been straightened out on
that point. Sorry for the false alarm
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
But there is no place to specify the return datatype.
Indeed, many aggregate functions (ex: max()) return different
datatypes depending on the datatypes of their inputs. In your
example, the sum() function might return either real or integer - it
returns integer if all arguments are in
itself won't,
> so id will _still_ be a valid integer primary key, even if the
> implementation detail of rowid changes.
I promise that INTEGER PRIMARY KEY will always be an alias for the
rowid in SQLite. This will not change.
>
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> Is there any
> reliable method to determine the minimum page-cache allocation size
> needed for a given page_size?
>
sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, ...)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e some thread-local storage. This is pthreads thing. There is
nothing SQLite can do about it. If you are concerned, compile with -
DSQLITE_THREADSAFE=0. This is not a bug in SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
s
the disk cache behavior in the VFS
layer. SQLite passes sufficient flag information into the "open"
method of the VFS to let it know when the file can be a memory cache
versus a real file.
D. Richard Hipp
[EMAIL PROTECTED]
___
s
to be serialized.
If you create a TEMP table to hold the 3000 selected records then do:
INSERT INTO temptab SELECT * FROM maintab WHERE ...;
You can then do your computations on the temporary table without even
interfering with writers on the main table.
D. Richard Hipp
[EMAIL PROTECTED]
ging them without a very good reason.)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t
suite. The language bindings for TCL are the most natural and easy-to-
use of any language I have seen.
The statistics in the quote above are dated. Recently we have been
getting about 11,000 unique IPs per day at the website and the amount
of
I can do to get that time down substantially?
Try this and see if it helps:
CREATE INDEX idx1 ON settings(rate, year, month);
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
is is just
> the way it is? Yes, I know I have
> a 3 column index and only using 2 for this query.
I do not see how it is possible for what you say to be true - unless
you have omitted important details of your query, such as a WHERE
clause.
What is the argument to sum(), btw? You shou
On Sep 21, 2008, at 8:51 AM, Russ Leighton wrote:
> I am interested in ... a way
> to constraint/control index selection on queries.
>
What other SQL database engines have this capability and what syntax
do they use?
D. Richard Hipp
[EMAIL
SQLite version 3.6.3 is now available for download from the website
http://www.sqlite.org/download.html
Version 3.6.3 fixes several bugs in version 3.6.2, most notably the
problem with DISTINCT.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite
error. In other words,
the new syntax is a requirement, not a hint.
Comments? Objections?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3_stmt is
constructed. It is too late to offer hints after the fact.
> I
> forget if sqlite_stmt keeps a copy of the sql so I may well be
> suggesting the impossible here. The api would reinforce the
> non-standard nature of the action while keeping the sql dialect
seems to have
> fixed my problem. Is there any reason this shouldn't be on
> by default?
It only works on a Mac. The build fails on other posix platforms.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users
ere in the code.
The COPY method in the TCL interface has never been documented, I
don't believe. And TCL is a case-sensitive language. So I don't
think this is going to be a big issue.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
atabase recovery - that
is the task of the rollback journal. So the statement journal can be
deleted at will without damaging the database. And, in fact, the
statement journal is opened with delete-on-close.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlit
th remarkably little fuss.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ocks to inside of SQLite so that your
application code does not have to mess with them. It does not
magically provide you any additional concurrency.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> Any help would be appreciated
>
Have you read this document: http://www.sqlite.org/atomiccommit.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Oct 1, 2008, at 6:25 PM, Mark Spiegel wrote:
> -DSQLITE_OMIT_CONFLICT_CLAUSE=1
This disables REPLACE.
Also, just so you will know, sqlite3_prepare16() works by converting
the SQL into UTF8 then calling sqlite3_prepare().
D. Richard Hipp
[EMAIL PROTEC
ticket
> http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew
>
The problem has already been fixed. See
http://www.sqlite.org/docsrc/vinfo/31aaf2c3f5275e43bf301ace914056203f3fccd3
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
http://www.sqlite.org/draft/syntaxdiagrams.html
http://www.sqlite.org/draft/syntax.html
Comments, criticism, and error reports are welcomed - particularly if
they are received in time to be addressed prior to the release of
3.6.4, currently scheduled for Oct 15.
D. Richard Hipp
[EMAIL
On Oct 3, 2008, at 10:48 AM, D. Richard Hipp wrote:
> http://www.sqlite.org/draft/syntaxdiagrams.html
> http://www.sqlite.org/draft/syntax.html
Bad link. Should have been: http://www.sqlite.org/draft/lang.html
>
>
> Comments, criticism, and error reports are welcomed - part
installed ImageMagick and
Ghostscript on a Mac and the script will run there, but the resulting
images look really, really bad.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ge. You can substitute "display" if
you prefer. Or you can omit it all together if you don't want to look
at the GIF immediately after it is produced.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sql
ify these two files in order to compile using Visual C++
> 2003.
This problem was fixed by check-in [5732].
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s
depending on their magnitude. If you change the value of an integer
it might change the amount of storage it requires, which then requires
rewriting everything that comes afterwards.
It is recommended that large BLOBs be stored in a separate table with
only an INTEGER PRIMARY KEY.
dn't look at the content before approving it
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-release announcements on sqlite-
users and use only sqlite-dev for such purposes. If you think this
revised policy is out of line with the usual practice on other
projects, please let me know.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users
d at compile-time. But OP_IsNull takes no
measurable amount of time, so why clutter up the code base to do so?
You will get much better output from EXPLAIN if you first run the
shell macro ".explain"
D. Richard Hipp
[EMAIL PROTECTED]
__
such as the above that attempt to tell
SQLite to use a 32-bit integer where it is expecting to have a 64-bit
integer. But such configurations are untested. You will likely
encounter bugs. I recommend that you only use SQLite on platforms
that have a working 64-bit integer capability.
me again why you want BNF instead of syntax
diagrams? Most people find the syntax diagrams to be much easier to
understand.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/ma
se connection that has been closed. The error checking to
> detect these things and return SQLITE_MISUSE is probabilistic - it is
> not guaranteed to succeed. But when it does, it is helpful in finding
> application errors.
>
> SQLITE_MISUSE returns do not set the error message. So
&g
the error message. So
sqlite3_errmsg() will continue to return the previous error, whatever
that was.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
le the sqlite3 command
> shell is
> running without problems.
The command-line shell uses sqlite3_open() too. So if it works there,
I do not understand why it is not working in your program. Have you
run your program in a debugger to see exactly where it is crashing?
e all unbound and thus
understood as NULL. I prepared the statement once and reused it to do
1000 inserts. The average time was 26.058 milliseconds. Then I did:
UPDATE t1 SET a=$av WHERE rowid=$rid
I prepared the statement separately 1000 times. The average time was
55.458 millise
On Oct 15, 2008, at 8:11 AM, D. Richard Hipp wrote:
> SQLite version 3.6.4 is now available for download on the SQLite
> website:
>
> http://www..sqlite.org/download.html
>
> SQLite version 3.6.4 is considered a stable release. Upgrading from
> version 3.6.3 is opt
3.6.4 visit
http://www.sqlite.org/3_6_4.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
E_MUTEX_NOOP
yourself. Instead set SQLITE_THREADSAFE=0 and let SQLITE_MUTEX_NOOP
be set automatically.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
an avoid the locale problem by using sqlite3_snprintf() instead
of sprintf(). sqlite3_snprintf() always uses "." for the radix point
regardless of what locale says - for exactly the reason that Igor
cites. Also with sqlite3_snprintf() you can use %Q instead of '%s' to
N...COMMIT with the INSERT statements in between, you can do
thousands and thousands of fast INSERTs for each relatively slow COMMIT.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_DATE-Behavior-tp20075044p20075044.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
[EMAIL P
nd the discrepancy here.
> Are
> recursive triggers required to implement some FK constraints that the
> above solution cannot impose?
>
Does http://www.sqlite.org/cvstrac/fileview?f=sqlite/tool/
genfkey.README answer your questions
by the C
> standard. That's the reason for these warnings. Its also a reason
> not to
> turn off the warnings.
>
Dan is using the void* to hold a 0 or a 1. So his code will work
correctly as long as sizeof(void*)>=1. It would be a strange machine
indeed that failed to
e with only 100 records so that I
can poke around a bit?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e size you might consider
> running a VACUUM just *before* deleting the records, to avoid peaks
> persisting ... and even then (say) every *other* week.
> Just a thought !
>
VACUUM also defragments a database file which sometimes helps
subsequent operations to run faster.
D. Richa
.1MB which is not far from the actual database file size of
2.6MB.
I think the growth in database size is probably occurring because you
are inserting more values into the database than you think you are.
The first few pages of the output of sqlite3_analyzer are attached.
D. Richard Hipp
[EMA
nd the problem.
I have no explanation for the observed behavior.
Have you tried running "PRAGMA integrity_check" against the database
as a normal user?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
R
that you looked up? What error message does sqlite3_errmsg(db) return?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
enhancement of SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
circumstances, even if they are using completely
separate database connections.
My advice is that you not use threads. Threads are evil. But,
recognizing that you are unlikely to heed this warning, at the very
least compile with SQLITE_THREADSAFE=1 if you really think you must
use threa
;
>
> Ocado Limited
>
> Titan Court
> 3 Bishops Square
> Hatfield Business Park
> Hatfield
> Herts
> AL10 9NE
> Tel: +44 (0) 1707 228000
> Fax: +44 (0) 1707 227999
> www.ocado.com
> ___
> sqlite-users mailing list
> sql
If there is anyone from MIO.com is subscripted to this list (and using
a private, non-mio.com domain) I would appreciate it if you would
contact me by direct email. Tnx.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite
On Nov 6, 2008, at 6:16 PM, Griggs, Donald wrote:
> Another interesting thing:
>
http://www.sqlite.org/cvstrac/chngview?cn=5866
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/c
nd then prepared with a
> different query programmatically. Is there any sort of unique
> identifier in those prepared structures?
I'm not sure I understand the question. Is
http://www.sqlite.org/c3ref/sql.html
what you are asking for?
3.6.5 out by about this time
tomorrow. We plan to release regardless of whether or not we have
test results. But if you find a problem, we will delay the release in
order to fix it.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
email to me.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
401 - 500 of 1805 matches
Mail list logo