Re: [sqlite] Table was deleted on macOS

ps.com > ** mail t...@qvgps.com<mailto:t...@qvgps.com> > ** +264 (0)81 3329923Nam mobile > ** +49 (0)175 7313081 D mobile > ** +49 (0)6182 8492599 D office > ***/ > > _______ &g

Re: [sqlite] Row locking sqlite3

sts.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a way to select using cid?

t? To write obfuscated code, perhaps for a prize or trojan, etc... development > Eric > -- > ms fnd in a lbry > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ---

Re: [sqlite] Performance of writing blobs

is, you blob reads don't pollute sqlite cache, - Compress the blobs with misc/compress extension while writing, less you write, faster you read, see sqlar project (http://sqlite.org/sqlar). HTH --- --- Eduardo Morras ___ sqlite-users mailing l

[sqlite] Request to add define SQLITE_PREPARE_NONE

Hello Dr. Hipps There is a #define SQLITE_PREPARE_PERSISTENT x01 line in sqlite3 source code for sqlite3_prepare_v3() flags. Could you add SQLITE_PREPARE_NONE meaning no flag set? Thanks --- --- Eduardo Morras ___ sqlite-users mailing list

Re: [sqlite] About storage of large amounts of image data

no deletes) workload. Read speed is faster than XFS and UFS2. You need to tune Sqlite to big databases and blob direct read (check the page Dr. Hipps linked for compile options) > ?(Sent this about 2 wks ago, but it never posted to the list and no > moderator respon

Re: [sqlite] JDBC driver experience

iculty? to develop one from scratch is easy-medium. Pass the connection string, user and password, and all queries to vtab are redirected to the other dbms. I began with the csv file virtual table and went from there. Check SQL-MED standard and postgresql docs for syntax. --- --- Eduardo Mor

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

ting in this survey! > -- > D. Richard Hipp > d...@sqlite.org --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Speed issue of SELECT in my application

more details of > what he?s doing. > > Simon. P.S. I sent the mail from my current contractor mail, sorry for that. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http:/

Re: [sqlite] Most efficient way to detect on-disk change

rt AFTER INSERT ON table_name_to_watch_up BEGIN SELECT your_nigth_watcher(); END HTH > > Thank you for your insights, > > Wout. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http:/

Re: [sqlite] Any change to make this query better?

esult itself, LSOpenJobs. SELECT max(edate) from LSOpenJobs AS I WHERE I.ProjID = O.ProjID AND I.PSubClass = 'QuoteAppr' You can try a WITH with the main query and subselect from it to get those two values (max(edate) and min(edate)) HTH --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When is db size an issue?

ical disks without speed problems. Easy to backup, use fts on someones and can attach-deattach filesystems db. One advice, increase sqlite internal cache, don't use its default value. > > Jason --- --- Eduardo Morras <emorr...@yahoo.es> . ___

Re: [sqlite] performance issue on a read only database

__ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-user

Re: [sqlite] SQLite in memory

tp://www.sqlite.org/mmap.html it has disadvanteges too) > Thanks, > > Gabriele HTH --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Developing a SQLite3 DB remotely

r the network server code, repository has an example server http://www.sqlite.org/src/artifact/a2615049954cbb9c and timeline at http://www.sqlite.org/src/finfo?name=src/test_server.c --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.18.0 pre-release snapshot

Could a trigger be fired on optimize? This way we could add database/schema specific optimizations (Delete all rows in table tab where column value is NULL, for example) Thanks for the great work. > -- > D. Richard Hipp > d...@sqlite.org --- --- Eduardo Morras <emorr...@yahoo.es&

Re: [sqlite] Read-only access which does not block writers

s discouraged. > > How important is it to you that the reader always get a correct > answer? > -- > D. Richard Hipp > d...@sqlite.org --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Hung query question

a in CLI. Set it to 100-500MB for foo db, don't need to waste cache on destiny db (where you insert the data). Change foo with the real origin db name. pragma foo.cache_size=-50 Why don't use R*Tree virtual table? http://www.sqlite.org/rtree.html --- --- Eduardo Morras <emorr...@yaho

Re: [sqlite] Import 5000 xml files in a sqlite database file

answers. > > Best regards > > Bob > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.e

Re: [sqlite] Virtual table

ers. > See the attached snapshot. Sqlite maillist don't support attachment. > regards, > > Maria Azevedo > -- > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailm

Re: [sqlite] Convert mysql to sqlite

SQL to sqlite? > You can export as csv and import them in sqlite. > - > Scott Doctor > sc...@scottdoctor.com > ----- --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users

Re: [sqlite] Best way to "split" a large DB into two DBs

use case is read heavy, use wal. I use (and develop) a diy filesystem over sqlite and has a similar scenario with hundreds of GB of blobs on multiple databases. Those compile options, tricks and split metadata from data made a huge improvement. > Any advice would be appreciated. Than

Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does

,kvarhl2,kvarhl3,kvarhnl1,kvarhnl2,kvarhnl3,kWhnl1,kWhnl2, > kWhnl3,kVAh,kVAhl1,kVAhl2,kVAhl3, > PFsys,PFl1,PFl2,PFl3,Wdmd,vardmd,VAdmd > FROM hst_energy_d > WHERE enflag = 0 ORDER BY recdate DESC, rectime DESC LIMIT 1; You are querying with ORDER BY DESC, but in

Re: [sqlite] Problem with savepoints

4*1024) 173 #endif You can predefine it (define before include sqlite3.h) with the value in bytes you want, or set it to -1 to always store them in memory. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bad db feature request

