[sqlite] SQLite database on a certain high-performance "SSD"

I've currently got a loaner high-performance flash-based "SSD" (let's just say it doesn't connect to any disk controllers) that I'm testing for performance. I've run my application against it, and I believe that I should see numbers MUCH higher than I do. When I run my test app on a normal SATA

Re: [sqlite] SQLite database on a certain high-performance "SSD"

> hard disk, it might be fooling the OS into treating it a one. > > Simon. It's connected directly to the PCI Express bus. It's using it's own driver, so I assume it knows it's not a hard disk :) Mark ___ sqlite-users

Re: [sqlite] SQLite database on a certain high-performance "SSD"

Lothar Scholz wrote: > Hello Mark, > > Tuesday, September 22, 2009, 3:53:48 AM, you wrote: > > M> I've currently got a loaner high-performance flash-based "SSD" (let's > M> just say it doesn't connect to any disk controllers) that I'm

Re: [sqlite] SQLite database on a certain high-performance "SSD"

It's very possible, but I don't know how to tell. Is there an easy way to know if the sync() calls are taking inordinately long? Mark Thomas Briggs wrote: >Is the sync necessary to commit a transaction slow? Performance of > that sync depends on the OS, file system, hardwa

Re: [sqlite] SQLite database on a certain high-performance "SSD"

low on this storage device. Thanks for the suggestion. Mark Pavel Ivanov wrote: > If you execute > > pragma synchronous = off; > > you'll be able to compare performance with syncs and without them. So > if you make this comparison on standard spinning disk and on SS

Re: [sqlite] SQLite database on a certain high-performance "SSD"

o, I can conclusively say that >> fsync() is very slow >>> on this storage device. >> Yes, the only action of synchronous = off is to turn off >> calls to >> fsync() which is called at least twice during each commit. >> >> Pavel >> >> On

[sqlite] FTS3 performance oddity

project so it's a great fit), but having the query suddenly take "forever" because someone included a state in the search just won't work for me. Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

rly the exact same thing, except my BLOBs are about 8k, and they compressed to about 2k. It turned out in my testing to be significantly faster to skip the compression step (disk space is cheap, right?) and write the data directly to the database. As to your other questions, I have no answers, and indeed, would be interested in them if you came up with some! Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Aggregating BitFlags

t; > No clue, sorry. > > Igor Tandetnik If you're using System.Data.SQLite from http://sqlite.phxsoftware.com/ there's information in the help file on how to create a custom function in any .NET language. It involves creating a class that inherits from SQLiteFunction. M

[sqlite] output problem

doesn't work at all, nothing is created. I do need it it to go to at least the C drive, and preferably a folder on C mtia, Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] output problem

t the .read could take maybe 10 seconds or more. .read UnPop.sql .output C:\done.txt .dump dbinfo .quit mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] output problem

thanks, yeah sorry, what I meant to ask was, because the .read command is going away to read another file, away from this one, if you know what I mean, does it actually know to wait for that to finish, or once it's started executing the .read, does it immediately move on to the dump?

[sqlite] INSERT question

Hi there, when using INSERT, if the record is already present, will this cause any problems, does it overwrite or ignore? mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] output problem

er part of the programme that the INSERT / DELETE or UPDATE has been completed mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] fill in blank fileds

Hi Simon, ran the first example, came back with lots of lines, second test with the just the 10 returned 9 lines as 0: the second line as 2:3832, don't understand the purpose/meaning of this Hi Igor, not checking for, want to fill in/replace blank or null fields with at least one character

[sqlite] Segmentation fault on OpenBSD

zSql = 0xb14b6dc7188 "INSERT INTO\nfunc_merge_deltas(\nmerge\n )\nVALUES\n(\n?\n)\n;", pFree = 0x0, pFrame = 0xb148a5c8008, pDelFrame = 0x0, nFrame = 5, expmask = 0, pProgram = 0xb146b8be548, pAuxData = 0x0} -- Mark Lawrence _

Re: [sqlite] Segmentation fault on OpenBSD

On Mon Oct 31, 2016 at 05:42:32PM -0400, Richard Hipp wrote: > On 10/31/16, mark wrote: > > On Mon Oct 31, 2016 at 04:04:00PM -0400, Richard Hipp wrote: > >> Is this reproducible? > > > > Yes... in that I can reliably get it to segfault. Duplicating the build >

Re: [sqlite] Segmentation fault on OpenBSD

