Re: [sqlite] Fwd: signal 6 during sqlite_step in WAL mode

ween the #8 sqlite3_free() call and #14 sqlite3_step(). Increase in compile time is minimal (less than 2 seconds) in my laptop in a fresh rebuild. > > Thanks! > > Mattan. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org &

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

sqlite3 versions. Please, check index schemas for a where clause in them. > > The same thing happens when I execute the failing query with the > sqlite3 C Library, using years-old tested code. > > Thank you! > > Jerry Krinock --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

ry key? If it is then delete it because Sqlite adds primary key on indexs by default. Run analyze/reindex after change. > > Thanks, > -jens > > --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sq

Re: [sqlite] Improving Bulk Insert Speed (C/C++)

would not be such a tight bottleneck. Thus, I am > trying to see if there is anything I can do to improve on this. Perhaps he has 2 disks, first for read FASTQ, second for write sqlite db. > > Kevin --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Use of AUTOINCREMENT

"AUTOINCREMENT", if use it, it must query sqlite_secuence table, if not, it must search an empty id and both data are on memory often. Summary, it's not safer nor unsafer, faster or slower, it depends on your use case. HTH --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Primary key used in compound index

t; of the compound index? Adding additional column works, but it will > increase the database size and will slow down the insert statements > because this additional column needs to be updated with trigger or > with additional query. In indexs, the primary key is always added as last column. Sqli

[sqlite] Crash if "sqlite3_db_release_memory" has no memory to release

4, 3.8.4.1. amalgamation under FreeBSD 9.2 x86_64. using clang 3.4 compiler. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Out of memory error for SELECT char();

is provided for System V compatibility. This option is incompatible with the ``X'' option. > > The fix is to allocate 4*N+1 bytes instead of 4*N bytes. Dan is > checking in the fix even as I type this reply. > > > -- > D. Richard Hipp > d..

Re: [sqlite] RPAD/LPAD

at uses SQLite doesn't check it's input, functions that renames SQLite internals can be injected SELECT register_simple_function('MAX', 1, 'DROP TABLE ?'); No? > > > Regards, > Clemens --- --- Eduardo Morras <emorr...@yahoo.es> _

Re: [sqlite] RPAD/LPAD

line: sqlite3_create_function(db, "RPAD", SQLITE_UTF8, SQLITE_ANY||SQLITE_DETERMINISTIC, 0, sqlcmd_rpad, 0, 0); And create your function with: static void sqlcmd_rpad(sqlite3_context *context, int argc,sqlite3_value **argv){ // argc has number of parameters in **argv // parse

Re: [sqlite] Solved Weird out of memory problem a prepare

d luck! I find it and solve. It's a macro expansion in one function extension that collides and redefines a #define in sqlite3.h Thanks to all. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sq

Re: [sqlite] Weird out of memory problem a prepare

On Tue, 4 Mar 2014 15:19:24 + Simon Slavin <slav...@bigfraud.org> wrote: > > On 4 Mar 2014, at 3:15pm, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 4 Mar 2014, at 3:09pm, Eduardo Morras <emorr...@yahoo.es> wrote: > > > >> zSql= &quo

[sqlite] Weird out of memory problem a prepare

INTEGER PRIMARY KEY,\n"// Static resource ID " desc TEXT,\n" // Description " content BLOB\n"// Main content ");\n" I don't know why I get an Out of memory preparing the query. Vars are initialized, db points to an op

Re: [sqlite] Why would batched write operations NOT be faster than individual ones

; in a non-conformant compiler. No, it's talking BS on language that is bad designed for your actual needs and no matter which compiler you use because is not an implementation problem. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users

Re: [sqlite] Why would batched write operations NOT be faster than individual ones

with > how RAID works. It's how RAID5 works. Check this page docs http://baarf.com/ about it. > > Simon. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Network Storage

thers submit requests to it via nanomsg. > > Best regards/Mit freundlichen Grüßen --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to detect database change made by another application

