hi,
1. select first 100 ... from my_state_table2. delete from my_state_table ;-)
after this your query will be very fast ;-)
Ask self. Did i describe my problem for others that they can help me. The
answer is NO
show us reall query, query plan, statistics...
regards,Karol Bieniaszewski
--
hi,
as Helen sayyou must commit previous transaction not close connection
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]"
Data: 04.02.2016 05:55 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat:
I am installing sam broadcaster and using firebird with it. it is asking for a
user name and password. Where can I find it.It is wanting Database login Info
for Firebird.
Thanks Helen.
'Tis starting to make some sense now.
Unfortunately our application establishes a connection to the FB server
and remains active until shut down. I can't terminate it and create a
new one. A 'feature' of the RAD we are using.
You have given me an idea though, thanks.
Hi.
I am writing a small application for our support staff which includes
the ability to see who is connected to a database using the query:
SELECT M.MON$ATTACHMENT_ID, M.MON$USER, M.MON$REMOTE_ADDRESS,
M.MON$TIMESTAMP, M.MON$REMOTE_PROCESS FROM MON$ATTACHMENTS M
When the application fi
The idea is the following.
Have products and services that pass through different states (order,
committed, reviewed, approved, slope, bill, invoice), these may belong to a
period or many (period = months).
The filter may include the client query or not.
La idea es la siguiente.
Tengo productos y
> I have a state machine (workflow) implemented on a table a couple of
> million records and growing.
> I have crated an index on the "state" field. The possible states are
> very few (5 to 10). Obviously selectivity index is terrible. As I can
> optimize the query?
Hard to say without seeing an a
I have a state machine (workflow) implemented on a table a couple of million
records and growing.
I have crated an index on the "state" field. The possible states are very few
(5 to 10). Obviously selectivity index is terrible. As I can optimize the query?
thank
Tengo una máquina de estados (wor
10 matches
Mail list logo