On 4 Jan 2020, at 5:49pm, Doug wrote:
> for (i=1000; i--; i>0);
If you have optimization turned on, your compiler might turn that into "i = 0".
Optimization messes with a lot of benchmarks. Checking which optimization
setting was used is one aspect of what Howard Chu was talking about: bench
haha, that is a mangled way of saying I wrapped my db functions in a dll
for multiple app use. I did not expose this config setting as I never knew
its impact. To be honest, I still don't. ;)
On Fri, Jan 3, 2020 at 5:18 PM Tim Streater wrote:
> On 03 Jan 2020, at 22:08, sky5walk wrote:
>
> > Qu
On 03 Jan 2020, at 22:08, sky5walk wrote:
> Querying the config state is helpful for a dll wrapped database, ...
What's one of them?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org
>
>2. questions (am...@juno.com)
> From: "am...@juno.com"
> To: sqlite-users@mailinglists.sqlite.org, am...@juno.com
> Cc:
> Bcc:
> Date: Sat, 18 Aug 2018 16:24:45 GMT
> Subject: [sqlite] questions
> August 18, 2018 Good Morning Good People: I am in the
l Message --
From: Roger Schlueter
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] questions
Date: Sat, 18 Aug 2018 09:42:38 -0700
Hi Alex,
This functionality is certainly something that SQLite or even any
moderately capable database system can solve. However, for these
specific requirements
s.sqlite.org
Subject: Re: [sqlite] questions
Date: Sat, 18 Aug 2018 09:42:38 -0700
Hi Alex,
This functionality is certainly something that SQLite or even any
moderately capable database system can solve. However, for these
specific requirements there is very likely no off-the-shelf, ready-to-go
Hi Alex,
This functionality is certainly something that SQLite or even any
moderately capable database system can solve. However, for these
specific requirements there is very likely no off-the-shelf, ready-to-go
solution unless the requirement is very common or regulatory-required in
your i
August 18, 2018 Good Morning Good People: I am in the process of building a
database for where I work. I can do a lot of tasks with SQLite. But I am stuck
on the dilemmas below. If any of you have any programming solutions for any/all
of these dilemmas I am in--in a way that I can download what
> On Sep 19, 2017, at 6:16 AM, Russell Duncan wrote:
>
> I've just started researching programs for coding/app-making and SQLite
> came up, is this a program that would be useful for something like that?
Yes, although SQLite is rather low-level, and learning to use it directly is
already a si
Hello,
I'm completely new to everything SQLite, and app-coding in general.
I'm trying to make a service based app similar to Venmo (not for payments,
but similar in layout and size, with the idea of having the social feed
incorporated).
I've just started researching programs for coding/app-makin
I get confusing (to me) results when toying with a query that I think
should use a partial index as a "covering index". This is using sqlite
3.20.1 on Arch Linux x86_64.
The examples listed below start from a new, empty database.
*** Given a table and an index like this
CREATE TABLE tab (x1 TEXT
Jens Alfke writes:
>> On Jun 17, 2017, at 7:02 AM, Yuriy M. Kaminskiy wrote:
>>
>> *) don't appear to be able to keep key in system-provided secure
>> device/enclave;
>
> In their defense, I think this is out-of-scope for a cross-platform db
> encryption library, as there are so many different
> On Jun 17, 2017, at 7:02 AM, Yuriy M. Kaminskiy wrote:
>
> *) don't appear to be able to keep key in system-provided secure
> device/enclave;
In their defense, I think this is out-of-scope for a cross-platform db
encryption library, as there are so many different APIs for this on different
Jens Alfke writes:
>> And any non-opensource crypto should be taken with triple caution. Or
>> even opensource, but not widely-used or otherwise not known to be
>> carefully peer-reviewed (FWIW, I looked at e.g. wxsqlite crypto code, it
>> looks not exactly promising too).
>
> What do you think of
On 9 June 2017 at 22:30, Yuriy M. Kaminskiy wrote:
>
> Don't know about windows, but on linux no additional "debug privileges"
> needed. You can attach debugger (ptrace syscall) to any process running
> with under same user. Additional privileges needed only for debugging
> processes running under
On 2017-06-09 00:13, Wout Mertens wrote:
> Isn't it all just obfuscation? Any root user can read your key, if not from
> disk then from memory. Any normal user can't read your key, nor from disk,
> nor from memory; and they can't read your db file either.
>
> So if the adversary is someone with ac
> On Jun 9, 2017, at 7:30 AM, Yuriy M. Kaminskiy wrote:
>
> On other hand, application-level encryption should be used with great
> caution; it is a way too often designed and implemented by
> non-cryptographers, does not use optimized or hardware-assisted crypto
> primitives (and, for AES, ofte
> On Jun 8, 2017, at 3:13 PM, Wout Mertens wrote:
>
> Isn't it all just obfuscation? Any root user can read your key, if not from
> disk then from memory.
Keys on disk are [or should be!] generally stored by special OS subsystems
(like the Keychain on Apple platforms) that use encrypted storag
Eric Grange writes:
>> Isn't it all just obfuscation?
>
> Not really, the encryption protects the file, wherever it is, as long as
> the attacker does not have access to the application keys or application
> memory.
>
>> If the adversary is another process on the same host, encrypting the db
>> j
Aha, that does make sense, thinking of each risk in terms in
likelihoods. So encrypting the db as well as the disk seems the safest
route here.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailm
> Isn't it all just obfuscation?
Not really, the encryption protects the file, wherever it is, as long as
the attacker does not have access to the application keys or application
memory.
> If the adversary is another process on the same host, encrypting the db
> just adds obfuscation, which is se
On 8 Jun 2017, at 11:13pm, Wout Mertens wrote:
> So if the adversary is someone with access to your disk image, disk
> encryption trumps db encryption (unless the disk encryption is vulnerable
> to known-plaintext attacks, but I guess they probably apply to sqlite too).
Your hope is that the d
Isn't it all just obfuscation? Any root user can read your key, if not from
disk then from memory. Any normal user can't read your key, nor from disk,
nor from memory; and they can't read your db file either.
So if the adversary is someone with access to your disk image, disk
encryption trumps db
On 6/8/17, Wout Mertens wrote:
> Just musing: is an encrypted disk not more reliable? You have to store the
> key somewhere…
Maybe. I guess it depends on your threat model.
Encrypting the whole disk is a system setting,. Anybody who has
access to the system can see everything on disk. You als
Just musing: is an encrypted disk not more reliable? You have to store the
key somewhere…
On Thu, Jun 8, 2017, 7:07 PM Richard Hipp wrote:
> On 6/8/17, Karl Sanders wrote:
> > I would like to know if an encrypted database allows hot backups and
> > page sizes different from the default one.
>
>
On 6/8/17, Karl Sanders wrote:
> I would like to know if an encrypted database allows hot backups and
> page sizes different from the default one.
Yes and Yes.
>
> Is encryption applied to everything that gets written to disk?
> Including transient indices and materializations of views and subqu
I would like to know if an encrypted database allows hot backups and
page sizes different from the default one.
Is encryption applied to everything that gets written to disk?
Including transient indices and materializations of views and subqueries?
Regards,
Karl
__
gt; From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Jens Alfke
> Sent: Wednesday, March 29, 2017 1:14 PM
> To: SQLite mailing list
> Subject: [sqlite] Questions on big blobs and blob I/O
>
> I’m thinking of transitioning from external to int
On 3/29/17, David Raymond wrote:
> Remember to make the blob field the very last field in your table schema,
> and avoid "select * from", otherwise you can create performance problems.
> The data for a record is stored in the same order as the fields are defined,
> and overflow pages are a linked
7 1:14 PM
To: SQLite mailing list
Subject: [sqlite] Questions on big blobs and blob I/O
I’m thinking of transitioning from external to internal storage of large blobs.
That is, currently I store these as individual files in a directory next to the
SQLite database. But it sounds like today’s new impro
On 03/30/2017 12:52 AM, Olivier Mascia wrote:
Le 29 mars 2017 à 19:40, Simon Slavin a écrit :
Since I’m using WAL, will this db handle keep a snapshot of the time before the
blob’s row was deleted, allowing the blob handle to keep working?
As Simon said wisely, a word of the developers would
> Le 29 mars 2017 à 19:40, Simon Slavin a écrit :
>
>> Since I’m using WAL, will this db handle keep a snapshot of the time before
>> the blob’s row was deleted, allowing the blob handle to keep working?
As Simon said wisely, a word of the developers would clarify this better.
Yet, since you'r
On 29 Mar 2017, at 6:14pm, Jens Alfke wrote:
> * Do big blobs cause any performance problems for the db as a whole, like
> fragmentation? In particular, is the blob data stored contiguously in the
> file?
Blobs are stored in the same pages that other values are stored in. If a blob
is bigge
I’m thinking of transitioning from external to internal storage of large blobs.
That is, currently I store these as individual files in a directory next to the
SQLite database. But it sounds like today’s new improved SQLite is better at
managing big blobs, and supports streaming reads; and it wo
Hi
1) Question about SQLITE_CONFIG_SCRATCH
In SQLite documentation about SQLITE_CONFIG_SCRATCH,
I read:
=== BEGIN QUOTE https://sqlite.org/c3ref/c_config_getmalloc.html ===
SQLite will never require a scratch buffer that is more
than 6 times the database page size. If SQLite needs needs
On 2014/07/12 14:26, - wrote:
Hello Ryan,
Thanks for your response. I was writing a lengthy reply when I realized
that most of what I said in it where repetitions of what I have already said
earlier, so I deleted it.
To be honest, its well possible that I currently just can't wrap my head
ab
QLite seems to work (its not really what I'm
accustomed to) ...
Regards,
Rudy Wieser
- Original Message -
From: RSmith
To: General Discussion of SQLite Database
Sent: Friday, July 11, 2014 2:24 AM
Subject: Re: [sqlite] Questions from a novice - basic browsing of records
in
What if the table has 10^16 or more items?
Is that number within the limits as set by SQLite3 ? Than its my intention
to handle it.
No, I just made that up out of thin air. SQLite's maximum row limit is 2^63-1 I
believe. It is unreachable on current physical media.
Oh, there are some the
- wrote:
>> Are you using a list view, or paging? The scrolling
>> cursor method is appropriate only for the latter.
>
> I'm using a report-style listview. And to be honest, I have no idea what a
> "paging" component looks like (I'm using standard windows components).
This would be a list withou
g to do it "the right way". ... Which than brought
me in collision with vague limits.
> I hope this helps to alleviate your headaches slightly.
Not really, but I'm going to try to digest it.
Thanks for your help.
> Have a great day!
And the same to you.
Regards,
Rudy
Quick typo/fact check:
...// What if the table has 10^16 or more items? (This is more than the amount
of stars in the known universe//...
should of course read:
...// What if the table has 10^24 or more items? (This is more than the amount
of stars in the observable universe//...
_
On 2014/07/10 16:04, - wrote:
You could set a very big maximum (e.g. 5000 rows) on
the assumption that users will never actually read or scroll
through that many rows.
:-) In that case I would simply use a simple listview (a listview can
handle upto 32000 records), and see if I can use its laz
: General Discussion of SQLite Database
Sent: Thursday, July 10, 2014 2:17 PM
Subject: Re: [sqlite] Questions from a novice - basic browsing of records
ina listview.
>
> On 10 Jul 2014, at 12:54pm, - wrote:
>
> > But it might cause another problem: the database could get/be so la
eep track of
> (possibly large ammounts of) data, only so I can send it back (a standard
> listview only accepts upto, IIRC, 260 chars and discards the rest).
>
> What I was thinking about was something in the line of "continue/start from
> rowID {ID}".
>
> Rega
quot;continue/start from
rowID {ID}".
Regards,
Rudy Wieser
- Original Message -
From: Clemens Ladisch
To:
Sent: Wednesday, July 09, 2014 4:15 PM
Subject: Re: [sqlite] Questions from a novice - basic browsing of records
ina listview.
> - wrote:
> > After having used the O
OP is in windows. Windows can send you display cache hints that tells
you what page it intends to display next. I use these notification to
load up a page worth of data at a time. Keep it in an internal cache.
>> the ammount of memory needed to store all the rowIDs in could well exeede
>> the ammo
On 10 Jul 2014, at 12:54pm, - wrote:
> But it might cause another problem: the database could get/be so large that
> the ammount of memory needed to store all the rowIDs in could well exeede
> the ammount of memory available to the program.
> I could ofcourse use (or at that moment switch over
f SQLite Database
Sent: Wednesday, July 09, 2014 3:11 PM
Subject: Re: [sqlite] Questions from a novice - basic browsing of records
ina listview.
> How about using prepared statements in conjunction with bind?
>
> http://www.sqlite.org/c3ref/bind_blob.html
>
> Kind regards,
>
> Phi
-
From: Simon Slavin
To: General Discussion of SQLite Database
Sent: Wednesday, July 09, 2014 4:07 PM
Subject: Re: [sqlite] Questions from a novice - basic browsing of records
ina listview.
>
> On 9 Jul 2014, at 2:03pm, - wrote:
>
> > 1) Is it possible to refer to the columns in a
- wrote:
> After having used the OFFSET and LIMIT 1 method (in conjuction with a
> userdata listview) and finding a past post into this forum describing it as
> a rookie mistake I'm now trying to implement the "scrolling cursor" method
> in that same post.
Are you using a list view, or paging? Th
On 9 Jul 2014, at 2:03pm, - wrote:
> 1) Is it possible to refer to the columns in a kind of shorthand (index
> perhaps) ?
>
> 2) Is it possible to have the SQLite engine initialize and remember certain
> WHERE and ORDER clauses (without creating another database please :-) ), so
> they can be u
How about using prepared statements in conjunction with bind?
http://www.sqlite.org/c3ref/bind_blob.html
Kind regards,
Philip Bennefall
On 2014-07-09 15:03, - wrote:
Hello all,
I'm quite new at SQLite3, and have a bit of a problem with grasping the
handling of a database.
After having used
Hello all,
I'm quite new at SQLite3, and have a bit of a problem with grasping the
handling of a database.
After having used the OFFSET and LIMIT 1 method (in conjuction with a
userdata listview) and finding a past post into this forum describing it as
a rookie mistake I'm now trying to implemen
Hi, no you have to compile your vfs with sqlite3 amalgamation and its shell
in order to use it.
After compiling and linking, you will be able to run your vfs. Remember to
register your vfs in order to have it available.
Hope this helps,
Regards,
Luca
Il 28/mag/2014 14:41 "김병준" ha scritto:
> The
The documentation seems to state that in order to use test_onefile, instead of
providing an option when compiling sqlite3, test_onefile must be set as vfs
with the -vfs command option in the shell. Is my understanding correct?
The documentation does not provide examples using vfs demo files su
On Thu, 21 Nov 2013 07:29:49 -0600
John McKown wrote:
> To get more to your question, what I would do is have another,
> boolean, column in my table. I would call it something like
> "being_edited". When a user wants to edit a car, I would start a
> transaction (BEGIN TRANSACTION). I would then S
On 06/26/2013 02:08 PM, Woody Wu wrote:
On Tue, Jun 25, 2013 at 10:21:51PM -0400, Igor Tandetnik wrote:
On 6/25/2013 10:13 PM, Woody Wu wrote:
1. When a exclusive transation started and not yet commit, I found if I
open another connection to the same database and try to access it (using
sqlite3
On 26 Jun 2013, at 8:08am, Woody Wu wrote:
> Thanks for the analyzing. After checked, I found it's the prepare_v2
> statement, previous to the step statement, returned SQLITE_BUSY. That
> means, a prepare_v2 can even failure if the statement be preparing is an
> operation to an exclusive locke
On Tue, Jun 25, 2013 at 10:21:51PM -0400, Igor Tandetnik wrote:
> On 6/25/2013 10:13 PM, Woody Wu wrote:
> >1. When a exclusive transation started and not yet commit, I found if I
> >open another connection to the same database and try to access it (using
> >sqlite3_step), I got the error code SQLI
On 6/25/2013 10:13 PM, Woody Wu wrote:
1. When a exclusive transation started and not yet commit, I found if I
open another connection to the same database and try to access it (using
sqlite3_step), I got the error code SQLITE_MISUSE. It sounds a little
strange because I thought the error code s
Hi,
I have serveral questions about exclusive transaction. (version 3.7.x)
1. When a exclusive transation started and not yet commit, I found if I
open another connection to the same database and try to access it (using
sqlite3_step), I got the error code SQLITE_MISUSE. It sounds a little
strang
On Thu, Apr 18, 2013 at 12:51 PM, Aimard Janvier wrote:
>
>
> Hello,
>
> I would like to know how to access more than 200 entries (previous months
> or years) on your Timeline.
>
Look on the URL and find the place where is says "n=200". Change the 200
to whatever number you want.
--
D. Richar
Hello,
I would like to know how to access more than 200 entries (previous months or
years) on your Timeline.
Thanks
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 30/04/12 14:52, Sean Cui wrote:
> 1. The main purpose of Shared Cache Mode is to enable multiple
> connections to a database file WITHIN a process.
No, it is to save some memory. You can already open up multiple
connections to the same or dif
Hello, this is my first question in the Sqlite mailing list:
I am currently investigating concurrency in SQLite. I found two related topics:
WAL and Shared Cache Mode. Below is a list of my understandings regarding them:
1. The main purpose of Shared Cache Mode is to enable multiple connecti
Igor Tandetnik wrote:
On 3/21/2012 9:33 PM, Yan Seiner wrote:
I need to write some C code to interface with sqlite API. I"ve been
through the docs, and I'm hoping someone can point me to some very basic
example code that I could build on.
http://www.sqlite.org/quickstart.html
Thanks! Perfec
On 3/21/2012 9:33 PM, Yan Seiner wrote:
I need to write some C code to interface with sqlite API. I"ve been
through the docs, and I'm hoping someone can point me to some very basic
example code that I could build on.
http://www.sqlite.org/quickstart.html
--
Igor Tandetnik
_
I just started playing around with sqlite3 in earnest. I have a fairly
large database (several hundred thousand records) on an embedded box and
sqlite does an incredible job of finding what i need very fast.
My database is as simple as it gets:
CREATE VIRTUAL TABLE latlong USING rtree( id, la
> 1. Does BLOB type field cause any performance issues compared to using TEXT>
> when doing inserts/updates. In other words, if they use the same number of>
> bytes, would there be any difference in performance?
I believe it's a little weird choice as TEXT fields have some
additional features tha
We are trying to determine how BLOB type and page size impact performance.
I have a few questions related to that:
1. Does BLOB type field cause any performance issues compared to using TEXT
when doing inserts/updates. In other words, if they use the same number of
bytes, would there be any differ
On 12 Feb 2011, at 1:25pm, Gabriele Favrin wrote:
> First of all a BIG thanks to the dev team of SQLite, it's an amazing
> library, it helped me to enter in the world of SQL and I'm using it from
> PHP on some small-medium sites. Thanks also to who takes time to explain
> thing to people who a
Gabriele Favrin wrote:
> The board is moderated, so any new message should be approved from admin.
> I use the columns pub to determine messages that can be shown and new to
> determine new messages (which by default have pub set to 0). This is
> because changing a message from new=1 to new=0 gets
Hi all, I'm new on this list.
First of all a BIG thanks to the dev team of SQLite, it's an amazing
library, it helped me to enter in the world of SQL and I'm using it from
PHP on some small-medium sites. Thanks also to who takes time to explain
thing to people who aren't really expert on db (lik
> > %type course_plot { std::vector* }
> >
> > course_plot(V) ::= COURSE_PLOT_BEG course_plot_sector(A) .
> > {
> >
> The issue is more what V is when the vector isn't created.
>
>
> Igmar
lemon is not going to initialize anything for you. You need to design
your parser such that you c
> %type course_plot { std::vector* }
>
> course_plot(V) ::= COURSE_PLOT_BEG course_plot_sector(A) .
> {
>
The issue is more what V is when the vector isn't created.
Igmar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlit
vision
assuredcommunications(tm)
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Igmar Palsenberg
> Sent: Monday, February 22, 2010 7:39 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Questions regarding Lemon
Hi,
After a decode or so I've begun to program in C again. I've writing a
parser, and Lemon seems like the right tool for the job. SQLite itself
is an excellent read when starting with lemon.
However, a few questions remain unanswered :
- How do variables get initialized ? For example :
%type
Well, I would like to thank you for the responses!! Thank you so much!
In terms of app development, well, I've heard things like that before, but
in this case the app is developed in java me, and I was just wondering if
there is any API that makes it possible to stablish a conversation between
sql
On 19 Jan 2010, at 2:33am, Bill King wrote:
> Things are getting better, qt and qtcreator for s60's making things
> noticeably easier, and there's a QtSql wrapper for the sqlite server
> engine access in the works, or native sqlite is included in qt/s60 by
> default.
That's all good news. I tri
On 01/19/2010 12:11 PM, ext Simon Slavin wrote:
> On 19 Jan 2010, at 2:02am, Pedro Brigatto wrote:
>
>
>> I would like to know if there is any way to use SQLite on Nokia N97 (I've
>> been surfing on the web but got no answers to any of my questions regarding
>> it yet).
>> If the answer is *yes*
On 19 Jan 2010, at 2:02am, Pedro Brigatto wrote:
> I would like to know if there is any way to use SQLite on Nokia N97 (I've
> been surfing on the web but got no answers to any of my questions regarding
> it yet).
> If the answer is *yes*, how could I get more info to get started on
> developing
Hi, all!
This is my first post on this list. Thank you in advance for your time on
reading it.
I would like to know if there is any way to use SQLite on Nokia N97 (I've
been surfing on the web but got no answers to any of my questions regarding
it yet).
If the answer is *yes*, how could I get more
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jean-Christophe Deschamps wrote:
>
>> You are trying really hard to overthink things :-)
>
> I simply found version c-1) in a widely spread extension and was
> surprised by this way of doing the return, unduly complicated and
> inefficient in my po
>You are trying really hard to overthink things :-)
I simply found version c-1) in a widely spread extension and was
surprised by this way of doing the return, unduly complicated and
inefficient in my poor understanding, hence the question.
___
sq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jean-Christophe Deschamps wrote:
> a) is it allowable for a scalar function to modify (in place) an input
> argument
No.
> b) same question for unmodified arguments: is it possible to avoid
> duplication
> of an argument if the function determi
Hi,
The following details about text/blobs returns from scalar functions
are unclear to me and I prefer doing things right.
a) is it allowable for a scalar function to modify (in place) an input
argument
and return a pointer to modified argument with
sqlite3_result_text? If yes,
what
On Jun 18, 2009, at 9:50 PM, Shaun Seckman (Firaxis) wrote:
> Hello everyone,
>
>I'm in the process of writing some C++ wrappers to
> SQLite in order to shoehorn it into some legacy code. I'm curious if
> there is any performance impact to having several prepared statements
> act
Shaun Seckman (Firaxis) wrote:
> Hello everyone,
>
> I'm in the process of writing some C++ wrappers to
> SQLite in order to shoehorn it into some legacy code. I'm curious if
> there is any performance impact to having several prepared statements
> active at any given time.
That
Hello everyone,
I'm in the process of writing some C++ wrappers to
SQLite in order to shoehorn it into some legacy code. I'm curious if
there is any performance impact to having several prepared statements
active at any given time. I was thinking about using a prepared
statement
On Oct 20, 2008, at 2:57 AM, Clodo wrote:
> Thanks for you answer MikeW.
>> Could you put the update records into their own separate table
> I already solved my problem using the newest "INDEXED BY".
> I'm trying to understand if is a SqLite limit or bug.
It's an unfortunate edge case alright. S
> Hi Clodo,
>
> I believe Sqlite uses B-trees, unless one links in the R-tree module or
> uses the FTS feature (Full Text Search).
>
>
I don't know almost nothing about the internal implementation of a
database engine, i need to study to understand your reply :)
> I believe you wrote earlier t
Hi Clodo,
I believe Sqlite uses B-trees, unless one links in the R-tree module or
uses the FTS feature (Full Text Search).
I believe you wrote earlier that the new "INDEXED BY" feature solved
your problem, but you saw something in the documentation that dissuaded
you. Do you mind saying just wha
Thanks for you answer MikeW.
>Could you put the update records into their own separate table
I already solved my problem using the newest "INDEXED BY".
I'm trying to understand if is a SqLite limit or bug.
And i'm trying to understand your answer about the hashes :(
For the moment, here you can f
Fabrizio Carimati <[EMAIL PROTECTED]> writes:
>
> Hi to all,
> I have a table with many record, that have a field normally with value '0'.
> Occasionally i update some records by setting the field to '1' to mark
> it, and after in a background job, i localized them for working on it.
> For that
Thanks for feedback.
"The right data"::: we don't have any wrong data
Imagine to have a table with millions of records, for example records
about website, with a field="needtoupdate=false" normally.
A background job that mark few records at time by setting
"needtoupdate=true".
And another ba
Clodo wrote:
> Many thanks, it's a good news that resolve my problem.
>
> But still remain "a trick", i think the behaviour descripted in my
> original feedback is "strange".. i understand, if all fields have the
> same value, an index on that have a zero "height" in computing the best
> indexes
Many thanks, it's a good news that resolve my problem.
But still remain "a trick", i think the behaviour descripted in my
original feedback is "strange".. i understand, if all fields have the
same value, an index on that have a zero "height" in computing the best
indexes to use, but not use ind
Greetings, Clodo,
Regarding: "[is it]possible to force the use of the index?"
The very latest release of sqlite, 3.6.4, implements precisely that, in
the form of an "INDEXED BY" clause.
See:
http://www.sqlite.org/releaselog/3_6_4.html
Specifically:
http://www.sqlite.org/lang_indexedb
Hi to all,
I have a table with many record, that have a field normally with value '0'.
Occasionally i update some records by setting the field to '1' to mark
it, and after in a background job, i localized them for working on it.
For that, i have an index on that field.
My problem: if i run an "an
Hi to all,
I have a table with many record, that have a field normally with value '0'.
Occasionally i update some records by setting the field to '1' to mark
it, and after in a background job, i localized them for working on it.
For that, i have an index on that field.
My problem: if i run an "a
1 - 100 of 188 matches
Mail list logo