se user_version for other things, I put there the version of my app/db, but it can fit your needs. > > -- > Will > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/list

Re: [sqlite] SQLite scalability

gt; ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite clusters?

k was 0mq architect/project developer/man behind the throne, and now is nanomsg architect/project developer/man behind the throne. http://zeromq.org/0mq http://nanomsg.org/ nanomsg http://250bpm.com/ Martin Sústrik Home P

Re: [sqlite] SQLite clusters?

tes, never use triggers that modify data or calculate secundary data nor call now() on sql. We have not tried to run it on more servers or with bigger write load. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.

Re: [sqlite] SQLite clusters?

FT table and more rows. The other manner (raid1), having all sqlite servers the same data is easier and is done with virtual tables and nanomsg/0mq to send locks on write (only one server can write to all) and data. But if you need it, PostgreSQL don't need those tricks. --- --- Eduardo

Re: [sqlite] Query problems

On Mon, 2 Sep 2013 13:48:02 +0100 Simon Slavin <slav...@bigfraud.org> wrote: > > On 2 Sep 2013, at 8:25am, Eduardo Morras <emorr...@yahoo.es> wrote: > > > Or create the index with collate > > > > CREATE INDEX idx_collated_column ON myTable ( column COLLA

Re: [sqlite] What am I missing when recovering a hot journal?

y help you. Default is 1000, in a similar environment (embedded device that reads data from external analogic devices) we setted it to 1. > ~Mike Foss --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] Query problems

the index with collate CREATE INDEX idx_collated_column ON myTable ( column COLLATE NOCASE ) > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/

Re: [sqlite] Where Clause

It's 10-15 lines of code + comments. Here's a pointer to it http://www.sqlite.org/capi3ref.html#sqlite3_update_hook , remember to free/fry it after use ;) HTH --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sq

Re: [sqlite] Memory usage of sqlite3

Explain: 0 0 0 SCAN TABLE tour USING INTEGER PRIMARY KEY (~100 rows) > - >8 I don't know why it doesn't use the primary index. Perhaps analyze statistics before solves the problem. HTH --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Memory usage of sqlite3

ORE set to 3? --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Connection between SQLite - Other Databases

y are there any features available in SQLite ?? Use csv. > Thank you > Reddy Balaji C. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select count(*) does not use primary key??

On Fri, 07 Jun 2013 13:12:14 +0200 Clemens Ladisch <clem...@ladisch.de> wrote: > Eduardo Morras wrote: > > where t.a = NULL > > where t.a IS NULL > > (NULL compares as not equal to any value, including itself.) OPppss you're right. Thought too fast and wrote e

Re: [sqlite] select count(*) does not use primary key??

, doesn't it? > -- > D. Richard Hipp > d...@sqlite.org --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Header Application-ID list

On Thu, 6 Jun 2013 08:15:57 -0400 Richard Hipp <d...@sqlite.org> wrote: > On Thu, Jun 6, 2013 at 8:05 AM, Eduardo Morras <emorr...@yahoo.es> wrote: > > > > > Hi, > > > > Is there an official list of assigned application id sqlite header? If >

[sqlite] Header Application-ID list

Hi, Is there an official list of assigned application id sqlite header? If exist, How can I register my application-id? Thanks --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.or

Re: [sqlite] How to read log file format into sqlite database?

will welcome. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance HELP

min or SQLite - so I prefer not to switch DBMS If i need to upgrade dbms, i use Postgres. But i don't think you need it. > f.Something else ? Reread Simon's email and sail the documentation and test. > Thank you so much for your help. > > peterK HTH --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fw: Fw: Is there a command to lock a database for a short while (0.25 sec, say)

't in wal mode. You can check it calling the correct pragma. > > Jonathan > --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fw: Is there a command to lock a database for a short while (0.25 sec, say)

second period. > > http://www.sqlite.org/lang_transaction.html > BEGIN EXCLUSIVE > > > > > Thanks in advance. > > > > Jonathan Trahair > > Regards, > Simon > ___ > sqlite-users mailing list >

