Re: [sqlite] Uncached performance

2015-01-08 Thread Teg
Hello Donald, DG 1) Might there be further performance gains by placing the blobs in a DG separate table? DG E.g. DG CREATE TABLE myBlobs ( DG idINTEGER PRIMARY KEY REFERENCES global (id), DG value BLOB DG ); DG Then (if you haven't rebuilt a new db, and

[sqlite] Without ROWID and Autoincrement question

2014-12-26 Thread Teg
Hello General, I was going to say I thought the docs were ambiguous but, on my 3rd reading I see they aren't. Still, I think this statement could be re-written to reduce confusion (at least mine). https://www.sqlite.org/autoinc.html Because AUTOINCREMENT keyword changes the behavior of

Re: [sqlite] Performing a SELECT on an enormous database...

2014-10-25 Thread Teg
___ RA sqlite-users mailing list RA sqlite-users@sqlite.org RA http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite

Re: [sqlite] Please fix the EBCDIC support

2014-10-16 Thread Teg
-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] UTF support

2014-10-07 Thread Teg
@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users JD ___ JD sqlite-users mailing list JD sqlite-users@sqlite.org JD http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t

Re: [sqlite] Reinstalling My Build Environment

2014-09-10 Thread Teg
:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI INfo

2014-09-09 Thread Teg
___ MN sqlite-users mailing list MN sqlite-users@sqlite.org MN http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list

Re: [sqlite] What if OpenDocument were built atop SQLite?

2014-09-08 Thread Teg
in the game but, I would have preferred this to zips for sure. Teg mailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mixing journal modes from different threads

2014-08-21 Thread Teg
-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users GI ___ GI sqlite-users mailing list GI sqlite-users@sqlite.org GI http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] Questions from a novice - basic browsing of records in a listview.

2014-07-10 Thread Teg
is remember what you asked for. SS Simon. SS ___ SS sqlite-users mailing list SS sqlite-users@sqlite.org SS http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] Reading compressed database files

2014-05-28 Thread Teg
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Load time performance

2014-05-28 Thread Teg
@sqlite.org HR http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Retrieve a int or a sqlite_int64

2014-05-13 Thread Teg
___ CS sqlite-users mailing list CS sqlite-users@sqlite.org CS http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

2014-05-03 Thread Teg
/listinfo/sqlite-users HL ___ HL sqlite-users mailing list HL sqlite-users@sqlite.org HL http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] Long table fails to create with exec sql on windows 8.1

2014-04-24 Thread Teg
Hello Mark, System just stops responding. It's not clear if you're talking about the program or your PC. If the PC is hanging, it's broken and this isn't a software problem (well not a Sqlite problem). Anytime a PC running windows hangs or crashes, you know it's a driver or hardware problem

Re: [sqlite] Noticed crash on windows

2014-03-25 Thread Teg
Quite unlikely is the prospect for somebody here to say Yes, we routinely see crashes on Windows in the sqlite3_mutex_enter code. You are going to have to debug this. This. I run the hell out of Sqlite under 32 and 64 bit windows with no issues. 20-40 GB databases are common with multi-thread

Re: [sqlite] Windows service with SQLITE

2014-02-17 Thread Teg
with opening and accessing the DB. C Sunday, February 16, 2014, 11:45:27 PM, you wrote: tp Hi Teg, tp I tried putting delay of 3 seconds and 30 seconds but nothing happens. tp Still not able to access database and store anything. tp When i create a file to store data it stores. Strange.. tp Need

Re: [sqlite] Windows service with SQLITE

2014-02-15 Thread Teg
sqlite-users mailing list tp sqlite-users@sqlite.org tp http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] How to Troubleshoot Disk I/O Error

2014-01-30 Thread Teg
___ AOB7L sqlite-users mailing list AOB7L sqlite-users@sqlite.org AOB7L http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

2014-01-30 Thread Teg
mailing list JM sqlite-users@sqlite.org JM http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Application statically linked with sqlite3.6 creates sqlite2.1 files

2014-01-23 Thread Teg
@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users JB ___ JB sqlite-users mailing list JB sqlite-users@sqlite.org JB http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] store image file as blob

2013-10-30 Thread Teg
___ db sqlite-users mailing list db sqlite-users@sqlite.org db http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLite and Virtual PC

2013-09-08 Thread Teg
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_bind_text truncates strings with .

2013-07-16 Thread Teg
/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to save live data into sqlite database using c language?

2013-04-28 Thread Teg
, .. }; CREATE TABLE host ( Src_MAC char(18), Src_IP char(16), Cap_Bytes integer, Protocol integer, ); With a single protocol tag per insert. Then you tag each packet insert with the protocol field. -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] Writing in a blob

