Re: [sqlite] PATCH: WHERE clause OR to UNION optimization

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

[sqlite] Hello from Sqlite Latino America

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 .

Re: [sqlite] Re: Re: Any Ideas to speed up CAST

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

[sqlite] Re: Re: Any Ideas to speed up CAST

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

Re: [sqlite] Re: Any Ideas to speed up CAST

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

[sqlite] Re: Any Ideas to speed up CAST

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

[sqlite] Any Ideas to speed up CAST

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

Re: [sqlite] PATCH: WHERE clause OR to UNION optimization

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

Re: [sqlite] Trac Account

"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