On Tue Nov 01, 2016 at 02:21:02AM +0100, mark wrote: > assertion "0" failed: file "sqlite3.c", line 70020, function > "valueFromExpr" I read the source code a little further and found that the NEVER at line 70020 is actually a macro: if( NEVE

Re: [sqlite] Segmentation fault on OpenBSD

) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) ; At least that is what I am passing to Perl's DBD::SQLite prepare() method. I am then binding the following values before running execute: $VAR1 = [ 'Mark Lawrence', 'em...@ad

Re: [sqlite] Emergency Bail Out

Rich Shepard wrote: Yesterday I trapped myself in sqlite3 and could not exit the application. I was running the SQLite shell in a virtual console and inadvertently entered ',e' instead of '.e' to exit. Cue the theme from 'Jaws.' I was trapped and could not escape. Not, that is, until I went

[sqlite] SQL query - TOP

to the one above. Thanks in advance for any help. Mark DISCLAIMER: This information and any attachments contained in this email message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and e

RE: [sqlite] SQL query - TOP

-users@sqlite.org > Subject: RE: [sqlite] SQL query - TOP > > > > > Regarding: "It would appear that the "TOP" syntax is not supported by > SQLite (maybe just a Microsoft thing?). However is there an > alternative? " > > Take it to the "L

Re: [sqlite] migrating from mysql

Frederick Grim wrote: Howdy all, So I am wondering if anyone has run into this problem. I am trying to move from mysql to sqlite and the unique constraint from primary keys is not allowing me to insert my sql that I dumped from the mysql database. I have a bunch of join tables so I reall

[sqlite] SQLite db lock problem

gratefully received. Mark DISCLAIMER: This information and any attachments contained in this email message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under

[sqlite] journal - "Unable to open the database file"

get around the problem of a journal file being locked and SQLite cannot delete it? Because at the moment if this situation occurs no one can write to that Db until the journal file has gone. Which is quite a severe problem... Thanks Mark DISCLAIMER: This information and any attachments co

RE: [sqlite] journal - "Unable to open the database file"

have the > extension .db for the > database file and I think if you change that to something > like .db3 then it > won't happen. > > RBS > > -Original Message- > From: Allan, Mark [mailto:[EMAIL PROTECTED] > Sent: 09 March 2007 16:23 > To: sqlite-use

RE: [sqlite] journal - "Unable to open the database file"

ginal Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 09 March 2007 16:36 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] journal - "Unable to open the database file" > > > "Allan, Mark" <[EMAIL PROTECTED]> wrote: > > 3)

Re: [sqlite] Re: create or update question

Eric S. Johansson wrote: if the insert fails (i.e. record exists), it triggers an exception which I use to trigger an update. I get many more updates than inserts of course but I haven't figured out how to trigger an exception on update if the record doesn't exist. From the FWIW dept, woul

Re: [sqlite] DB design questions

, type INT, value TEXT) Is there anyone who has experience with this kind of design, do you have better ideas on modelling this kind of data? Thanks, Mike -- Mark Pirogovsky "Computers made it possible to make millions mistakes a second" "Ask no q

RE: [sqlite] Japanese-Korean characters

I think what he is trying to say is that you can store Japanese/Korean characters in your database using a UTF-8 or Unicode string. We currently use Sqlite and support Chinese, and plan to implement Japanese and Korean and have had no problems. We store the text as a UTF-8 encoded string. Provid

[sqlite] SQL query help (mutiple joins)

has a foreign key to ExaminationsTable and both ForcedSpiroTable and RelaxedSpiroTable have a foreign key to the TestTable. Your help would be gratefully received Thanks in advance Mark DISCLAIMER: This information and any attachments contained in this email message is intended only for the

RE: [sqlite] SQL query help (mutiple joins)

then I get Joe Bloggs Joe Bloggs Joe Bloggs Joe Bloggs Joe Bloggs What I want is Joe Blogs just the once. Does this make sense? What I need to do is find all patients that have an EVC and FVC greater than 2.0. Is there a way to do this? Am I missing something? Thanks again Mark >

RE: [sqlite] SQL query help (mutiple joins)

g > Subject: Re: [sqlite] SQL query help (mutiple joins) > > > On 5/1/07, Allan, Mark <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Thanks for your quick replies. I have tried this method but > however I am getting a row returned for each entry in > Forc

RE: [sqlite] SQL query help (mutiple joins)

> Allan, Mark wrote: > > What I want is Joe Blogs just the once. > > > > > Mark, > > Then try adding distinct like this: > > select distinct p.* > from PatientsTable as p > join ExaminationsTable as e on e.PatientID=p.ID > join TestTable as t on

