🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.linux
Article #107

IB Anomalies

#107
From: John Sokel
Date: Tue, 19 Sep 2000 00:00
27 lines
1915 bytes
Here is what I am doing: my application is using IB for statistics of client
application requests.  Every time a client application makes a request, I
update that users record with a timestamp.  During my application load test
(50000 request an hour) everything seemed ok, until the next morning.  My
stats table has only about 30 records in it, and all other tables combined
have about 150 records, but the file itself has run up to 12.8M.  Is this
normal?  Basically, during my load test, I update the same 5 or 6 records
over and over again.

Also, I restarted IB to reclaim all the memory that was allocated (see my
previous post) and when it started up, one of the ibserver processes went
immediately to 100% cpu utilization, and allocated 65M of memory (ouch!).
It ran in this state for about 10 minutes, and eventually ate up 101M
(double ouch!) before it finally calmed back down.  Was it doing some kind
of maintenance/clean up?

I guess the major question is, am I doing something wrong, or should I
expect this kind of behavior? Anyone else using JDBC and seeing these kind
of anomalies?

These things kind of scare me since I cannot afford 101M of memory being
taken up (it has to run in parallel with my application).  Can I limit it in
some way?

I do not do commits in my code, since I am using JDBC and the Java reference
says the driver defaults to auto commit and you have to specifically turn it
off.
Technical Details
Message-ID: <39c77022$1_1@dnews>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 109030,eb050393f08942bb,start
X-Google-Attributes: gid109030,public
From: "John Sokel" <jsokel@thefalconnest.com>
Subject: IB Anomalies
Date: 2000/09/19
Message-ID: <39c77022$1_1@dnews>
X-Deja-AN: 671617892
X-Trace: 19 Sep 2000 06:54:42 -0800, 38.252.235.10
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: borland.public.interbase.linux
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200