Goto Message #
Server setup advice Hi. I'm running firebird Firebird-18.104.22.168540_0_x64 superclassic in highly concurent enviroment where I have up to 200 to 500 concurrent connections, most of
Firebird and JBoss/Hibernate: "LockAcquisitionException: could not u All, I realize that this is more of an JBoss/Hibernate issue, but web details on the error are sketchy so I thought I would reach out to see if anyone in the
CASCADE option in FK declaration doesn't work - after some time Hi, I'm using - ON UPDATE CASCADE, or ON DELETE CASCADE options in FK declarations - when I create the FK it works - but sometimes - after backup/restore or
Fetching Sponsored Content...
Re: Why is this setup not working? Hi Alexey. Thanks for your respons. I acknowledge your thoughts. I would like to address the issue of scale-ability. What are our options of scaling the
Re: Why is this setup not working? Hi, There are some things in the config which could be tuned, but not many - I would increase size of lock table to 10Mb and number of page buffers to 512
Re: Why is this setup not working? Hey Mark. Thanks for your reply. The firebird DB is running SuperClassic. The config kan be found on pastebin http://pastebin.com/ZzxL4xVc
Re: Single Row Table Becomes Unresponsive ... Updating a single row very often (what is very often in your case?) results in a hot-spot in your environment. Even worse if pessimistic locking is used
Re: Single Row Table Becomes Unresponsive 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
Single Row Table Becomes Unresponsive Hi, We're using Firebird 22.214.171.1248 on Centos 5.9. We have a third party replication product SymmetricDS, that accesses a single row table very often to do
Re: Retrieving relation and field info from system tables ... Probably not in the InterBase books - or the Firebird Book (which I recommend highly and is available through ibphoenix.com) - is the reason for the very
Re: RES: [firebird-support] Downgrade from 2.5 to 2.1 Thanks for the helpful tips Fabiano and Milan Ragards Em Domingo, 1 de Dezembro de 2013 12:32, "milanb@..." escreveu: ... It
Re: Why is this setup not working? ... I think the most important piece of information you left out is what architecture of Firebird you use: Classic, SuperClassic or SuperServer. ... Can ... No
Re: AW: AW: AW: [firebird-support] difficult question 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
Re: Why is this setup not working? 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
Re: Retrieving relation and field info from system tables ... System tables are documented in the InterBase Language Reference, you can find one at the Embarcadero site or here:
Fetching Sponsored Content...
Re: Retrieving relation and field info from system tables Hi there, 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
Re: AW: AW: AW: [firebird-support] difficult question ... Why is that a disadvantage? Holes in your numbering would also happen if a user deleted a different recordset (eg the second last) instead of the last.
Re: Why is this setup not working? Hi Ronnie, You did not provide key characteristics of the server, database and transaction statistics, so please don't expect that you will have reasonable
AW: AW: AW: [firebird-support] difficult question Hello, thank you for your helping hand, whether in English or german language J I have change it, now the IDs were created by trigger. Only one disadvantage
Why is this setup not working? Hey guys. We have a webcluster consisting of 8 webservers running a PHP application with a firebird DB. The application have a rather hard peak one time a day
Re: Concurreny transaction impact on writers ... Thank you.
Re: Concurreny transaction impact on writers ... REC_VERSION / NO_REC_VERSION only applies to read committed isolation level. ... Make use of read-only transactions, if you can. Even being read-only,
Re: Concurreny transaction impact on writers ... First thank you for your time. It seems that .NET Repeatable read translates to Concurrency, Write, NoWait Id does not specify RecVersion, so it defaults
Re: Firebird v1.5.3 on Windows Server 2012 On Fri, 6 Dec 2013 11:12:41 -0500 ... No, I mean that if the OP discovers FB 1.5 doesn't work on Windows 2012, the best he will be able to possibly do is to
Re: Concurreny transaction impact on writers ... I'm not familiar with the .NET driver ... * What does "major slowdown" mean? * Is repeatable read involved for all transactions or read committed as well?
Concurreny transaction impact on writers Hi. In highly concurrent environment, part of an app is using .NET RepeatableRead transaction to read data from few tables. I noticed that during these reads,
Re: Replication of Firebird Databases (meany to one) Hej all, ... Sorry, could't resist: first answers @ google when searching for "firebird replication"
Fetching Sponsored Content...
Is it possible to tell by PSQL where Firebird server is placed? (Win Hello, I guess the topic says all. Can I somehow detect where (on what operatin system) the Firebird server is placed? Regards.
Replication of Firebird Databases (meany to one) Hi all, Does anyone know any good free to use replication software. What i have is as follows I have 4-20 terminals with a database that holds all the
Re: I dont know why sweep is not doing clean ... Only record versions created before transaction three hundred seventy-one thousand nine hundred and thirty two can be removed. All versions created by the
View First Topic Go to
Loading 1 - 30 of total 123,325 messages