RE: [sqlite] SQL query help (mutiple joins)

> > Ok, so here's another question, how would I get the count of > patients where the EVC and FVC > 2.0? > Dont worry I have figured this out. I am doing:- select count (distinct p.PatientID) p.* from PatientsTable as p join ExaminationsTable as e on e.PatientID=p.ID join TestTable as t on t.E

[sqlite] Search on Age, from DOB column

ars within an SQL string? The patient table is similar to:- Patients { INTEGER PrimaryKey; TEXT Surname; TEXT FirstName; TIMESTAMP DOB; ... ... ... } Thanks in advance for your help. Mark DISCLAIMER: This information and any attachme

RE: [sqlite] Search on Age, from DOB column

Thanks to everybody that contirbuted to this thread. I have now implemented this functionality and it works well. DISCLAIMER: This information and any attachments contained in this email message is intended only for the use of the individual or entity to which it is addressed and may contain i

[sqlite] Building a newer SQlite3 dylib/framework for XCode ?

app itself). An app like SQLiteManager is doing exactly what I need - it seems to have a newer version embedded, and the SQL I need to run in my own app (which fails with the OS library) is already working perfectly in SQLiteManager. Any assistance would be most welcome. Thanks Ma

[sqlite] Building a newer SQlite3 dylib/framework for XCode ?

app itself). An app like SQLiteManager is doing exactly what I need - it seems to have a newer version embedded, and the SQL I need to run in my own app (which fails with the OS library) is already working perfectly in SQLiteManager. Any assistance would be most welcome. Thanks Mark Gilbert.

[sqlite] Macintosh + Amalgamation - Cursor Struct is already defined in Mac

suggestions on how I can avoid the error, 'redefinition of struct Cursor' ?? Mark -- [EMAIL PROTECTED] Tel: +44 208 340 5677 fax: +44 870 055 7790 http://www.gallery.co.uk - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Sqlite 3 Crash on OSX

0x9408b343 sqlite3_exec + 260 7 libsqlite3.0.dylib 0x9407a53d sqlite3_get_table + 189 Anyone have anything specific to suggest ? Cheers Mark. -- [EMAIL PROTECTED] Tel: +44 208 340 5677 fax: +44 870 055 7790 http://www.gallery.co.uk

[sqlite] ALTER TABLE ADD COLUMN - strange behaviour....Mac OSX

ote that the SQLite database is NOT open at the time. it subsequently opens OK, but the ALTER TABLE ADD COLUMN fails. Anyone have *any* idea what is happening ? Cheers mark -- [EMAIL PROTECTED] Tel: +44 208 340 5677 fax: +44 870 055 7790 http://www.galle

[sqlite] Full Text Search

Folks. I have just started learning about Full Text search in SQlite, and I have some questions 1) With the Amalgamated Sqlite, I guess to enable FTS I just #define SQLITE_ENABLE_FTS2 at the start of sqlite3.c Is there anything else I have to do to switch it on ? 2) If I want to do a full

[sqlite] Multiple connections - stale cache?

s on why we are seeing what we see? I could add the call to enable the shared cache, but I really want to understand why it doesn't work without it. Thanks, Mark

RE: [sqlite] Multiple connections - stale cache?

Thanks for the quick reply. Unfortunately, we are developing code on the vxWorks platform, so I don't think sample code would be of use. We have seen the problem for some time now...at least from 3.3.12. The submitter of the ticket appears to have the exact same scenario as us. Hopefully he can

RE: [sqlite] Multiple connections - stale cache?

style (which we are using) due to unavailability of certain headers and functionality on vxWorks. Thanks for your help, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Multiple connections - stale cache?

:0:42:-82 DB Counter 0:0:42:-82 DB Counter 0:0:42:-82 DB Counter 0:0:42:-82 DBC2: Got session number: 350100 Thanks for any help, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Multiple connections - stale cache?

exact SQL statements without trimmed output, just let me know, and I can send it to you privately. Thanks for your help, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Multiple connections - stale cache?

in vxWorks support, and I'll keep the group posted of the results. Thanks so much! Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Multiple connections - stale cache?

My final post on this issue...vxWorks has confirmed a bug in their fstat() implementation. I'm hoping for a quick resolution. Thanks for the help. Mark > > Just a follow-up for the group... > > Richard was able to determine that my platform is having > trouble with an &

