<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Very useful information. Anyone know for sure if the issues that Kurt
describes are addressed in the latest FB?<br>
<br>
Phil.<br>
<br>
Wilkin, Kurt wrote:
<blockquote
cite="mid0398A76017ECA44E9FF4AB46FB885A2502B16555@mail1w.fnzsl.com"
type="cite">
<pre wrap="">Rob Martin wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I guess that answer would be.... When the DB requires a Cluster to
handle the number of transactions / Connections required. FB doesn't
do Clusters, I guess Oracle does.
</pre>
</blockquote>
<pre wrap=""><!---->
Basically.
FWIW, in about '99 the place I was at started
running into trouble after ~50 connections on
IB 5.
Would've been early days of 5 though, and
Firebird, IB 6+ and all the OS and network
stuff would've improved a lot since then.
That database was >30GB (in the days
that your home box would have a 1-8GB drive :)
And I'm pretty sure with IB (definitely for
Firefox) you could multiplex connections if
you wanted, which some db Vendors'll charge
you for.
The other thing - elsewhere - we used to run
into was hitting a sweep and clean in IB,
where if you touch a large number of records,
the query will be slowed down multiple times
for the database to do its housekeeping, which
could be painful.
Cheers, Kurt.
</pre>
</blockquote>
</body>
</html>