I unsuccessfully tried to recreate the problem. However, I did notice that
interserver.exe seems to use a lot of memory when there are a large number
of sql statements executed on a connection.

The following code makes interserver.exe go to 31MB ram (according to win2k
task manager). The memory is released when the connection is closed and the
interserver.exe process ends.
for i = 1 to 10000 {
create statement
statement.execute sql
close statement
}



The following code keeps interserver right around 2.7MB:
create statement
for i = 1 to 10000 {
statement.execute sql
}
close statement


I was going to use interbase as the backend for a servlet web system - and
implement a simple connection pooling class. This makes it look like only
one statement should be created per connection - and the statement should be
cached in the pool with the connection. It looks like the statement memory
is never getting cleaned up in interserver.exe.



-----Original Message-----
From: Ken Richard [mailto:kenr@...]
Sent: Friday, September 15, 2000 12:56 PM
To: IB-Java@egroups.com
Subject: RE: [IB-Java] runaway process



Did the memory geep going up until your machine ran out of virtual memory?

-----Original Message-----
From: Stephen Searfoss [mailto:latinrs@...]
Sent: Friday, September 15, 2000 12:35 PM
To: IB-Java@egroups.com
Subject: Re: [IB-Java] runaway process



Sorry, yes due to NOT commiting transactions.... I don't thing that is a
bug.

At 06:20 a.m. 9/15/2000 +0200, you wrote:

>
>Stephen,
>
>could you elaborate on that, what do you mean by "it was due to commiting

our transactions"?

>It was because you didn't commit or what? If it is a bug you might want to

list it under http://sourceforge.net/bugs/?group_id=9028 (or I could do it
if you provide the necessary details)

>
>Thanks, Torsten
>
>
>To unsubscribe from this group, send an email to:
>IB-Java-unsubscribe@egroups.com
>
>
>
>Attachment Converted: "c:\Attach\Re [IB-Java] runaway process"
>

============================================
* Latin Retail Systems, S.A. de C.V.
* Primary E-Mail stephen@...
* Secondary E-Mail latinretail@...
* Tel.(52-5) 554-7999 / Fax. (52-5) 554-0310
* Mexico City, Mexico
* www.latinretail.com
============================================

To unsubscribe from this group, send an email to:
IB-Java-unsubscribe@egroups.com





To unsubscribe from this group, send an email to:
IB-Java-unsubscribe@egroups.com