RE: [sqlite] SELECT ORDER BY failure

No, we are actually filling in the parameter with a valid integer value. I was just trying to say it was a parameter. > > Are you actually searching for records where F is the string "?" > > If so, why don't you try WHERE F="?" instead of leaving it with the > ? unquoted. --

Re: [sqlite] how do i generate a uniqueidentifier ?

Chase wrote: how do i generate a uniqueidentifier ? Define a column as follows: {fieldname} INTEGER NOT NULL PRIMARY KEY eg: CREATE TABLE hardware_types (record_key INTEGER NOT NULL PRIMARY KEY,hardware_key INTEGER default 0); -

Re: [sqlite] SQLite.org needs online forms

john s wolter wrote: SQLite.org in my opinion, needs to have online community forms. I first used majordomo ten years ago which is like the list manager being used for sqlite-users@sqlite.org but in today's Internet it can be mistaken for SPAM. I do not know if SQLite would qualify because of t

Re: [sqlite] Replacing Clipper DB lookup application

john s wolter wrote: I have an old Clipper DBF type application that has worked well but times changed and changed long ago. The feature of this DBF, non-GUI, text oriented, application is that it is mostly a list lookup application with few DB changes. A separate Admin program does list manage

[sqlite] SQLITE_BUSY error in multi-threaded environment

od failing due to our custom h/w, so most likely this is the problem, but just thought I would ask. Thanks, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

Hi Andre- Thank you for your insight. Looks like we have some redesign scheduled for today. :) Thanks, Mark > -Original Message- > From: Andre du Plessis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 15, 2007 5:05 AM > To: sqlite-users@sqlite.org > Subje

RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

Hi Andre- After rereading your post, I wanted to confirm something. In your example below, are thread1 and thread2 connected to the same database, or different databases? In my scenario, the threads are connected to different databases, so I'm not sure if it is the same situation. Thanks,

RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

any effect on database activity on a different connection to DB2. Thanks, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