2013-04-23 Thread Teg
Imagine what could happen if, for example, git where to start using this library. Instead of the .git directory containing lots and lots of separate files, your repository would be a single .git file which was really an SQLite database accessed through the sqlite3fs wrapper. I use Sqlite for a

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-04 Thread Teg
RH the new code a try. -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

2013-02-11 Thread Teg
___ jic sqlite-users mailing list jic sqlite-users@sqlite.org jic http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] bug report: out of memory error for most operations on a large database

2013-01-26 Thread Teg
Regards, CL Clemens CL ___ CL sqlite-users mailing list CL sqlite-users@sqlite.org CL http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] Running on windows 98

2013-01-24 Thread Teg
___ GG sqlite-users mailing list GG sqlite-users@sqlite.org GG http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] performance regression when using insert or replace

2013-01-23 Thread Teg
://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users DK ___ DK sqlite-users mailing list DK sqlite-users@sqlite.org DK http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance

2012-11-30 Thread Teg
___ DdR sqlite-users mailing list DdR sqlite-users@sqlite.org DdR http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] VC++ and SQLite

2012-11-13 Thread Teg
AO sqlite-users@sqlite.org AO http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] First time poster: need advise

2012-09-21 Thread Teg
@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users IK ___ IK sqlite-users mailing list IK sqlite-users@sqlite.org IK http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t

Re: [sqlite] Store error messages in thread local memory

2012-09-20 Thread Teg
SK ___ SK sqlite-users mailing list SK sqlite-users@sqlite.org SK http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] SQLite Compile Bug for Windows 8

2012-09-14 Thread Teg
in C, where such a cast is not required. Yeah, I'm building under Win8 with no issue. -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] SQLITE in a Win7 Service Application

2012-08-15 Thread Teg
anyone know about this and / or has a solution? mr Kind regards mr Markus mr ___ mr sqlite-users mailing list mr sqlite-users@sqlite.org mr http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] I consider this a bug. Anyone else?

2012-06-26 Thread Teg
-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with including sqlite3.c into c++ project

2012-06-25 Thread Teg
AD Do not use precompiled headers on sqlite3.c This. My Sqlite is in it's own library project so, it can have different precompiled header settings than my other projects. About 80% of my projects use procompiled headers, the other 20 are typically made of code like Sqlite which don't have

Re: [sqlite] intial database creation

2012-05-10 Thread Teg
Hello Brett, All of my DB's are generated in code. When I version control the code, I'm also version controlling the schema. If my users end up with bad DB's (it's windows, it happens fairly frequently). They just delete them and they're then re-created as needed by the program. I have specific

Re: [sqlite] Visual Studio 2008 Express and sqlite3.c

2012-03-30 Thread Teg
://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users MB ___ MB sqlite-users mailing list MB sqlite-users@sqlite.org MB http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] Could/should Windows build of SQLite use #define WIN32_LEAN_AND_MEAN?

2012-03-23 Thread Teg
JR sqlite-users@sqlite.org JR http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] VIsual Studio 2005. slow and high CPU in debug

2012-03-19 Thread Teg
in SQLite to avoid this problem? JP Thank you very much in advance. JP ___ JP sqlite-users mailing list JP sqlite-users@sqlite.org JP http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t

Re: [sqlite] Cyrillic support

2012-03-10 Thread Teg
___ M sqlite-users mailing list M sqlite-users@sqlite.org M http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing

Re: [sqlite] Cyrillic support

2012-03-10 Thread Teg
JCD There are 16-bit SQLite APIs for that, no conversion needed JCD actually. But of course it all depends of the wrapper you use, if any. -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite

Re: [sqlite] Bug hunting in SQLite

2012-02-26 Thread Teg
://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users PN ___ PN sqlite-users mailing list PN sqlite-users@sqlite.org PN http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t

Re: [sqlite] insert image into db - windows batch

2012-01-18 Thread Teg
mailing list PL sqlite-users@sqlite.org PL http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] 3.7.9 amalgamation file in VS2005

2011-12-28 Thread Teg
, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.7.9 amalgamation file in VS2005

2011-12-27 Thread Teg
-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL file size

2011-11-30 Thread Teg
sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] WAL file size

2011-11-30 Thread Teg
, November 30, 2011, 1:10:50 PM, you wrote: RH On Wed, Nov 30, 2011 at 1:04 PM, Teg t...@djii.com wrote: Hello Richard, When does the WAL get trimmed down? If my transaction completes, does the WAL file get deleted? I've seen the WAL grow to 4 times my actual DB size so, I don't really

Re: [sqlite] WAL file size

