Subject Re: [firebird-support] Growing Database II
Author Martijn Tonies
> Let Me explain better:
>
> I have to do some calculations or every day in a range of 60 years.
> Insert in a table the calculations of 1 day, delete it and pass to the
> next day.
>
> I must reiterate it .
> One calculation takes 3 seconds.
> But after the database reached more than 50 mega SLOWWWWWWWWWWWW DOWN.
> too much.
>
> I have done this either in Sp and Delphi, same results, an
> inacceptable growing...

When it's slow and has grown a bit largish, can you post the
transaction counter statistics?

You can get them with the command line tool "gstat" or pretty
much any GUI tool.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com