Hello,

is perhaps this query the problem?

SELECT AUFTRAGSNR, COUNT(PID) AS AnzahlPaletten,
COUNT(DISTINCT(AUFTRAG_POS)) AS AnzahlAuftrPos FROM AA_AUFTRAG_2 AA2 WHERE
STATUS = 'RQ' AND AA2.AUFTRAGSNR = (SELECT FIRST 1 AUFTRAGSNR FROM
AA_AUFTRAG_2 WHERE STATUS = 'RQ' ORDER BY AUSL_ORT) GROUP BY AUFTRAGSNR

Every 10 seconds the java applications runs it to show for new orders.

Thank you.

_________________________
I hope this helps.

Gabor

Olaf Kluge írta:

> Hello,
>
> we have a big problem with firebird 2.1.
>
> Here the gstat-statistics:
>
> Flags 0
> Checksum 12345
> Generation 23475579
> Page size 4096
> ODS version 11.1
> Oldest Trans. 23475559
> Oldest active 23475560
> Oldest snapsh. 23475560
> Next Transaktion 23475561
> Bumped Trans. 1
> Sequence No. 0
> Next attachm. ID 2063
> Implementation ID 16
> Shadow Count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Generation date Feb 5, 2009 15:03:40
> Attributes force write
>
> Sweep interval: 20000
>
> It looks fine, but the process fbserver takes hour to hour more RAM from

the

> system. From yesterday to this day increases the size from 300 Megabyte to
> 500 Megabyte. The firebird-process-size increases minutely more and more.
>
> The pagefile increases too. The problem is, that firebird jbird driver
> returns after one week of running firebird an error message, that firebird
> cannot allocate more memory.
>
> The server:
>
> 2 Gigabyte RAM,
> P4 3000
> XP pro
>
> What can be the problem? How can I find and solve it?
>
> Thanks for helping.
>
> Best regards
>
> Olaf Kluge
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.287 / Virus Database: 270.12.1/2071 - Release Date: 04/21/09
08:30:00