Re: [sqlite] How to achieve fastest possible write performance for a strange and limited case

antees? > Or, is it simple that I should just write directly to file myself? Piping through gzip -6 or xz -2 will minimize bytes to write. If you are working with 5D images xz (7-zip LZMA fork) will do the best. For processing you do zcat file | processing_application or xzc

Re: [sqlite] :memory: performance in sqlite 3.6

> be* dramatically faster than disk, but something changed in the last > couple of years. The only thing i can think that explain it is compilation options, specifically SQLITE_TEMP_STORE=0. If you do pragma temp_store=2, does it work better? --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] :memory: performance in sqlite 3.6

, > and won't have time to look more closely for a while, if ever. I'm > passing this on in case this rings a bell for someone, and to have it in > the archives if someone else comes looking. > > -s --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

soon? Our platform is proprietary, so I'll need > to be incorporating source, not binaries. > > Thanks, > > Marc > --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange eviction from Linux page cache

e > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Deletion slow?

ding a new column for mark dirty rows will not work because you are using a sd-card, the cost of mark as delete/dirty those rows is greater than deleting them. > > Thanks, > > Jason > > ___ > sqlite-users mailing list > sql

Re: [sqlite] special aggregate feature vs query optimization

tml > . The max(x) column is then eliminated. > > Hope this is useful to know for who is using the feature. > > EPasma > > ___ > sqlite-users mailing list > sqlite-users@sql

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 07 Jan 2013 20:09:02 +0700 Dan Kennedy <danielk1...@gmail.com> wrote: > On 01/07/2013 03:22 PM, Eduardo Morras wrote: > > > > Hi, I use sqlite in some of my projects. In one it follows a > > parent/multichild model (multifork). The database is managed by the >

Re: [sqlite] Using sqlite in multi fork() without threads

o childs, otherwise we get errors because port is already in use by another pid. I thought the same may happened with the db connector and/or db file descriptor. > Pavlos > --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-us

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 7 Jan 2013 12:27:54 + Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Jan 2013, at 8:22am, Eduardo Morras <emorr...@yahoo.es> wrote: > > > The app works but, is anyone working with sqlite this way? Any advice to > > avoid db corrupts, deadloc

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 07 Jan 2013 05:43:50 -0800 Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/01/13 00:22, Eduardo Morras wrote: > > opened before the fork, and after it the childs use the database > connection. I don't w

[sqlite] Using sqlite in multi fork() without threads

changing to multithread model, i don't want to use them for this project. Thanks --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] C++ - nothing has been stored!!??

At 03:27 25/07/2012, you wrote: And here I am again, asking for what you find so easy and I. well, just cannot understand. ... but this does not store anything in the database table. I have used an sqlite browser to determine if, in fact, some data was stored, but no, nothing has been

Re: [sqlite] (no subject)

At 07:08 06/06/2012, you wrote: Hi, I have few queries regarding the SQLite. I have listed them below please go through them and give your answers. Thanks Say if I am working on a DB with 3 tables with 100 records each and each records with some 5 fields of data.Each field is varchar(20) 1.

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

At 06:48 05/06/2012, you wrote: Have a market data extractor running tick tapes and saving data to sqlite db. All coded in C++ and previously ran fine and fast on bare metal. Processes tick tapes from NAS and saved to local sqlite db's on c drive. We moved program onto VMWare VM's... same nas

Re: [sqlite] Two potential memory leaks in sqlite-3.7.11

At 14:06 11/04/2012, you wrote: On Wed, Apr 11, 2012 at 02:01:29PM +0200, Eduardo Morras wrote: > At 12:09 11/04/2012, you wrote: > >Hi, all > >I have applied a memory leak detection tool > >Melton<http://lcs.ios.ac.cn/~xuzb/melton.html> to > >find memory leaks i

Re: [sqlite] Two potential memory leaks in sqlite-3.7.11

