Re: [firebird-support] Numeration without hole, Is right Before Insert Trigger?

2015-12-25 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Hello Luigi If you can read Spanish, this article can be useful: https://firebird21.wordpress.com/2014/09/11/algo-mas-sobre-transacciones-optimistas-y-transacciones-pesimistas/ Greetings. Walter. On Thu, Dec 24, 2015 at 7:05 AM, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote

Re: [firebird-support] error writing data to the connection

2015-12-25 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
You can know that the connection is active sending a request to the Server, something like: SELECT CURRENT_TIME FROM RDB$DATABASE In your application, using a control Timer, you can send such command each minute or so. If there is not response then connection is dead. For connecting again

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-25 Thread Eduardo guse...@gmail.com [firebird-support]
OK, thank you. I understand. I tried deinstalling 2.1.4 and installing 2.1.7. But the performance was the same. Nothing improved! :-( Do I have to change any configuration or the matter is that if I can´t enable disk cache, there is nothing I can do to improve the performance? Regards Edua