I have to challenge one of your statements. Adobe Camera Raw is not
nearly identical to Lightroom. ACR is Lightroom's editing engine.
When you are editing an image in Lightroom, you are using ACR. ACR
has no need for a database of any kind, unless the XMP file contains a
very tiny database.
On 3/31/2015 7:50 PM, Bart Smissaert wrote:
> Say I have a table with 3 fields. Depending on a value in field 1 (this
> value will be either 1 or 2)
> I want to do a different sort order sorting on fields 2 and 3.
> This will be either order by field2 desc, field3 desc or field3 desc,
> field2
And, only if you assign your own name to the column can you use it in foreign
key constraints ...
---
Theory is when you know everything but nothing works. Practice is when
everything works but no one knows why. Sometimes theory and practice are
combined: nothing works and no one knows
Mark Romero wrote:
>
> A few months ago one of the programs that I use (Lightroom) started to
> have long periods where it would stop responding. It wouldn't crash,
> but it would just keep my CPU pegged at 100% and the program would stop
> responding. This would happen at random times.
>
When
On 03/31/2015 05:17 PM, Mark Romero wrote:
> Hey Everyone:
>
> Was there a recent Windows 7 64-bit update that affected SQLite?
>
> A few months ago one of the programs that I use (Lightroom) started to have
> long periods where it would stop responding. It wouldn't crash, but it
> would just
I don't know what you mean by "technically impossible". What Bart asked for is
entirely possible, and commonly done. You very well can put an arbitrary
expression in an ORDER BY clause, including a CASE statement, so that it does
what is requested. Failing that, you can use an inner query in
Hey Everyone:
Was there a recent Windows 7 64-bit update that affected SQLite?
A few months ago one of the programs that I use (Lightroom) started to have
long periods where it would stop responding. It wouldn't crash, but it
would just keep my CPU pegged at 100% and the program would stop
Thank you Keith for your elaborate explanation about the inner workings of
cache and the options that are involved. I has made me realize again not to
draw conclusions too quickly when one is not in depth familiar with the
background of a problem.
Regards,
Rob
-Original Message-
Thanks everyone for the answers.
I won't be able to make some tests today, I will come back to you soon with
additional information. Just to say that, in the worst case, the WHERE
clause selects the entire data, i.e 100 entries. The user can select a
time range of 1 hour, 3 hours, 1 day, and
Hi,
I?m trying to access a SQLite database I?ve written using Excel. In the Windows
world we used to use ODBC drivers which were clunky, cumbersome, sometimes
worked, sometimes didn?t, had arcane issues and generally were a PITA.
So I?m trying to do the same on our development Macs and it
Hello,
we are developing an application Using SQLite3 on Windows embedded
compact 7 using C# 3.5.
We have had no problems with corrupted databases so far, even though I
always kill the running process in the debugger. The development
process is now 2 Years. Also, some months ago we had a lot
From what I see, I assume that timestamp gives the highest selectivity.
Taking into account that protocol is SELECTed for and portLan is GROUPed
BY, I'd try an index (timestamp, protocol, portLan) (not sure if portLan
helps here, but it's worth a try, I think). Don't forget to ANALYZE, of
12 matches
Mail list logo
