sqlite3.c
D:\Ulti\MyApps\USQLite3\SQLite\sqlite3.c(5494) : warning C4244: '=' :
conversion from 'double' to 'int', possible loss of data
D:\Ulti\MyApps\USQLite3\SQLite\sqlite3.c(5495) : warning C4244: '=' :
conversion from 'double' to 'int', possible loss of data
Sure, pre-caching is a hack - but a very effective one.
It has also been suggested to use MAP_POPULATE for mmap() and
posix_fadvise() in Linux.
http://www.mail-archive.com/monotone-devel@nongnu.org/msg03222.html
The general reaction against pre-caching (especially for tiny 100M
databases) is
Excellent. All tests passed. Thanks for the quick fix.
-Clark
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, April 2, 2007 3:20:45 PM
Subject: Re: [sqlite] Version 3.3.14
Clark Christensen <[EMAIL PROTECTED]> wrote:
> >
Clark Christensen <[EMAIL PROTECTED]> wrote:
> > Did you use "configure; make" to get this error?
>
> Yes. I used the configure script, and make, as you describe.
>
Apply the patch at
http://www.sqlite.org/cvstrac/chngview?cn=3805
The library itself builds correctly, just not the test
sorry! was only my proxy cache..
On 02/04/07, Cesar Rodas <[EMAIL PROTECTED]> wrote:
here http://www.sqlite.org/download.html i only could see the 3.13.. what
is wrong with that?
On 02/04/07, Clark Christensen <[EMAIL PROTECTED]> wrote:
>
> > Did you use "configure; make" to get this error?
>
here http://www.sqlite.org/download.html i only could see the 3.13.. what is
wrong with that?
On 02/04/07, Clark Christensen <[EMAIL PROTECTED]> wrote:
> Did you use "configure; make" to get this error?
Yes. I used the configure script, and make, as you describe.
-Clark
- Original
> Did you use "configure; make" to get this error?
Yes. I used the configure script, and make, as you describe.
-Clark
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, April 2, 2007 1:47:26 PM
Subject: Re: [sqlite] Version
Clark Christensen <[EMAIL PROTECTED]> wrote:
> I'm seeing an error in make test for 3.3.14:
>
> /tmp/ccDdRRCh.o: In function `Sqlitetest1_Init':
> /home/cchriste/sqlite-3.3.14/src/test1.c:4321: undefined reference to
> `sqlite3_xferopt_count'
> collect2: ld returned 1 exit status
> make: ***
I'm seeing an error in make test for 3.3.14:
/tmp/ccDdRRCh.o: In function `Sqlitetest1_Init':
/home/cchriste/sqlite-3.3.14/src/test1.c:4321: undefined reference to
`sqlite3_xferopt_count'
collect2: ld returned 1 exit status
make: *** [testfixture] Error 1
$
Red Hat Linux 7.2 (2.4.7.10);
gcc
Ticket #2282 against SQLite
http://www.sqlite.org/cvstrac/tktview?tn=2282
complains that in an INSTEAD OF trigger on a view where
the trigger has a WHEN clause, if the WHEN clause is false
and the trigger does not fire, then the UPDATE statement
that provoked the trigger should fail. I am
[EMAIL PROTECTED] wrote:
SQLite version 3.3.14 is now available on the SQLite website
http://www.sqlite.org/
Version 3.3.14 focuses on performance improvements. There
have been several changes to the back-end layers (the pager
and the b-tree subsystems) that reduce the amount of disk
Thanks; that sounds like a very worthwile update.
Will let you know what the performance gain is once
I have my wrappers sorted.
RBS
> SQLite version 3.3.14 is now available on the SQLite website
>
>http://www.sqlite.org/
>
> Version 3.3.14 focuses on performance improvements. There
> have
"Noah Hart" <[EMAIL PROTECTED]> wrote:
> Complies fine.
>
> Linking shell.c I get the following errors
>
> Error 326 error LNK2001: unresolved external symbol
> _sqlite3_io_trace shell.obj
> Error 327 fatal error LNK1120: 1 unresolved externals
>
Something that would be very useful in the shell code in a future
release would be the ability to handle data containing embedded binary
data. I use the shell to populate tables and many of the files I need to
load have the odd \n or \000 embedded in what whould be ascii text.
Sybase handles this
An interesting approach would be to use some sort of async I/O
facility to implement read-ahead.
Short of that, I have found that in some cases, on some operating
systems, implementing explicit read-ahead buffering for fts2 segment
merges improves performance when the disk caches are cold.
Complies fine.
Linking shell.c I get the following errors
Error 326 error LNK2001: unresolved external symbol
_sqlite3_io_trace shell.obj
Error 327 fatal error LNK1120: 1 unresolved externals
F:\SQLite3\Projects\SQLite3C\bin\Debug\Sqlite3.exe
Any suggestions?
SQLite version 3.3.14 is now available on the SQLite website
http://www.sqlite.org/
Version 3.3.14 focuses on performance improvements. There
have been several changes to the back-end layers (the pager
and the b-tree subsystems) that reduce the amount of disk
I/O. A new optimization has
Hello i have an big problem.
I use the ADO.NET Provider Version 1.40.0 with MS Visual-Studio 2005 ans
VisualBasic.
When i first open the Database and create a Transaction and read the
Database is all OK.
Codesniped:
Using sqLiteConnection As System.Data.SQLite.SQLiteConnection = New
18 matches
Mail list logo