27;m still thinking our problems may be low-level file i/o bugs with our OS, so perhaps taking out the file-based .lock scheme will help. Thanks, Mark > -Original Message- > From: Ken [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 15, 2007 12:39 PM > To: sqlite-users@sq

[sqlite] SQLite Database Browser for creating databases

? Would the format of the database be compatible? Thanks, Mark

[sqlite] remote access to sqlite db?

Hi, Does sqlite offer the ability to connect to a sqlite db file on a remote machine? I've been using it locally for awhile and it's great. Wanted to see if it could be used remotely for some simple tasks. Th

[sqlite] Moving database connections across threads

code in the SQLite library at the same time, and also allows only one transaction to occur at a time. Thanks for your help, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Moving database connections across threads

(), and hence, we should have no problem (from a SQLite point of view) of having multiple threads use the same connection, as long as we are correctly controlling access to this connection with our own mutexes. Is that right? Thanks, Mark > -Original Message- > From: John Stanton [

[sqlite] dates and times in sqlite

x27;ve looked at the extended functions here: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions but am unsure of how to take advantage of them. Thank you, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: dates and times in sqlite

Oh I forgot to put quotes around the result, thanks Igor, Mark On 9/20/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Mark Wyszomierski <[EMAIL PROTECTED]> > wrote: > > I've made a text field called "timestamp" which has dates in the form: > > >

[sqlite] where is SQLITE_OPEN_READONLY defined?

Hi, I wanted to open a sqlite database read-only - where is: SQLITE_OPEN_READONLY defined? Thanks - To unsubscribe, send email to [EMAIL PROTECTED] --

Re: [sqlite] Re: where is SQLITE_OPEN_READONLY defined?

Ah shoot didn't realize that, thanks. Do you happen to know by any chance if opening in read-only mode improves performance at all? Or is it really just a safe-guard feature. Thanks, Mark On 9/23/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Mark Wyszomierski <[EMAIL PR

[sqlite] sqlite ODBC?

Hi, Are there are ODBC drivers out there for sqlite on win32? I'm already using an ODBC library and wanted to see if I could get around rewriting everything using the native sqlite API. Thanks, Mark - To unsubs

[sqlite] Re: sqlite ODBC?

t? Thanks, Mark On 10/3/07, Mark Wyszomierski <[EMAIL PROTECTED]> wrote: > Hi, > > Are there are ODBC drivers out there for sqlite on win32? I'm already > using an ODBC library and wanted to see if I could get around > rewriting everything using the n

[sqlite] Question regarding I/O under the new VFS model

I'm working with implementing my own VFS. If the developer(s) could answer a couple of questions, it would be helpful. In section 2.1.4 of the SQLite 3.4.2 to 3.5.0 document, reference is made to "a database file will be doing page-aligned sector reads and writes in random order" regarding th

Re: [sqlite] Question regarding I/O under the new VFS model

quentially (with the exception of the header). That is a useful hint for these types of files. It sounds like journal reads and writes won't be sector sized and/or sector aligned. I can accommodate that with little effort as well. [EMAIL PROTECTED] wrote: Mark Spiegel <[EMAIL PROTE

[sqlite] winLock() in SQLITE 3.5.1...

While working on a VFS for use in 3.5.1, I was looking at the winLock() and have a question. Is it possible for the lock on a winFile object to progress from SHARED_LOCK to EXCLUSIVE_LOCK without first acquiring a RESERVED_LOCK? Assuming that it is, it seems that the comments at the start of

[sqlite] unresolved external symbol _TryEnterCriticalSection

don't understand what the solution is? I'm already linking to kernel32.lib, Thanks, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] unresolved external symbol _TryEnterCriticalSection

Thanks guys. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Mark Wyszomierski" <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I'm trying to upgrade to the latest version of sqlite (3.5.1) for > > windows. Compiling the sqlite l

[sqlite] winLock() in SQLITE 3.5.1...

I posted this to the list last Wednesday and haven't seen a reply. D0n't want to create traffic in the defect database if I am in error. Anyone want to take a crack at this? While working on a VFS for use in 3.5.1, I was looking at the winLock() and have a question. Is it possible for the

Re: [sqlite] winLock() in SQLITE 3.5.1...

Thanks Dan. How about the second part. Should the PENDING_LOCK be taken en route from the SHARD_LOCK to EXCLUSIVE_LOCK? Which is right, the code or the function header? Dan Kennedy wrote: On Mon, 2007-10-22 at 10:56 -0700, Mark Spiegel wrote: I posted this to the list last Wednesday and

Re: [sqlite] Re: Some Questions Regarding Access To a SQLite Database By More Than One Process

Here's a bit more locking info that I found useful to help understand it all out of the archives: http://www.mail-archive.com/sqlite-users@sqlite.org/msg02845.html If you are writing a Windows app, you can use a named mutex which can be shared across processes. I have need for a blocking (as

Re: [sqlite] SQLite version 3.6.14

Based on what I've read, it certainly could. As I understand it, there is a single queue for all the writes so the writes for multiple databases, journals, etc. are going to that single queue. Based on that, it is certainly "possible" that your overall throughput and throughput for any indivi

Re: [sqlite] Join performance in SQLite

optimizations to avoid starting the query with an index build. Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Db design question (so. like a tree)

hild be greater than the id's of the parents. Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 64 bit compatibility of sqlite 3.5.7

For 32 bits it should be a long, for 64 bites, a 64 bit integer type. For example __int64 in Windows. sqlite3_intptr_t has to be large enough to hold the larger of an integer or a pointer on each platform. We had to fix this too... Gopala Surya wrote: > Hi All > We have been using sqlite vers

[sqlite] Shared binary plus static lib

Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary but also with a libsqlite3.a static lib. Could anyone suggest how I could alter this Makefile to support these requirements please? For x86_64 and i686, kernel 2.6.29.4, glibc 2.10.1. TOP = ../sqlite3 BCC = gcc -O2 USLEEP = -DHAV

Re: [sqlite] Shared binary plus static lib

On Sunday 07 June 2009 00:15:21 Jay A. Kreibich wrote: > > Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary > > but also with a libsqlite3.a static lib. Could anyone suggest how I > > could alter this Makefile to support these requirements please? > > Assuming you're using the

Re: [sqlite] Shared binary plus static lib

On Sunday 07 June 2009 10:51:05 Jay A. Kreibich wrote: > > > > Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary > > > > but also with a libsqlite3.a static lib. Could anyone suggest how I > > > > could alter this Makefile to support these requirements please? > > > > Is there a p

Re: [sqlite] Shared binary plus static lib

Would anyone have a clue as to how I could end up with /usr/lib/libsqlite3.so.0 as well as /usr/bin/sqlite3 and /usr/lib/libsqlite3.a ? cc -DTHREADSAFE=0 -c sqlite3.c cc -DHAVE_READLINE=1 -o sqlite3 sqlite3.o shell.c -ldl -lreadline -ltermcap -I/usr/include/readline ar cru libsqlite3.a sqlite3.o

Re: [sqlite] Shared binary plus static lib

On Sunday 07 June 2009 14:26:07 Mark Constable wrote: > Would anyone have a clue as to how I could end up with > /usr/lib/libsqlite3.so.0 > as well as /usr/bin/sqlite3 and /usr/lib/libsqlite3.a ? Another one for the list archives. I'm not sure if this is 100% correct but the resul

[sqlite] Direct row insert from C (without SQL) / Database speed

ux or windows ? And what about stroing the database onto a Solid state disk or on a Raid 6 array normal HD Best regards, Mark Flipphi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reducing the size of executable linked with sqlite3.c

http://www.sqlite.org/compile.html There are options you can use to disable/remove unused features. Some can give significant size savings. (I did this on Windows, YMMV.) Unfortunately, you can't just use these with the amalgamated source. You will probably have to rebuild it. It's not har

[sqlite] SQL result to struct

there any examples ? With kind regards, Mark Flipphi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

Stan Bielski wrote: > In the course of copying a largish (20 GB) database file while > accessing it via sqlite3, the machine became very unresponsive. I > opened task manager and found that the system was using a huge amount > of virtual memory, causing it to thrash. Per-process memory usage > look

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

> Just to be clear, I think Windows is really the one that is at fault > here; the behavior seems very broken to me. Unfortunately, I need the > app to work on Windows without this happening, so I need to figure out > some kind of workaround in a.) Windows settings b.) the sqlite source > or c.) h

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

