On 04/30/10 23:38, David Van Couvering wrote: > Hi, all. > > I have a thread that runs the following query every 10 seconds: > > SELECT d.ITEMSET_ID, f.FILTER_INDEX, FROM FILTERS f, PENDING_DELIVERIES > d WHERE f.ITEMSET_ID = d.ITEMSET_ID AND f.FILTER_INDEX = d.FILTER_INDEX > AND d.SENT = 0 AND d.SERVER_ID = 1 > > The FILTERS table has about 200 rows in it, and the PENDING_DELIVERIES > table has no rows. So this query returns zero rows each time it is run. > > My database directory is growing by about *1 MB *! every 30 seconds. > > This is the *only* query running. The number of rows in my tables never > changes.
Hi David, You may already have done so, but to verify that there is no other thread adding data, you could set the derby.language.logStatementText property and check derby.log to see which statements are executed. -- Knut Anders
