Morning Mark,
On 31/03/12 17:20, Mark Rotteveel wrote:
I disagree, the application (or application developer) should do that
(preparing statements every time it needs it). It is the driver and/or
connection pool that should keep a pool of prepared statements (see
section 11.6 of JDBC 4.1)
Hi Norm,
Talking about optimizing using histograms - for example, an index on gender
is valuable when looking for female professional rugby players, and much
less so for males. I guess you could replace professional rugby players
with open source developers, but ...
And if it happens during
On 30-3-2012 14:24, Norman Dunbar wrote:
Extensive use of prepared statements and variables
Yes, and I'll bet they do what every Java application I've seen does,
prepares the same statement hundreds of times, even though they should
do it only once.
I disagree, the application (or application
Ann, thanks you so much for such good explanation !
can not wait more for the V3, hope soom the first beta will be ready
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
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
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
Hi Norman,
yes i understand, but now with my 50 millions rows table i start to meet the
limit of firebird where a simple prepare can take around 1 s to 1 min
dependantly the charge of the server (see my previous post). next year it's
will be around 100 millions rows and i will have no
Norm,
yes i understand, but now with my 50 millions rows table i start to meet
the limit of firebird where a simple prepare can take around 1 s to 1 min
dependantly the charge of the server (see my previous post). next year it's
will be around 100 millions rows and i will have no solutions
Nathanel,
Create a virtual database maindatabase{
Agent1: host:port:databasename1
Agent2: host:port:databasename2
...
Agentn: host:port:databasenamen
}
and that all, you can use the maindatabase like you query normal database
(but you can't update it, you are responsible to update
But realize that there are very real problem with those types of analysis
solutions when dealing with OLTP databases -- otherwise there would be
solutions available (that don't have license fees that are more than the
total sending cost of sending a child to a US Ivy League school for 4
Hi,
- Original Message -
From: nathanelrick
To: firebird-support@yahoogroups.com
Sent: Wednesday, March 28, 2012 8:04 PM
Subject: [firebird-support] Re: Firebird and sharding ? - Email found in
subject
But realize that there are very real problem with those types of
analysis
On Wed, Mar 28, 2012 at 2:04 PM, nathanelrick nathanelr...@yahoo.fr wrote:
yes i understand, but now with my 50 millions rows table i start to meet
the limit of firebird where a simple prepare can take around 1 s to 1 min
dependantly the charge of the server (see my previous post). next year
I am not sure what your purpose of your DB is, but if I recall correctly you
did something with session data in this big table. Perhaps for that purpose
the use of another database like one of the noSQL database is better.
yes, that is another story this session database... in fact firebird
But realize that there are very real problem with those types of
analysis solutions when dealing with OLTP databases -- otherwise there
would be solutions
available (that don't have license fees that aremore than the total
sending cost of sending a child to a US Ivy Leagueschool for 4
15 matches
Mail list logo