At 12:09 11/04/2012, you wrote: Hi, all I have applied a memory leak detection tool Melton to find memory leaks in sqlite-3.7.11. Two bugs were found, and I check them manually as the real ones. Here is the url of the bugs:

Re: [sqlite] In-memory and temporary database

At 11:32 28/03/2012, you wrote: Hello, I'm doing some test with SQlite 3.7.11 in Windows Embedded industrial PC. I need to store data in a table very quickly. Let's say new data each 10 msec. I tryed with DB on disk but obviously was not possible to reach the correct performance. So I tryed

Re: [sqlite] Optimize Table Access Efficiency

At 07:53 21/03/2012, Max Vlasov wrote: On Wed, Mar 21, 2012 at 1:33 AM, Tim Morton wrote: > So it seems the index is no help; > Are you sure you did as Simon explained? Becausem my tests shows the trick works... (sqlite 3.7.10) The trick works, but i think he

Re: [sqlite] SQLite Amalgamation

At 04:58 08/03/2012, you wrote: Hi guys, Decided to open a discussion on SQLite amalgamation. Please forgive us, Windows users, who unlucky enough to use Microsoft Visual Studio. As many of you know, it is year 2012 now, and Visual Studio is up to version 10, but the guys at Microsoft still

Re: [sqlite] Backup API handling of corrupt source DB

At 12:22 07/03/2012, you wrote: Dear list, I'm using the backup api to frequently backup a running sqlite database. I'm wondering if the backup API is able to detect a corrupt database or will it simply also backup a corrupt DB ? I evaluating the need to issue a (timeconsuming) "pragma

Re: [sqlite] Three small patches for lemon

At 04:21 08/01/2012, you wrote: [I sent this 3 months ago, but got no response - if this is the wrong place to be sending patches, please tell me where they should be sent.] Attached are three small patches for lemon: lemon-remove-duplicate-prototype.patch - remove a duplicate prototype for

Re: [sqlite] search

At 15:10 27/12/2011, Mohit Sindhwani wrote: On 27/12/2011 9:25 PM, Eduardo Morras wrote: At 11:27 27/12/2011, you wrote: Thank you. I agree. It's correct. I already have data base with /country/state/city/village format. Is it possible to do that while virtual table creation time? if yes

Re: [sqlite] search

At 11:27 27/12/2011, you wrote: Thank you. I agree. It's correct. I already have data base with /country/state/city/village format. Is it possible to do that while virtual table creation time? if yes, how? Change '/' to ','. This way you get a csv file which you can import directly. Perhaps

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

