> Hi,
>
> I have Win XP Pro and Firebird 2.1.2.18118 running as super server.
>
> The database increases in size by about 350000 records a day.
>
> The auto sweep (default sweep interval of 20000) causes this database
> to slow down to the point of being none responsive around every 4 weeks
> (unless I manually do a backup/restore).
>
> If I stop the Firebird server while the sweep is running, will that
> damage the DB?

if you ask the server nicely to stop (i.e. send it a stop request) it
shouldn't harm the db, but it may not stop until the sweep is finished.

>
> I plan to make the sweep a manual process ie sweep interval set to 0
> and do the backup/restore manually.

That's fine, but more important is to find out why you need to sweep at all.
It sounds like there is some poor transaction control. I have a sweep set
everynight on my DBs but it's rarely actually required (doing anything).
With a well behaved application the 20,000 limit may very rarely be
breached.
Alan

>
> Advice please?
>
> Thank you to all.
>
> Theodore
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>