> Configuration (test machine):

> Firebird 1.5.2 Classic Server, WinXP, 800 Mhz, 512 MB.

> 2 clients:

> 1 - Is running the long insert process.
> 1 - Trying to access the table that is being updated.

Are both or either clients are running on the server?

How does the memory consumption vary over time? (Each
server process and each client running on the server.)

How complicated is the insert process of the stored proc?

The last question comes from a problem I had a long time ago.
I was trying to do an insert in which I used a very complex
select statement to gather details for an insert - lots of
inline computed fields with embedded selects, generated ids
and the like. The server at that time (cant remember the
version right now) used more and more memory over time. When
I moved the thing into a stored procedure and split the
processing up using simple select loops into variables for
calculation then everything moved along much faster and
without the memory overload.

--
Geoff Worboys
Telesis Computing