At 14:04 18/10/2011, Igor Tandetnik wrote: Frank Missel wrote: > I think that the sqlite-users e-mail list has enough traffic to warrant a > proper forum. For what it's worth, I'm using GMane (http://gmane.org/), which is a mailing list-to-NNTP gateway and happens to carry

Re: [sqlite] Example of implementing undo/redo using sqlite3?

At 19:58 04/08/2011, Stephan Beal wrote: >Hi, all! > >http://www.sqlite.org/whentouse.html > >says: > >"Temporary triggers can be added to the database to record all changes into >a (temporary) undo/redo log table. These changes can then be played back >when the user presses the Undo and Redo

Re: [sqlite] Threading makes SQLite 3x slower??

Oks, another let's try another thing/think. Try the select without the COUNT(*): SELECT class FROM data_r JOIN data USING (rowNum) WHERE 57 < col0min AND col0max < 61 AND 52 < col1min AND col1max < 56 AND 66 < col2min AND col2max < 70 AND 88 < col3min AND col3max < 92 AND 133 < col4min AND

Re: [sqlite] Threading makes SQLite 3x slower??

At 06:53 04/08/2011, you wrote: >I was hoping they wouldn't block each other because it's a read >lock. I tried making an index on all the columns, but R*tree table + >JOIN that I'm using runs about 10x faster. I might have done >something wrong, so I'm open to suggestions on a better index,

Re: [sqlite] LevelDB benchmark

At 14:19 29/07/2011, Black, Michael (IS) wrote: >What they don't say explicitly is that if all you need is key/value >capability then an SQL database is overkill and only slows you down >(bit of a duh factor there though not obvious to >neophytes). Generally speaking that's one thing they

Re: [sqlite] LevelDB benchmark

At 02:53 29/07/2011, Richard Hipp wrote: >On Thu, Jul 28, 2011 at 12:27 AM, wrote: > >I suspect that I will come up with other suggestions once I have a chance to >dig a little deeper into the benchmarks. If you have suggestions, please >publish them here. They are

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

At 12:58 03/06/2011, you wrote: >Guys, the server for this game - > >http://www.frozensynapse.com > >uses SQLite. We've had an unexpectedly successful launch which has >resulted in the server being swamped with players, and I'm trying to >optimise everywhere I can. I've always been under the

Re: [sqlite] insert speeds slowing down as database size increases (newb)

At 13:10 29/10/2008, you wrote: >Look up the implications of Sqlite's ACID feature and the use of >transactions. COMMITs are tied to disk rotation speed. On our Sqlite >databases where we look for performance we use 15,000 rpm disks and are >diligent in wrapping INSERTs, UPDATEs and DELETEs in

Re: [sqlite] How to speed up read-only databases?

At 13:47 15/10/2008, you wrote: >Hi there, > >i am using a 120MB database in an embedded project (a DVD-ROM project) >and was wondering what I can do to speed up its reading using diverse >PRAGMA statements. >The database is locked, meaning that no data is being inserted or >deleted from it. I am

Re: [sqlite] design question / discussion

At 19:12 20/05/2008, you wrote: >Actually my reason for writing into a seperate database is more... >well crude. I tar several databases together then encrypt using >openSSL. Then an FTP like program transmits the data a central server. > I must suspend writing into the database for the duration

Re: [sqlite] Porting into a microcontroller, minimum requirements

At 02:43 07/05/2008, you wrote: >Hi, > >I was wondering if anyone has any basic guide lines on embedding SQLite into >a microcontroller. For example, I am considering using an 8/16 bit processor >with 1 MB flash, 1 MB SRAM and 2 GB data storage (SD card). Has anyone ported >this before to an

Re: [sqlite] splite database under version control (subversion)?

At 23:19 04/05/2008, you wrote: >If you use svn only to sync over many pc maybe you can put your project on a >usb device (or usb hd) so you don't need to "sync" with svn. > >If you WANT to use svn and you are under linux you can create an alias for >commit that make a dump of your db then commit

Re: [sqlite] blob :: storing files within sqlite3

At 09:57 24/04/2008, you wrote: >Hi. > >I intend to use sqlite3 to store files. > >I've tested inserting an 7.6MB file in a blob column but it returns a >SQLite3::TooBigException. I'm using ruby API. > >I've installed sqlite3 through a binary package. How can I know what is >the maximum length

Re: [sqlite] Version 3.5.5 Released

At 18:33 31/01/2008, you wrote: >The big change from version 3.5.4 is that the internal virtual >machine was reworked to use operands in registers rather than >pulling operands from a stack. The virtual machine stack has >now been removed. The removal of the VM stack will help prevent >future

Re: [sqlite] Implementation of TPCC benchmark

At 23:53 30/01/2008, you wrote: On Wed, 30 Jan 2008, Steve VanDeBogart wrote: SQLite-ers, OSDL-DBT is a set of TPC like benchmarks implemented by OSDL (http://osdldbt.sourceforge.net/). I've added SQLite support to the DBT2 benchmark (TPCC like). The patch is attached in case anyone is

Re: [sqlite] Performance tuning using PRAGMA, other methods

At 19:12 20/11/2007, you wrote: What are the 'biggest bang for the buck' sqlite optimization techniques to apply to a working system to tune performance? Q1)) PRAGMA: Does anyone have experience and good results optimizing sqlite performance using PRAGMA's? If so, which ones, how were they

