Re: [sqlite] Performance increase between 3.7 and 3.8

On Tue, 3 Feb 2015 06:39:02 -0700 (MST) Jan Slodicka j...@resco.net wrote: Eduardo Morras-2 wrote A ~8000MB db with app example data. More than 1000 query-corp created as part of test driven development of the app. We have precalculated the correct results in tables and its number of rows

Re: [sqlite] Performance increase between 3.7 and 3.8

On Tue, 3 Feb 2015 02:43:00 -0700 (MST) Jan Slodicka j...@resco.net wrote: Eduardo Morras-2 wrote I use a big test db to assure new versions of sqlite works properly. With 3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same hardware 27 minutes, it's 16/0.43 = 37% less or 27/0.43 = 63

Re: [sqlite] Performance increase between 3.7 and 3.8

properly. With 3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same hardware 27 minutes, it's 16/0.43 = 37% less or 27/0.43 = 63% improve. --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

. Regards, Navin ___ 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

Re: [sqlite] Advice needed for optimization options

___ 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

Re: [sqlite] VACUUM requires 6.7 times space ?

for gzip and -3 for xz is enough. -j --- --- 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] Error: database disk image is malformed

has attachment set to off, so they're deleted before remailed. --- --- 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] Counting rows

the I/O. 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] Bugreport - slowdown in sqlite after the ANALYZE statement

expect the unnecessary sort to be pure overhead. If you insert in correct index order, the index update phase is faster because it don't need rebalance the b-tree so often after each insert. --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

threads to update the same row multiple times, so only the last one was applied or apply them in one transaction, which is faster than apply them one by one. ~Joe --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

IO thread. Yes and no, your app can be multithread, but if only one thread has the sqlite3 pointer, you can use single thread sqlite3. This way, you have multiple working threads and one sqlite3 dedicated thread that recives the data to write and the data queries. --- --- Eduardo Morras emorr

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

)Disable autovacuum 2) Will ther be any write performance hit when the number of records in the DB increase? Thanks in advance ~Joe --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] Locking errors on network

, is in Sqlite repository, check http://www.sqlite.org/src/artifact/a2615049954cbb9cfb4a62e18e2f0616e4dc38fe a.k.a. src/test_server.c But, as others aim and hit, you should use a real C/S RDBMS, my preference, PostgreSQL server. HTH --- --- Eduardo Morras emorr...@yahoo.es

Re: [sqlite] Search query alternatives.

. ___ 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

Re: [sqlite] Window functions?

On Wed, 27 Aug 2014 23:04:40 +0200 Petite Abeille petite.abei...@gmail.com wrote: On Aug 27, 2014, at 10:57 PM, Eduardo Morras emorr...@yahoo.es wrote: Sorry, don't understand why others will throw an exception in the group by, perhaps I'm misunderstanding the group

Re: [sqlite] Window functions?

, handling of analytic functions…. :) --- --- 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] Severe performance degradation between 3.8.4.3 and

or whatever you want and update user_version. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras emorr...@yahoo.es

Re: [sqlite] Only allow child record if another field in parent is false.

/636024302cde41b2bf0c542f81c40c624cfb7012 for parent-child relationship example, it's for in-table relation but the in-code documentation is awesome, you can steal some ideas from it. Thanks. --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Building for vxWorks

or with the full sqlite3 src? Most of -DSQLITE_OMIT* won't work if you use the amalgamation. --- --- 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] Problem with many connections

to open database only when it is needed, to avoid risk of file corruption on power loss. Is there any known issue with multiple open/close operations? 1020 simultaneus connections? Perhaps iOS exhausted del max. file descriptor per process. Regards, Greg --- --- Eduardo Morras emorr

Re: [sqlite] Problem with many connections

a call to sqlite3_openv2? Or cycle of sqlite3_prepare_v2/step/finalize? --- --- 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] Fwd: signal 6 during sqlite_step in WAL mode

. ___ 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

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

--- --- 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?

primary key on indexs by default. Run analyze/reindex after change. Thanks, -jens --- --- 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] Improving Bulk Insert Speed (C/C++)

, platform, and hardware, I would imagine the SSD I am running on 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

Re: [sqlite] Use of AUTOINCREMENT

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

