I know sum() is work. This issue occurs only for TEXT.
When I use a user-defined aggregate CONCAT()
it led to a stange result.
suppose the length of original text is 1
length of output text via GROUP+concat() is 5
while via ORDER, the length of final text is 1 (should be 5)
ps1. run on winxp, com
Have you raised indices on the keys you use in your queries?
varunkumar wrote:
i have 40 columns table in my database. now my database size is 23MB .
untill now my database has 78752 rows(records). when i am query database it
is taking 10 seconds of time . my database performance is degradi
Wakka <[EMAIL PROTECTED]> wrote:
> I get into trouble about using GROUP and ORDER.
>
> When I use GROUP and ORDER together, aggregate function
> can't work, could someone explain it?
Works OK when I try it. I don't have your custom concat()
function, so I had to use sum() instead. Here is my te
I get into trouble about using GROUP and ORDER.
When I use GROUP and ORDER together, aggregate function
can't work, could someone explain it?
### create two table
CREATE TABLE book (id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE);
INSERT INTO book VALUES (0);
INSERT INTO book VALUES (0);
INSERT INTO
i have 40 columns table in my database. now my database size is 23MB .
untill now my database has 78752 rows(records). when i am query database it
is taking 10 seconds of time . my database performance is degrading.
i want to improve my database performance what should i do to improve
perfor
Your trigger can record the change notification in a separate table.
So long as the system processing the change notifications cleans them
up as it goes, this can be reasonably efficient.
-scott
On 10/13/07, Vladimir Stokic <[EMAIL PROTECTED]> wrote:
>
> Spot on! I could monitor the change of th
Spot on! I could monitor the change of the file, but, like you said, that
does not tell me _what_ changed, so I would still have to poll the database.
And yes, I would be looking for a single row change in a database of 30+
tables with 75000+ rows each.
Trevor Talbot-2 wrote:
>
> A couple other
A couple other things come to mind here, that might be relevant to
what you're doing:
* A trigger that has a "final" side effect, like signaling another
process, will both have that effect early (before the transaction is
committed), and will have that effect even if the transaction is later
rolle
Thanks! Something like that has already crossed my mind, but I was just
wondering if there was a way to achieve that goal using the existing
interfaces. Now, it looks like this solution is the only one to my problem.
Vladimir Stokic
John Stanton-3 wrote:
>
> If you have access to the Sqlite l
Vladimir Stokic wrote:
I agree that the solution with the semaphore is a very elegant one, but that
still does not solve the problem of having to define the custom function to
be called from the trigger over and over again. On the other hand, if the
function is not going to be called from the tri
I agree that the solution with the semaphore is a very elegant one, but that
still does not solve the problem of having to define the custom function to
be called from the trigger over and over again. On the other hand, if the
function is not going to be called from the trigger, but from the app A
If you use a semaphore it is independent of the processes currently
running and has nothing to do with a Sqlite connection. Your custom
function is called, signals the semaphore and exits. When the semaphore
is signalled the process waiting on it is activated.
In your example myfunc performs
On 10/13/07, Vladimir Stokic <[EMAIL PROTECTED]> wrote:
> I tried to do what you and Igor said, but I found out that it does not really
> work that way. I can make a user-defined function, but it stays active only
> while the current connection is open. It is not persisted in the "database".
> Fr
I tried to do what you and Igor said, but I found out that it does not really
work that way. I can make a user-defined function, but it stays active only
while the current connection is open. It is not persisted in the "database".
It does not work even if I try it from the same application. Here i
You could achieve your result by defining a semaphore. A custom
function in A would signal the semaphore and activate a thread in B when
the DB changed. The thread in B would be waiting on the semaphore Both
Unix and Windows implement semaphores in a similar manner.
A slightly higher level
Hallo Odekirk Shawn,
SQLite use up to an 64Bit signed Integer for Primary Keys, even on non
64Bit-Systems!
Integer PrimaryKeys are always autoincrementing. When you don't specify it it
uses after (2^63)-1
a random free positiv value. When you write autoincrement for your create table
it never r
Thanks for the advice. I appreciate it. However, I am rather new at IPC, so I
would like to ask you for a bit more detailed explanation. Is there some
c/c++ library that would make sending and IPC package over to app B
possible?
I do not want to do anything exotic here. A simple string sent over
17 matches
Mail list logo