Re: [firebird-support] How to optimize queries on field state

> 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

[firebird-support] system table behaviour

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

Re: [firebird-support] How to optimize queries on field state

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

ODP: RE: [firebird-support] system table behaviour

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:

ODP: Re: [firebird-support] How to optimize queries on field state

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

Re: [firebird-support] system table behaviour

[firebird-support] I need help.

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.

RE: [firebird-support] system table behaviour

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.