er columns content in the row and update a hidden column with the value can do the trick at row level. It will make performance lower, undesired but expected effect. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlit

[sqlite] Using LSM and Memory Mapped files -- Question about LSM_CONFIG_MMAP

mory: database with sqlite4. Doesn't it feed your needs? If you look at the Sqlite4 timeline, you'll see develop is a bit frozen. You can try the lsm-vtab (http://www.sqlite.org/src/timeline?n=100=lsm-vtab) for sqlite3, you need fossil-scm to download it and compile, but I don't know if it works currently or not (last updated on Feb 2016) HTH --- --- Eduardo Morras

[sqlite] Fastest way to backup/copy database?

out indexes, select all data from tables and insert them in new db tables. You don't write the indexes and should be faster. If you need the indexes, you can create them later. > Thanks > > Rob --- --- Eduardo Morras

[sqlite] Is there something like PHPAdmin for SQLite

s at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] Broken database after experiments with fts.

__ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] Encrypt the SQL query

'll force the reverse engineer to learn this new query language. You can automate the conversion from actuals SQL queries to NewLang queries, even change the NewLang on each compile with different lemon parser code. And yes, it's too complex and the time invested (I think) is time lost. > Than

[sqlite] Why is a separate journal file needed ?

s unlikely, but a) is a real pita. > Simon. --- --- Eduardo Morras

[sqlite] query Benchmark

the string instead reversing it. You know your data structure and the queries, perhaps other data transforms may create better indexs > Selea s.r.l. > > > Michele Pradella R --- --- Eduardo Morras

[sqlite] whish list for 2016

ge you are programming, you can store the query result on a table(Lua), dictionary(Python, Erlang and others) or create a specifc struct for your query in C. You can use the deprecated get_table and free_table to get a similar recordset struct. HTH > Looping over a recordset twice is often useful. > > Sincerely > Christian --- --- Eduardo Morras

[sqlite] SQLite remote access over WAN

uld choose one or another. > Any sugestion or comment are wellcome. > > -- > Adolfo J. Mill?n --- --- Eduardo Morras

[sqlite] whish list for 2016

Kennedy and Joe Mistachkin for their exceptional work, and other colisters for their time and help. --- --- Eduardo Morras

[sqlite] Feature Request: Support for MMAP beyond 2GB

GB, it's a 64bit integer. Try to compile with -DSQLITE_MAX_MMAP_SIZE=21474836480 and use a copy or backup, not the original database. > Roger --- --- Eduardo Morras