2011-11-30 Thread Teg
Hello Richard, That's what I was hoping to hear. Thanks, Wednesday, November 30, 2011, 2:01:46 PM, you wrote: RH On Wed, Nov 30, 2011 at 1:39 PM, Teg t...@djii.com wrote: Hello Richard, Appreciate the reply but, it doesn't address my question (unless I'm missing something). I get

Re: [sqlite] WAL file size

2011-11-30 Thread Teg
-users mailing list SS sqlite-users@sqlite.org SS http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] WAL file size

2011-11-30 Thread Teg
Hello Richard, Thanks again. Wednesday, November 30, 2011, 5:37:32 PM, you wrote: RH On Wed, Nov 30, 2011 at 5:31 PM, Teg t...@djii.com wrote: Since we're on this topic If I open a 30 GB DB file, then attach a new empty DB and then select/insert all the data from the full DB

Re: [sqlite] Problems with SQLite when used with MPI

2011-11-22 Thread Teg
with the same database and SQL querry. I GV dont understand why I am getting this error. GV Gaurav GV ___ GV sqlite-users mailing list GV sqlite-users@sqlite.org GV http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] WAL and local UNC filenames

2011-11-08 Thread Teg
___ PI sqlite-users mailing list PI sqlite-users@sqlite.org PI http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] does sqlite3_reset have a performance impact onqueries?

2011-11-02 Thread Teg
Operating Unit BMI Northrop Grumman Information Systems BMI ___ BMI sqlite-users mailing list BMI sqlite-users@sqlite.org BMI http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t

Re: [sqlite] core dump happened in sqlite3_step for 30 statements in BEGIN TRANSACTION executing every 10 Millisecond

2011-11-01 Thread Teg
0x3278b5cc in ?? () from /lib/libpthread.so.0 CH #14 0x32f39b88 in clone () from /lib/libc.so.6 CH ___ CH sqlite-users mailing list CH sqlite-users@sqlite.org CH http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] Using SQLite on Windows 64bit

2011-10-29 Thread Teg
-users@sqlite.org AO http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-10-18 Thread Teg
___ FM sqlite-users mailing list FM sqlite-users@sqlite.org FM http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Internal v. External BLOBs

2011-09-21 Thread Teg
mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Strategies for protecting sql queries

2011-08-29 Thread Teg
PI If someone was ambitious enough they could attach a debugger to your PI application, extract key used to decrypt the database and obtain all PI the sensitive information you have. So if you really want to protect PI your database against those who is able to attach a debugger you PI shouldn't

Re: [sqlite] SQLite + unicode

2011-08-11 Thread Teg
unicode. N Thanks! -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Read only scaling optimization

2011-08-09 Thread Teg
___ DK sqlite-users mailing list DK sqlite-users@sqlite.org DK http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite

Re: [sqlite] Deep copy of 2 sqlite3*?

2011-08-03 Thread Teg
-- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Field drop work around

2011-08-02 Thread Teg
___ JH sqlite-users mailing list JH sqlite-users@sqlite.org JH http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLite3.dll for Win 64

2011-07-25 Thread Teg
Hello Everton, EV Don't have any easy way to make this dll? There's a lot of 64bits systems EV out there that will need this dll. I just compile it into my program and don't bother with DLL's. I find that DLL's in general make my software less reliable so, I avoid them. Static linking all the

Re: [sqlite] Selected string differs to Inserted one

2011-07-24 Thread Teg
/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA bug in 3.7.7 (but fine in 3.7.6.3)

2011-06-26 Thread Teg
mailing list GS sqlite-users@sqlite.org GS http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Do I need to migrate to MySQL?

2011-06-03 Thread Teg
___ DD sqlite-users mailing list DD sqlite-users@sqlite.org DD http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users

Re: [sqlite] Compile error's on Visual Studio 2010

2011-05-08 Thread Teg
___ JB sqlite-users mailing list JB sqlite-users@sqlite.org JB http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Compile error's on Visual Studio 2010

2011-05-08 Thread Teg
.c files JAK with the C++ compiler, even though-- as this very example points JAK out-- the languages are different enough that this behavior seems JAK questionable. -- Best regards, Tegmailto:t...@djii.com ___ sqlite

Re: [sqlite] how to reuse a prepared statement

2011-04-23 Thread Teg
I got bit by this the other day. I typically just used reset but, if you have a case where you're looping through an insert and you don't always set all values (say a string is empty sometimes so, you forgo the bind), the previous value set will get inserted where you expected blanks to go.

Re: [sqlite] SQLite3 memory leaks in my c++ dll application

2011-04-20 Thread Teg
sqlite-users@sqlite.org KN http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Fwd: database collision detection

2011-03-11 Thread Teg
-- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: disk I/O error on big databases vacuuming

2011-03-08 Thread Teg
. Never have below 100 gigs free when I've tested this. -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] COUNT() extremely slow first time!