Stan Bielski wrote: > Hello again, > > Copying the database with Explorer and accessing it via sqlite is just > a contrived example that exhibits the same problem I'm having in my > application. The app does make a copy of the DB, but it has app-layer > locking that will prevent modifications unle

[sqlite] resource temporarily unavailable after sqlite3_open()

Environment: Linux axis 2.6.19 #9 PREEMPT Mon Apr 6 15:44:03 EDT 2009 cris unknown Sqlite: Sqlite: sqlite-3.6.14 ./configure --host=cris-axis-linux-gnu --prefix=/AEMDEV/83+/devboard-R2_10/target/cris-axis-linux-gnu --enable-static=yes --enable-shared=yes --disable-dynamic-extensio

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

I also (just) tried 3.6.17. Same issue. /m Mark Richards , On 8/11/2009 14:53: > Environment: > Linux axis 2.6.19 #9 PREEMPT Mon Apr 6 15:44:03 EDT 2009 cris unknown > > Sqlite: > Sqlite: sqlite-3.6.14 > ./configure --host=cris-axis-linux-gnu >--prefix

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

SyslogMessage("SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } sqlite3_close(db); (Note: WriteSyslogMessage() issued a system("logger 'string'"); call) Same issue. -1 returned during read(). /m D. Richard Hipp , On 8/11/2009 15:38: > O

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

D. Richard Hipp , On 8/11/2009 16:02: > > Perhaps pthreads is going goofy. Please recompile with - > DSQLITE_THREADSAFE=0 and see if that helps. > BINGO. env CC="gcc-cris -mlinux -isystem $EROOT/include"CPP="gcc-cris -mlinux -E -isystem $EROOT/include" CXX="g++-cris -mlinux -xc++ -i

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

D. Richard Hipp , On 8/11/2009 16:39: > program is using LinuxThreads or NPTL for its threading. (SQLite has > to know which is used because there are serious bugs in LinuxThreads > that SQLite has to work around.) So pthreads gets used once, by > SQLite, even if you don't do any threading in you

Re: [sqlite] Booleans in SQLite

Jay A. Kreibich wrote: > Integer values between -128 and 127 use only a single byte of storage above > and beyond the header size that all values have. > Not quite. Values between 0 & 127 use 1 byte of storage. Negative values use the full 9 bytes in my experience. (I'm setting aside the

Re: [sqlite] Booleans in SQLite

D. Richard Hipp wrote: > You are both right and both wrong. There are two different integer > representations used in SQLite. > > (1) "varint" or variable length integer is an encoding of 64-bit > signed integers into between 1 and 9 bytes. Negative values use the > full 9 bytes as do large

Re: [sqlite] Booleans in SQLite

D. Richard Hipp wrote: > Most varints are "type varints" and type varints are almost always a > single byte (the only exceptions being for large blobs or strings). > Varints are also used to store the total number of bytes in a row > (also usually one byte). Most varints are a single byte.

  1   2   3   4   5   6   >