On Feb 9, 2012, at 4:17 PM, Marco Bambini wrote:
> sqlite 3.7.8 on MacOS X
>
> This query works fine:
> SELECT rowid, * FROM 'customer' WHERE rowid < 100;
>
> While this query does not return anything:
> SELECT rowid, * FROM 'customer' WHERE 'rowid' < 100;
>
> Do you have an explanation?
sqlite 3.7.8 on MacOS X
This query works fine:
SELECT rowid, * FROM 'customer' WHERE rowid < 100;
While this query does not return anything:
SELECT rowid, * FROM 'customer' WHERE 'rowid' < 100;
Do you have an explanation?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
Yes, you are right (as always).
Time with SQLITE_THREADSAFE=0 is about 4.33 seconds now.
Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Aug 28, 2009, at 5:23 PM, D. Richard Hipp wrote:
>
> On Aug 28, 2009, at 11:17 AM, Mike Eggleston wrote:
>
>>
On Aug 28, 2009, at 11:17 AM, Mike Eggleston wrote:
> On Fri, 28 Aug 2009, Marco Bambini might have said:
>>
>> Version 3.4.2 takes about 5.06 seconds (average value) while version
>> 3.6.17 takes about 7.28 seconds (average value).
>> Could be a slowdown in the library for the complexity added
Library is statically linked into the final app and the db is newly
created...
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Aug 28, 2009, at 5:17 PM, Mike Eggleston wrote:
> On Fri, 28 Aug 2009, Marco Bambini might have said:
>
>> Hello,
>>
>> today I made
On Fri, 28 Aug 2009, Marco Bambini might have said:
> Hello,
>
> today I made some test on a project I wrote some years ago.
> I upgraded sqlite library from version 3.4.2 to version 3.6.17.
> What I am really unable to understand is the time difference required
> to perform the same query
Hello,
today I made some test on a project I wrote some years ago.
I upgraded sqlite library from version 3.4.2 to version 3.6.17.
What I am really unable to understand is the time difference required
to perform the same query using the exact same algorithm by the two
libraries.
SELECT *
Hello,
A few days ago I posted a question and I haven't seen any comments so
far. I'm really curious about ROWID's volatility. How can I make sure
that ROWIDs do not get re-initialized? I'm posting the message once
again hoping that someone will explain how I should properly use
ROWIDs.
Hello,
Would this explanation about ROWID make sense?:
Referencing ROWID: If you make references to ROWID but then export
your database (using, for example, the ".dump" command of the sqlite
shell) and reimport it, all of your ROWIDs will change and your
references won't
be right any more.
9 matches
Mail list logo