[sqlite] Multiple connections to in-memory DB and virtual tables

e(fts_virtual_table) VALUES('rebuild');" to reindex the FTS virtual table. And I say I wrote it too fast because a virtual table don't need to have an internal index, depends on what is it for and its implementation. > -Urspr?ngliche Nachricht- > Von: Eduardo Morras [m

[sqlite] Multiple connections to in-memory DB and virtual tables

On Tue, 6 Oct 2015 15:39:08 +0100 Simon Slavin wrote: > There are also things Virtual Tables can't do. For instance you > cannot index a Virtual Table using SQL commands. Does "SELECT reindex_virtual_table() FROM virtual_table" count as SQL command only? --- --- Eduardo Morras

[sqlite] Detect if db is already opened by another process?

s opened, increasing each time you open it and decreasing each time you close it. > > Michael --- --- Eduardo Morras

[sqlite] Native sqlite4 on FreeBSD

On Fri, 11 Sep 2015 17:12:50 +0300 Valentin Davydov wrote: > On Thu, Sep 10, 2015 at 01:30:37PM +0200, Eduardo Morras wrote: > > > > Use gmake to compile. > > It didn't work either. Finally I've just installed some brand new > linux on a nearby virtual mac

[sqlite] Improving SQLite performance over a network

qlite3 as network db and it is, besides cache_size and page_size, the most important pragma for improve performance. >ThanksMike > ___ sqlite-users mailing > list sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] sql query

> > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] Native sqlite4 on FreeBSD

kefiles bundled with > sqlite sources don't work. Use gmake to compile. Note that there isn't a port, sqlite4 is in development state and not a final product. > Valentin Davydov. --- --- Eduardo Morras

[sqlite] Using collation instead a virtual table

On Wed, 9 Sep 2015 09:54:28 -0400 Igor Tandetnik wrote: > On 9/9/2015 6:54 AM, Eduardo Morras wrote: > > Yes, the comparison operators work correctly and the b-tree binary > > search should give correct answers, the only tweak is in xCompare, > > that returns 0 when lef

[sqlite] Using collation instead a virtual table

On Tue, 8 Sep 2015 15:42:28 -0400 Richard Hipp wrote: > On 9/8/15, Eduardo Morras wrote: > > > > > > Hello, > > > > I have a virtual table that implements query perceptual hashing data > > [1]. Now I'm thinking about converting the virtual table > &

[sqlite] Using collation instead a virtual table

Hello, I have a virtual table that implements query perceptual hashing data[1]. Now I'm thinking about converting the virtual table implementation in a collation on a normal sqlite3 table, but collation requieres that '=','<' and '>' be well defined by obeying the rules cited on

[sqlite] Performance problems on windows

nice addition for debugging purpouses. > Thank you for your assistance. > > -- > Gruesse, > Jakub > --- --- Eduardo Morras

[sqlite] SQlite database access over wireless network

who runs sqlite on local, queues the queries, execute them in order and return results to each user. It's a medium complex project and some corner cases should be consider. I'll try postgres instead. --- --- Eduardo Morras

[sqlite] Wierd Locking problem

___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] When sqlite3_close() returns SQL_BUSY

onnection. I believe the case where > SQLITE_BUSY is returned by sqlite_close() due to unfinalized prepared > statements should be mentioned there. Perhaps you forget to call sqlite3_finalize() on at least one query of your code. > Jeff --- --- Eduardo Morras

[sqlite] libtclsqlite3 assistance

sqlite3.c:162240:17: fatal error: tcl.h: No such file > or directory > #include "tcl.h" > ^ > compilation terminated. > > I have tcl.h here: > /usr/local/include/tcl8.6/generic/tcl.h > /usr/local/include/tcl8.6/tcl.h Add the include path to /usr/loc

[sqlite] pragma temp_store_directory is deprecated, what is the alternative?

temp files will fail and may corrupt db file. > - Howard --- --- Eduardo Morras

[sqlite] create temporary virtual table

