Re: [firebird-support] Why is this setup not working?

2013-12-10 Thread talker3333
Hi Alexey Kovyazin. Thanks for your reply. Here are some information about the server. 2x AMD 2.20 GHz 32GB Ram 64bit Windows server 2008 R2 Standard The firebird DB size is 6.2gb. I have the firebird conf but im not sure how this yahoo forum works. Can I attach files somehow?

Re: AW: AW: AW: [firebird-support] difficult question

2013-12-10 Thread Tupy . . . nambá
Olaf, Stil for this problem, there is a possible solution. If you have only one user at each time, and if the user have the possibility of deleting only the last that have been inserted, you can use a delete trigger, that will renew the value of the generator (the next value that will be

Re: [firebird-support] Why is this setup not working?

2013-12-10 Thread Mark Rotteveel
On 10 Dec 2013 01:53:42 -0800, talker3...@hotmail.com wrote: Hi Alexey Kovyazin. Thanks for your reply. Here are some information about the server. 2x AMD 2.20 GHz 32GB Ram 64bit Windows server 2008 R2 Standard The firebird DB size is 6.2gb. I think the most important piece

Re: [firebird-support] Retrieving relation and field info from system tables

2013-12-10 Thread Ann Harrison
On Mon, Dec 9, 2013 at 6:58 PM, Christian Gütter n...@guetter.org wrote: nobody replied to the questions I asked about the Firebird system tables some days ago. Maybe they were a bit too lengthy and specific. I am wondering if anybody could point me to some documentation regarding the

[firebird-support] Single Row Table Becomes Unresponsive

2013-12-10 Thread Greg Kay
Hi, We're using Firebird 2.1.2.1818 on Centos 5.9. We have a third party replication product SymmetricDS, that accesses a single row table very often to do reads and writes. (It seems to be using the table to manage some sort of locking between SymmetricDS processes.) Very occasionally, this

Re: [firebird-support] Single Row Table Becomes Unresponsive

2013-12-10 Thread Alexey Kovyazin
Hi Greg, Run gstat -r or IBAnalyst and check number of record versions in this table. I suppose there could be millions of versions. Regards, Alexey Kovyazin IBSurgeon Hi, We're using Firebird 2.1.2.1818 on Centos 5.9. We have a third party replication product SymmetricDS, that accesses a

Re: [firebird-support] Single Row Table Becomes Unresponsive

2013-12-10 Thread Thomas Steinmaurer
We're using Firebird 2.1.2.1818 on Centos 5.9. We have a third party replication product SymmetricDS, that accesses a single row table very often to do reads and writes. (It seems to be using the table to manage some sort of locking between SymmetricDS processes.) Very occasionally, this