Hi,

> I've seen many post regarding using sweep and other maintenance tools
> in FB. Being new to this I have no idea what tool does what and why
> you would use them. Could someone please give a description of what
> one should do regularly with FB and what effects they have?

Regularly? Nothing, actually. As far as I know, there's no real need
for a sweep if you keep your transactions short and the transaction
counters moving forward.

If you do lots of inserts/updates, it might be useful to "rebuild" your
indices once in a while.

If your datafiles are very fragmented, a backup-restore cycle might
be useful.

But that's about it. At least, in my book ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com