Hey folks...
I have a situation that caused me a little head-scratching and I'm wondering
if it's intended behavior or not.
I'm running a server thread (roughly based on test_server.c in the distro)
on top of the 3.3.6 library. The effectve call sequence in question (all
from one thread) looks
On Sat, 2007-01-13 at 10:03 +0100, Marco Bambini wrote:
> I am sorry if the question is too obvious but I haven't found any
> documentation about the SQLITE_ENABLE_LOCKING_STYLE macro (it is in
> os.c).
> Should I set it to 0 (default) or 1?
> I need to be able to access database files located
First off, thanks for the help and sorry for the formatting of the
message. I didn't know how it was going to turn out and I probably was
overly optimistic as well as too verbose.
Secondly, as I feared, seems like it was an XY question, so sorry for that
as well.
I'll address the two replies
Great solution Igor!
On 13/01/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Lloyd Thomas
wrote:
> I wish to create a query where I do a number of counts on the same
> table but
> with different filters.
> ie:
> count(id) as numrows
> count(id) as inrows where direction = 'In'
> count(id) as ou
Lloyd Thomas
wrote:
I wish to create a query where I do a number of counts on the same
table but
with different filters.
ie:
count(id) as numrows
count(id) as inrows where direction = 'In'
count(id) as outrows where direction = 'Out'
Could I do the above in a single query?
select
count(
select count(id), "numrows" as type from table
union
select count(id), "inrows" as type from table where direction = 'In'
union
select count(id) as id, "outrows" as type from table where direction = 'Out'
This could be?
I am sorry that i can't try here, because i am not in my work or my home,
an
I wish to create a query where I do a number of counts on the same table but
with different filters.
ie:
count(id) as numrows
count(id) as inrows where direction = 'In'
count(id) as outrows where direction = 'Out'
Could I do the above in a single query?
| id | date | direction | dur
Have you considered running a process that summarizes the data from the table
and just fetching the last summary for display? Will a periodic snapshot work
for your reporting or do you need realtime summarization?
On 1/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all. I will try to p
Glad I could help find something, hope I put you in the right direction with
the source sample.
In the meantime I've moved to standard tables due to other limitations
imposed by FTS1/2.
Scott Hess wrote:
>
> OK, there's definite meat, here. I have other reports of users seeing
> this problem.
I am sorry if the question is too obvious but I haven't found any
documentation about the SQLITE_ENABLE_LOCKING_STYLE macro (it is in
os.c).
Should I set it to 0 (default) or 1?
I need to be able to access database files located on shared volumes
on OS X.
Which are the implications of setti
On Sat, Jan 13, 2007 at 12:57:43AM -0500, [EMAIL PROTECTED] wrote:
> The SQLite database
> is INSERTed into because I want to keep historical data. The rationale
> for this is explained later.
For your main application (finding the least load
11 matches
Mail list logo
