Hi,


Olaf Kluge írta:

> Hello,
>
> I have a database server, firebird 2.1 superserver.
>
> A procedure of the database does create job-positions in a separate table,
> based on the predetermined positions 1 through n. As long as the database is
> a small size, the procedure worked fine. Now that the database has become a
> bigger size, the procedure sometimes forgets the last position. After the
> database is compressed and restored, it works fine again.

What small and bigger size cover in megabytes? And please describe then
"the procedure sometimes forgets the last position" thing. Procedure
means stored procedure? Not an smallint/integer/int64 problem?
Store a big number in a smallint or something similar?

>
> The database structure was not created by me, but it is now my task
>
> I have had this problem in other projects, that the database doesn’t works
> fine if the size has grown.
>
>
> Thank you for your help.

Gabor