left over virtual tables from before and > drop them. > > Any other ideas? Modify the code of your virtual table or ask sqlite3 developers if it's one of the virtual tables provided with sqlite3. > - Andy --- --- Eduardo Morras

[sqlite] Schema-less JSON SQLite DB?

unql.sqlite.org/index.html/wiki?name=UnQL http://www.dataversity.net/unql-a-standardized-query-language-for-nosql-databases/ http://www.couchbase.com/press-releases/unql-query-language > > Sergej --- --- Eduardo Morras

[sqlite] convert a PostgreSQL to sqlite

table in sqlite with data from a Postgresql server. --- --- Eduardo Morras

[sqlite] static sqlite database

ntenance should minimize the vacuum space between tables. HTH --- --- Eduardo Morras

[sqlite] User-defined types -- in Andl

need the formal grammar. Learn by example means learn white rules (the dos), I need to know the black rules too (the don'ts) to get full knowledge of the language. > Regards > David M Bennett FACS > > Andl - A New Database Language - andl.org --- --- Eduardo Morras

[sqlite] Replace an open database

odify the schema version. If you do so, readers must call sqlite3_reset() and sqlite3_prepare() again. --- --- Eduardo Morras

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

ual table index count for this limit? > Eric --- --- Eduardo Morras

[sqlite] Regarding SQLITE_PRIVATE

alled from other .c files. If you declare them as static, you can't call them from any other .c files. HTH --- --- Eduardo Morras

[sqlite] Please confirm what I THINK I know about blobs

ars between them are the comment. I thought you need it only for documentation purpouse and not automatic/dynamic programming. > Thanks, --- --- Eduardo Morras

[sqlite] Please confirm what I THINK I know about blobs

table' AND tbl_name='blob_table'; will return CREATE TABLE blob_table ( ModelNo TEXT, -- e.g. S0-239 SerialNo TEXT, -- e.g. 101 VSWR BLOB -- double, e.g. x'feab12c' ) (Note that ';' is deleted) I check it in Firefox Sqlite3 Manager extension. > Thanks, > -Bill --- --- Eduardo Morras

[sqlite] SQLite queries

problems you may encounter at "There are MANY things to be taken care of,.." paragraph. --- --- Eduardo Morras

[sqlite] Possible bug with locking/retying

app, is sqlite own code, don't need to reinvent the wheel. Please, pay attention to my first two words, "I think", it shows my opinion about the problem as is described, not a real solution to other problems. > Simon. --- --- Eduardo Morras

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

while doing it at backup/restore db file system cache has it. Try to do something like this: %cat /path/to/db.file > /dev/null > Thank you > > Jean-Marie > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] Fwd: Is there an ODBC driver for SQLite

SQLite. > > So, if there is such a driver I would be very interested in requesting > it and evaluate it. > > Also it would be nice to know whether this driver is OK to use legally > in the commercial app. > > Thank you for any info you can provide. --- --- Eduardo Morras

[sqlite] Segfault during FTS index creation from huge data

(Warning!! Unknow licence) > Thank you. HTH --- --- Eduardo Morras

[sqlite] Segfault during FTS index creation from huge data

te itself will never use anything near ** this amount. The only way to reach the limit is with sqlite3_malloc() */ > > Regards > Dominique --- --- Eduardo Morras

[sqlite] Segfault during FTS index creation from huge data

> > > > I never saw a segfault in my case, though I never tried anything on > any posix style system. It was strictly Windows. Don't know if it's asked yet, but do you use a 64bit Windows or a 32bit version? > -- > Scott Robison --- --- Eduardo Morras

[sqlite] Regarding testing

create the tests you need for your use case. --- --- Eduardo Morras

[sqlite] Destroy all evidence of a database

rmation in > them. You can reference count the number of files it creates and deletes. If it creates more files than it deletes, you have a problem. It doesn't involve big changes in sqlite vfs code and even may be implemented in sqlite3 core code as a debug feature. > > Simon. --- --- Eduardo Morras

[sqlite] json_* functions in sqlite

qlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] Destroy all evidence of a database