. In your first example, id is added twice to the index. Thanks in advance, Pavel. L --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Crash if sqlite3_db_release_memory has no memory to release

. 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();

. 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...@sqlite.org --- --- Eduardo Morras emorr...@yahoo.es

Re: [sqlite] RPAD/LPAD

extensions. 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] RPAD/LPAD

that renames SQLite internals can be injected SELECT register_simple_function('MAX', 1, 'DROP TABLE ?'); No? Regards, Clemens --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

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

. 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://sqlite.org:8080/cgi-bin/mailman

[sqlite] Weird out of memory problem a prepare

know why I get an Out of memory preparing the query. Vars are initialized, db points to an open sqlite3 db, and stmt is the first time used int the code. I use a similar code on other projects abd works with no problems. Any clue? Thanks --- --- Eduardo Morras emorr...@yahoo.es

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= SELECT r.name, s.content FROM resource AS r, static AS s WHERE (r.ids

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

. 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] Why would batched write operations NOT be faster than individual ones

and no matter which compiler you use because is not an implementation problem. --- --- 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

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

/db, but it can fit your needs. -- Will ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras emorr...@yahoo.es

Re: [sqlite] SQLite scalability

://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?

) and data. But if you need it, PostgreSQL don't need those tricks. --- --- 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?

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.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] SQLite clusters?

is nanomsg architect/project developer/man behind the throne. http://zeromq.org/0mq http://nanomsg.org/ nanomsg http://250bpm.com/Martin Sústrik Home Page --- --- Eduardo Morras emorr...@yahoo.es ___ sqlite-users

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

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 http://sqlite.org:8080/cgi-bin/mailman/listinfo

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 COLLATE NOCASE ) The problem with doing it in the index

Re: [sqlite] Query problems

NOCASE ) Simon. ___ 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

Re: [sqlite] Where Clause

. 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@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Memory usage of sqlite3

tour ORDER BY id LIMIT ?1 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

Re: [sqlite] Memory usage of sqlite3

? --- --- 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

?? 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] 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 exist, How can I register my application-id? The official list

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

for NULL values of a, which are not counted. count(*) does not. If I understand well , select count(a) from t = (select count(*) from t) - (select count(*) from t where t.a = NULL) and both selects will use cover indexs, doesn't it? -- D. Richard Hipp d...@sqlite.org --- --- Eduardo

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 even faster :( Regards, Clemens

[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.org:8080

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

. --- --- 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

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: Is there a command to lock a database for a short while (0.25 sec, say)

___ 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

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

are getting the lock twice, one with the pragma, that lock whole db, second wih the begin exclusive. If the database is in wal mode, it needs a read or a write access to get lock. Surely your db isn't in wal mode. You can check it calling the correct pragma. Jonathan --- --- Eduardo Morras emorr

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

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 xzcat file | processing_application --- --- Eduardo Morras emorr...@yahoo.es

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

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

--- --- 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

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] Deletion slow?

of mark as delete/dirty those rows is greater than deleting them. Thanks, Jason ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras emorr...@yahoo.es

Re: [sqlite] Strange eviction from Linux page cache

-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] special aggregate feature vs query optimization

___ 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

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 want to corrupt the database, https

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, deadlocks, whatever? Read this page: http

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

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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

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 parent, open close backups etc

[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] 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] (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] 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 Meltonhttp://lcs.ios.ac.cn/~xuzb/melton.html 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] 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 Meltonhttp://lcs.ios.ac.cn/~xuzb/melton.html to find memory leaks in sqlite-3.7.11. Two bugs were found, and I

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 t...@preservedwords.com 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 didn't

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 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] 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] How about a proper forum rather than an e-mail list

At 14:04 18/10/2011, Igor Tandetnik wrote: Frank Missel i...@missel.sg 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 this

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] 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 col4max

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 buttons. Using

Re: [sqlite] LevelDB benchmark

At 02:53 29/07/2011, Richard Hipp wrote: On Thu, Jul 28, 2011 at 12:27 AM, res...@googlemail.com 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 comparing

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 don't

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 solely

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 of

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 it and

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 embedded

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 permited to

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 stack

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

  1   2   >