sample database below and running this query:
select count(*) from stuff
where b=1 or b=5 or c=2 or d=4 or b=9;
will yield these timings:
sqlite 3.5.4 unpatched: CPU Time: user 3.560223 sys 0.156010
3.5.4 + 20071221 patch: CPU Time: user 1.252079 sys 0.072004
3.5.4 + 20071222 patch: CPU Time
Hello Community Sqlite
We Gerardo Antonio Cabero and Daniel Maldonado, administrators Sqlite
http://sqlite-latino.blogspot.com/ Latin America --
Sqlite Latin America?
A site for the communities of Sqlite Hablahispana, which are available
examples, documentation
We are the Latino community sqlite
.
Thanks excellent thought - so simple and I did not think about it. What
a shame.
THANKS once again and
'MERRY X-MASS'
W.Braun
Igor Tandetnik wrote:
Mag. Wilhelm Braun
<[EMAIL PROTECTED]> wrote:
I would be interesting about your point of keeping the precision in
floating point values w
Mag. Wilhelm Braun
<[EMAIL PROTECTED]> wrote:
I would be interesting about your point of keeping the precision in
floating point values without storing it as strings.
Usually, when you want to do this, it's because you are working with
monetary values. In this case, it is better to store them
Thanks Igor
that makes sense about integers.
I would be interesting about your point of keeping the precision in
floating point values without storing it as strings.
would be a great help as I have a few cases like that.
Thanks so much for your kind help
W.Braun
Igor Tandetnik wrote:
Mag
Mag. Wilhelm Braun
<[EMAIL PROTECTED]> wrote:
because of accuracy I use everywhere text entries even for numerical
entries.
You seem to be storing integer values as text. What kind of accuracy
improvement do you expect from this? Integers are stored losslessly
already.
I could remotely unde
hello,
because of accuracy I use everywhere text entries even for numerical
entries.
So if I have to select max or min items I use cast: e.g
I have exactly: 2310556 rows in the table
1. all CAST
select * from "SOME_table" where cast(UTCTimestamp AS INTEGER) = (select
max(cast(UTCTimestamp
Joe Wilson <[EMAIL PROTECTED]> wrote:
> The attached patch implements the WHERE clause "OR to UNION"
> optimization as described in this post:
>
I just went thumbing through the firesafe and I do not think
I have a copyright release on file for you, Joe. Please go
print out a copy of one of
"Shawn Wilsher" <[EMAIL PROTECTED]> wrote:
> I believe that I can get e-mail
> notifications of changes to tickets, which is a heck of a lot better
> than bookmarking a ticket and checking back every few days.
>
CVSTrac (http://www.cvstrac.org/) does not support email notification
of ticket chagn
9 matches
Mail list logo