taken each 10-30 secs., you can go back in time and recover filesystem state from 2 days ago (up to 6 months IIRC) > I have read <https://www.sqlite.org/tempfiles.html>. > > Simon. --- --- Eduardo Morras

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

3 to 3.8.9) > > Thanks for your help, > > -- > Nicolas Boullis > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras

[sqlite] Query times vary between 0.2 s and 30 s for very similar queries - how to trick the optimizer?

hat in this case there is no winning for using a temporal table intstead an IN, it should be faster when the temp table has more columns used in the where clause or additional join restriction. --- --- Eduardo Morras

[sqlite] Sqlite3 tutorial and reference manuals?

g all advanced features (threading, fts, extensions, foreign keys, etc...). You need to create a vfs too. --- --- Eduardo Morras

[sqlite] Sqlite3 tutorial and reference manuals?

t; user actions needs to be "timely". > > I'll hold futher questions until after looking at the recommendations > my by you kind people. For zigbee devices I use contiki-os. I suggest you to use c only if your devices are low power. --- --- Eduardo Morras

[sqlite] Appropriate Uses For SQLite

it. There are others cms that can use sqlite as db, seredipity, Joomla, MediaWiki you can play and test with. > > Olivier --- --- Eduardo Morras

[sqlite] Behaviour when subquery behind comparison operator in where-clause returns empty result

FROM ordercallback > WHERE cb_uuid=@CBUUID > UNION ALL > SELECT NULL -- at least one result > LIMIT 1) -- at most one result Shouldn't add an ORDER BY cb_seq_num to get the lower one? ... WHERE cb_uuid=@CBUUID ORDER BY cb_seq_num ASC UNION ALL ... > > > Regards, > Clemens --- --- Eduardo Morras

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 resul

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

Re: [sqlite] Performance increase between 3.7 and 3.8

se 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% improve. --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-us

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

we should buy/use Oracle but I just am holding onto sqlite3 > assuming it would help me solve our problem. You can use PostgreSQL, using part of Oracle licence cost for better hardware and a dinner for the team. > Regards, > Navin > > ___________

Re: [sqlite] Advice needed for optimization options

made it larger but no faster. > > > many thanks, > adj > > ___ > 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] Error: database disk image is malformed

by 1, that's the difference. Both files has the same corruption. The mail list 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] VACUUM requires 6.7 times space ?

tabase to .sql file or pipe output to gzip or xz and use the compressed file for import again. Don't need full compression to minimize the io, -6 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] Counting rows

ich (again) should use a lot less pages, minimizing 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

R BY Year > > Why ORDER BY on INSERT? Does it work better? I would 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 aft

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

ter, f.ex. batch writes sended by some 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> __

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

recives the data to write and the data queries. --- --- 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] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

ingle thread, compile it without thread support. b)Adjust the page size to fit in a hard disk cluster size (8KB IIRC) or the multiply of it that allows integer number of rows fits in. c)Disable autovacuum > 2) Will ther be any write performance hit when the number of records > in the DB increase?

Re: [sqlite] Locking errors on network

hard and for tiny hardware, near embedded, works. A good file to start with, as I did, 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 preferenc

Re: [sqlite] Search query alternatives.

HTH > > -- > Regards, > Michael.j.Falconer. > ___ > 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] 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, pe

Re: [sqlite] Window functions?

‘group by’ behavior > as exhibited by SQLite as a precursor to a proper, more formalize, > 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

it's current or not, and run analyze or make schema changes or whatever you want and update user_version. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/lis

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

erent field in the referenced enrolment record. > > Suggestions? Check http://www.sqlite.org/src/artifact/636024302cde41b2bf0c542f81c40c624cfb7012 for parent-child relationship example, it's for in-table relation but the in-code documentation is

Re: [sqlite] Building for vxWorks

LITE_OMIT* with the amalgamation sqlite3.c 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

you say connections, do you mean 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] Problem with many connections

OS exhausted del max. file descriptor per process. > > Regards, > Greg --- --- Eduardo Morras <emorr...@yahoo.es> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   3   >