Re: [sqlite] Soft heap limit enforcement performance

At 19:41 30/10/2007, you wrote: Mostly I am interested in making sure that malloc(1000) does not fail even though you have 5 bytes free and they just happen to be scattered about as 100 discontinguous blocks of 500 bytes each. On the embebed device i worked (i made only the micro-os with

Re: [sqlite] Re: In Mem Query Performance

At 12:16 02/07/2007, you wrote: Hi, Pls notify me if it can be brought down to 1 sec. There is no mem constraint. I don't know x86 asm or gcc for x86, but in powerpc asm, if i use altivec libraries (libfreevec, f.e.) for string comparations, mem moves/copies, sorts etc... i get from x2 to

Re: [sqlite] Cache invalidation after insert statements.

At 11:20 22/06/2007, you wrote: HI all. Thanks for everyones help the problem is now solved. The memory drive worked like a bomb. Basically the problem on that server was that the insanely high IO prevented the OS from caching the file which slowed down the performance. After installing a mem

Re: [sqlite] How SQLite may work on AVR or similar mcu?

At 14:18 13/06/2007, you wrote: I do not need it actually, but i am so inquisitive. I have heard that sqlite has been ported to AVR too. How may be solved the main storage solved on it? So for example, i have system with ATmega64 with 128KB of external SRAM. The whole ram is organized as static

Re: [sqlite] Stack usage

At 20:31 05/06/2007, you wrote: > Excuse me for make this question but have you > normalized your database? Try to design/define it in at least 3NormalForm. My application's doesn't create any databases itself. It allows users to store any data. And users need to be able to store any

Re: [sqlite] Stack usage

At 16:40 05/06/2007, you wrote: Joe Wilson napisa³(a): > Please respond to the mailing list in the future. Sorry. Different client. I didn't notice the adress. > At least theres a known workaround, so no problem. Workaround is not a solution. > > > > hence your problem. > > > > Sure it is.

Re: [sqlite] sqlite internal structs don't make use of C bitfields?

At 17:18 31/05/2007, you wrote: >On 5/31/07, Eduardo Morras <[EMAIL PROTECTED]> wrote: >>At 23:25 30/05/2007, you wrote: >>>Setting and reading individual bytes (u8 in sqlite-speak) are not >>>threadsafe either. Only reading/setting entire entire words >&g

Re: [sqlite] Concurrency

At 20:58 01/06/2007, you wrote: >On 6/1/07, Eduardo Morras <[EMAIL PROTECTED]> wrote: > >>If i remember well, sqlite uses two databases for metadata/schema > >Databases or tables? Could you be thinking of the sqlite_master table? You're right 1 db and 2

Re: [sqlite] Does Attach improve Concurrency ?

At 19:32 01/06/2007, you wrote: >When you have a connection with multiple attached databases and the >connection acquires an exclusive lock, does it always lock all attached >databases or does it keep track of which databases require the lock? Does >using separate databases and attaching them

Re: [sqlite] Concurrency

At 19:24 01/06/2007, you wrote: >Why you said less than 29? SQLite has a soft limit of 10 databases and a hard limit of 32, you can change it at compile time. If i remember well, sqlite uses two databases for metadata/schema, so you get a max of 30 databases, you need another one as master db,

Re: [sqlite] Concurrency

At 11:17 01/06/2007, you wrote: >Hi, > >I am having a scenario where I have one reader/writer and many writer threads. >All writers are pretty basic (single INSERT INTO; some sort of a logging info >what a thread has done). > >I believe I will receive many BUSY return codes and I don't like these

Re: [sqlite] sqlite internal structs don't make use of C bitfields?

At 23:25 30/05/2007, you wrote: >--- [EMAIL PROTECTED] wrote: >> - Original Message >> > MemPage bitfield patch below. >> > >> > sizeof(MemPage) on Linux: >> > >> > original: 84 >> > patched: 76 >> > ... >> > Break-even for memory is 904/8 = 113 MemPage structs allocated. >> >>

Re: [sqlite] R-Trees and SQLite

At 18:09 20/05/2007, you wrote: >In a previous post drh mentioned: > > You need an R-Tree index to do something like this. The > public-domain version of SQLite only supports B-Tree indices. > > (http://www.mail-archive.com/sqlite-users%40sqlite.org/msg24643.html) > >Does this imply that there

Re: [sqlite] Efficiency and Pragmas

> >On 4/18/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote: >> >>cache is per-connection so if you open and close connections a lot then a >>large cache won't help your program. The command line app is a single >>connection so a large cache there will help (although not with the first

Re: [sqlite] Data structure

At 17:35 11/04/2007, you wrote: >Lloyd wrote: >> >>Sorry, I am not talking about the limitations of the system in our side, >>but end user who uses our software. I want the tool to be run at its >>best on a low end machine also. >>I don't want the capabilities of a data base here. Just want to

Re: [sqlite] Hashing question

At 16:20 29/03/2007, you wrote: >Eduardo Morras <[EMAIL PROTECTED]> wrote: >> Hello: >> >> I'm trying to use altivec simd code to SQLite. Has read hash.c >> but it looks like hashing is done one by one when insert data. >> Is it true? When is c

Re: [sqlite] Hashing question

At 11:27 29/03/2007, you wrote: >Hello: > > I'm trying to use altivec simd code to SQLite. Has read hash.c but it looks > like hashing is done one by one when insert data. Is it true? When is called > rehash function? If i insert data with index i think hashing happens one by > one, but if i

[sqlite] Hashing question

Hello: I'm trying to use altivec simd code to SQLite. Has read hash.c but it looks like hashing is done one by one when insert data. Is it true? When is called rehash function? If i insert data with index i think hashing happens one by one, but if i insert all data and after that make an

Re: [sqlite] One big database or various smaller ones?

At 17:22 26/03/2007, you wrote: >Hi > >I have a database with three tables (bigrams, trigrams and >tetragrams). Basically, they are: > TABLE( A, B, Count) IDX(A,B) IDX(B) > TABLE( A, B, C, Count) IDX(A,B,C) IDX(B) IDX(C) > TABLE( A, B, C, D, Count) IDX (A,B,C,D) IDX(B) IDX(C) IDX(D) >

Re: [sqlite] Index creation on huge table will never finish.

At 04:47 22/03/2007, you wrote: I don't think that solves my problem. Sure, it guarantees that the IDs are unique, but not the strings. My whole goal is to be able to create a unique identifier for each string, in such a way that I dont have the same string listed twice, with different

Re: [sqlite] Saving binary files

At 19:00 18/03/2007, you wrote: Hello John, thanks for the valuable piece of advice. The idea is that either 1) I store data in tabular form and work with them 2) I create a table of blobs and each blob is the binary content of a file (2) is my method in question, for (1) we all know it

Re: [sqlite] sqlite Performance

At 15:51 16/03/2007, you wrote: Dennis, Yes the data will be read later by down stream processing. I do have the option of either putting the data into sqlite at the start (when its read) or putting it into a flat file and then Later loading it into a sqlite db via a downstream job.

Re: [sqlite] Embedded Database Functions

At 17:00 24/12/2006, you wrote: On Sun, Dec 24, 2006 at 09:35:01AM -0600, John Stanton wrote: > >There is even a starting grammar for you: > > http://www.antlr.org/grammar/1107752678378/PLSQLGrammar.g > A compiler for a subset of PL/SQL would not be too arduous a project, If what you want is

Re: [sqlite] Embedded Database Functions

At 03:41 22/12/2006, you wrote: There has been discussion about extending Sqlite to have more functions, but the risk is creating Sqlite-Bloat and losing the most endearing feature of the product, its light weight and simplicity. Here is an interesting and thought provoking discussion on the

<    1   2   3   >