2011-02-23 Thread Teg
a dramatic effect on how long it takes to warm up GB the table. On Windows 7, with page_size=1024, a SELECT COUNT(last_column) GB takes 40.2 seconds. page_size=4096 takes 15.5 seconds. page_size=8192 takes GB 8.5 seconds. This was done with a reboot between each test. -- Best regards, Teg

Re: [sqlite] UPDATE/INSERTing 1-2k rows slower than expected

2011-02-11 Thread Teg
Hello Thomas, I download off the net at between 400Mbps to 1 Gbps and have to pack the data away into a Sqlite DB. I use an intermediate buffer on disk and a background thread to write the data to the DB. Obviously, I couldn't keep up if the data was continuous but, the lulls in between the peak

Re: [sqlite] Disk I/O Error

2011-02-08 Thread Teg
://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Disk I/O Error

2011-02-08 Thread Teg
-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users NB ___ NB sqlite-users mailing list NB sqlite-users@sqlite.org NB http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] Sqlite3.h file for X64 Windows

2011-02-07 Thread Teg
wouldn't work for IT both Win32 and Win64. Have you tried it, and encountered a particular problem with it? -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] LENGTH on a BLOB field stops at NUL byte

2011-02-06 Thread Teg
count its YG characters... And the image I get back from SQLite looks error-free so YG it probably didn't make a single mistake handling it as text data. -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list

Re: [sqlite] Cause of disk I/O errors

2011-01-31 Thread Teg
, it works every time (naturally). GS So it seems it must be something about their particular machine GS environment, but what? I'm sure that nobody is running out of disk space GS these days. Any ideas on where to look or what to suggest to them that GS they can do? -- Best regards, Teg

Re: [sqlite] REGEXP parameter order - embarassed newbie

2011-01-24 Thread Teg
sqlite-users@sqlite.org Jac http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Embarassed Newbie

2011-01-08 Thread Teg
to be fixed. Can you double-check this for me please. BMI -- BMI D. Richard Hipp BMI d...@sqlite.org BMI ___ BMI sqlite-users mailing list BMI sqlite-users@sqlite.org BMI http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] append sql file

2010-12-06 Thread Teg
___ CM sqlite-users mailing list CM sqlite-users@sqlite.org CM http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list

Re: [sqlite] Just compiled SQLite in Visual Studio

2010-12-01 Thread Teg
. Igor was only using a figure of speech, kind of. BK Everything I said in this thread so far, I meant quite literally. BK Which expression of mine do you take as a figure of speech? -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] Read database from multiple processes

2010-11-18 Thread Teg
/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 5 GB DB with a 51 GB wal file.

2010-11-11 Thread Teg
regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 5 GB DB with a 51 GB wal file.

2010-11-11 Thread Teg
Hello Teg, Thursday, November 11, 2010, 12:08:23 PM, you wrote: T I have a 5GB DB file, 5 simple tables. Several million entries. When I T tried to delete perhaps 10% of the entries. The WAL file blew up to T 51 GB, 10 times bigger than the DB file itself. I understand the T problem I think

Re: [sqlite] Sqlite with VS 2008

2010-10-29 Thread Teg
/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Breakpoints uncorrelated on MSVC amalgamation build

2010-09-23 Thread Teg
___ BH sqlite-users mailing list BH sqlite-users@sqlite.org BH http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Don't use the amalgamation? That's one reason I don't use it. -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] SELECT is Slow when run in C++ code compared to SQLite Administrator

2010-09-20 Thread Teg
-users mailing list a sqlite-users@sqlite.org a http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] c compiler during install

2010-06-17 Thread Teg
Hello Glen, I'm not a Linux guy (though I've installed it and run a DB on it before) but, GS There was an error parsing the RHN proxy settings. GS RHN support will be disabled. Suggests your install can't get out on to the 'net to find the files you're looking for. If YUM can't get to the net,

Re: [sqlite] BLOB Support

2010-06-16 Thread Teg
Hello Sam, I store multiple gigs of image files, some as large as 2-3 megs in Sqlite DB's. For pretty much the same reason, the convenience of having them in one package. For my requirements, extracting the images from the DB, and displaying them isn't a bottleneck. It's fast enough. Search

Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000

2010-06-05 Thread Teg
___ nf sqlite-users mailing list nf sqlite-users@sqlite.org nf http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing

Re: [sqlite] SQLite on Windows 2003

2010-04-06 Thread Teg
/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Non-Debug version of SQLite3.dll

2010-04-02 Thread Teg
___ RB sqlite-users mailing list RB sqlite-users@sqlite.org RB http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users

Re: [sqlite] Non-Debug version of SQLite3.dll

2010-04-02 Thread Teg
:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite C API screwing port access?

2010-03-23 Thread Teg
Regards, MS Martin Sigwald MS ___ MS sqlite-users mailing list MS sqlite-users@sqlite.org MS http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

  1   2   3   >