Subject Re: [IBO] Effect of Database size
Author Dominik Murk
Try to to sweep on bigger database. Or beter, backup and restore it.
Let me know what result will be. Thanks.

Dominik Murk
Milenij group

----- Original Message -----
From: "Paul Hoshovsky" <paulh@...>
To: <>
Sent: Thursday, February 21, 2002 11:19 PM
Subject: [IBO] Effect of Database size

> hello
> I have discovered something strange that I thought others may be
> to read.
> I have two DBs, identical format, from different clients. One is about 8
> and the other is about 17MB.
> Two of the tables in the DB have primary keys and indexes placed on the
> tables. That is, for the History table, I have the primary key on two
> and a composite index on these two fields. On the other table, called
> Records, I have a single primary key on one field and on this same field I
> have also an index.
> When I execute a query on the smaller DB, I get (for example ) from the
> "Select count(*) from History" a value within a short period of time. I
> have also executed this same query using IBconsole and also get back the
> correct value quickly.
> Now when I swap the databases (from the smaller one to the larger one),
> run the exact same query on these same tables, I get an odd event.
> After the IBquery gets the result set, it then attempts to read the values
> using IBquery1.first. The program goes into a loop
> with the CPU usage monitor (from Task Manager on NT) sitting at 100
> When I kill the app, the IBserver merrily continues to spin around with no
> change in the CPU usage monitor. (So I have to shutdown the server in
> to regain control....)
> Now the question is very simple. I am in trouble if the size of the DB has
> an impact. (I refuse outright to accept this possibility).
> If the same program is operating in the same manner on two different DBs
> (the only differences is the size of the values and the actual numbers in
> the tables), what would make IBquery1. First hang on the larger DB and not
> on the smaller one?
> I would greatly appreciate comments on how to conclusively validate this
> problem.
> Thank you.
> IB Objects - direct, complete, custom connectivity to Firebird or
> without the need for BDE, ODBC or any other layer.
> - your IBO community resource for Tech Info
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to