[firebird-support] Re: Firebird and sharding ? - Email found in subject

2012-03-30 Thread nathanelrick
Ann, thanks you so much for such good explanation ! can not wait more for the V3, hope soom the first beta will be ready

[firebird-support] Re: Firebird and sharding ? - Email found in subject

2012-03-30 Thread nathanelrick
and yes you are right they move their C++/ISAPI to JAVA :) by the way that a curious choice ... Why would that be a curious choice? because they already have hundred of developer working on the c++ isapi, thousands of thousands lines of code, why move all of them to java (exept if the

[firebird-support] how to use the x notation (ex ID=x'049094') inside parameter ?

2012-03-30 Thread nathanelrick
Hello, how to use the x notation (ex ID=x'049094') inside parameter ? When i do insert into ... (Field1) Values (?); with the parameter x'049094' i receive an error probably i can write any char i want (from #0 to #255) inside parameter and i don't need the x notation ?

[firebird-support] an existing connection was forcibly closed by the remote host

2012-03-30 Thread homerjones1941
I've searched this subject in this group and others. It seems there is no single cause for this. Even so, I would welcome any input. This seems to be a common problem with other RDBMS as well, so I'm sure it isn't a Firebird problem, but perhaps there is some setting I've overlooked. I still

Re: [firebird-support] OIT / NT

2012-03-30 Thread Thomas Steinmaurer
I have a customer who uses my accounting system, who has a server (FB 2.5.1) and 4 clients, distibuted and connected via Internet to this server. The Firebird remote protocol isn't really optimized for WAN usage. People there complains about poor performance. I use Firebird Transaction

Re: [firebird-support] Re: Firebird and sharding ? - Email found in subject

2012-03-30 Thread Lester Caine
nathanelrick wrote: I think you also mentioned that Ebay doesn't allow joins and uses the application to do the joining. If that's the case, I'm glad I don't work for Ebay. I'll be willing to bet that the Ebay application is written in Java - that sounds like the sort of thing that the

Re: [firebird-support] Identifying damanged pages

2012-03-30 Thread Josef Kokeš
Dne 29.3.2012 18:26, Ann Harrison napsal(a): 2012/3/29 Josef Kokešj.ko...@apatykaservis.cz Due to hardware malfunction, my database got damaged. GFIX (-v -f -i) tells me that a database has 1 record level error, 9 data page errors, 41 index page errors and 322 database page errors.

Re: [firebird-support] OIT / NT

2012-03-30 Thread Ann Harrison
On Fri, Mar 30, 2012 at 4:13 AM, Tiberiu Horvath tiberiu_horv...@yahoo.comwrote: I use Firebird Transaction Statistic Logger to see the problem. ... While this client is using my software, somehow the gap between OIT and NT increases 200 transactions each 5 seconds. OK, time for my

Re: [firebird-support] Re: Firebird and sharding ? - Email found in subject

2012-03-30 Thread Ann Harrison
Norm, I've no idea how good a suggestion this is, but how difficult (sorry developers!) would it be to do something along the Oracle lines? RDB$RELATIONS would have columns for cardinality, spread of values and so on. These would be recalculated on demand - Oracle used a package called