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

On Sat, 22 Nov 2014 11:01:45 -0500 (EST) Joseph Fernandes josfe...@redhat.com wrote: Thanks Eduardo. Answers inline JOE a)If you use Sqlite in single thread, compile it without thread support. JOE We are running it in multithread mode, as the database will be JOE fed by multiple File

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] Free Page Data usage

El lun, 10/2/14, Simon Slavin slav...@bigfraud.org escribió: Asunto: Re: [sqlite] Free Page Data usage Para: General Discussion of SQLite Database sqlite-users@sqlite.org Fecha: lunes, 10 de febrero, 2014 12:34 On 10 Feb 2014, at 11:29am,

Re: [sqlite] Web application with SQLite

Understood. Thanks Sorry if I'm late. There's no difference between developing a formal application and a Web application from the Sqlite point of view. You can check mongoose webserver. It uses LUA for scripting web pages (similar to PHP but with LUA) and Sqlite for db access from LUA.

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

On Wed, 17 Jul 2013 12:04:52 +0200 Paolo Bolzoni paolo.bolzoni.br...@gmail.com wrote: On Tue, Jul 16, 2013 at 8:13 PM, Eduardo emorr...@yahoo.es wrote: Can you show us the query and/or schemas? If not: Sure, I appended everything in the bottom of this email. Unfortunately gmail will mess

Re: [sqlite] Memory usage of sqlite3

on the production server, maybe I should not worry at all? -- Eduardo 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

? --- --- 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 regression since 3.7.15

me know if you have any other questions! -elan -- Eduardo 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] Writing in a blob

, including locks, can easily be done with sqlite. -- Eduardo 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

On Mon, 7 Jan 2013 11:11:01 +0100 Pavlos Christoforou pav...@p9ft.com wrote: Hello Eduardo, We do (succesfully) use sqlite in a similar manner as you describe in your post but the code ensures the DB is opened in each individual child process *after* a child is successfully forked

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] Balance between keeping DBs open vs repeated open/close

At 18:11 06/04/2011, you wrote: Thanks Stephan and Simon - I kind of figured it was one of those how long is a ball of string questions, but I just wanted to check there weren't any particular gotchas to watch out for. Regarding the separate files, it seems the best way to go. Each individual

Re: [sqlite] slow select from table with data blob

On Sat, 29 Jan 2011 15:07:47 -0800 (PST) Rael Bauer rael_ba...@yahoo.com wrote: It seemed strange that a simple select * from table that I was doing was so slow. The table contained about 20 columns (fields) and 300 rows. The select took about 1.5 seconds. (using SQLite Expert). So my

Re: [sqlite] Slow deletion

On Fri, 11 Jun 2010 00:49:47 -0700 (PDT) durumdara durumd...@gmail.com wrote: Hi! I have an app that transform the input images to later somebody can . I increased the size of pages, but only a little changes I see. May this caused by index? Because this is a primary key, I cannot

Re: [sqlite] Slow deletion

On Fri, 11 Jun 2010 12:38:55 +0200 Eduardo emor...@xroff.net wrote: Opsss, hit send too early You can also index the blobtable by dirty colum for faster searches, don't know if index helps on deletes if you use the f1) way. You can use the dirty colum with integers if you need more than 2

Re: [sqlite] [BUG] Adding an index changes query result

2010-06-09 Tomash Brechko tomash.brec...@gmail.com: With SQLite 3.6.23.1 I see the following:  $ ./sqlite3 /tmp/a.sqlite  SQLite version 3.6.23.1  Enter .help for instructions  Enter SQL statements terminated with a ;  sqlite CREATE TABLE t (c1 INTEGER, c2 INTEGER);  sqlite INSERT INTO t

Re: [sqlite] Reduce database file size

On Sun, 11 Apr 2010 14:09:21 -0400 Nikolaus Rath nikol...@rath.org wrote: Using rsync is unfortunately not possible, I'm stuck with HTTP and FTP. I tried a few PPM compressors, but even though the compression ratio is amazing, I'm not desperate enough to invest *that* much CPU time yet.

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

  1   2   >