Thank you for the reply...

SAM Broadcaster has an auto-dj funtions that searches through the database using a number of criteria (e.g. least recently played artist, genre, random, etc). Sometimes, it takes 2 minutes or more to find a song that meets the search criteria and my music broadcast is interrupted.

Regarding meta data, all that "stuff" is configured by SAM at installation time. I'm afraid I don't yet have the skills or confidence to interact with the database.

Thank you for recommending the upgrade process. Is Flamerobin the right tool to use for backing up and restoring the database? There is a backup/restore tool in SAM but I do not know if it will work with other versions of Firebird.

--- In firebird-support@yahoogroups.com, MagnOz <macnoz@...> wrote:
>
> On Fri, Feb 19, 2010 at 18:48, smgold <smgold@...> wrote:
> > Is there any advantage to upgrading the Firebird 2.1.0 database that
> > holds my SAM Broadcaster music information? There are approximately
> > 80,000 songs in the database and I suspect I may have reached some
> > operational limitations, especially in terms of searching.
>
> What makes you think, that you "may have reached some operational
> limitations"? Maybe your problems lie with how you defined your meta
> data, your queries or transaction handling. Post some specifics and
> someone smart will surely answer you :)
>
> > If an upgrade to 2.1.3 is recommended, how would I go about doing this
> > please?
>
> Typically I perform an upgrade like this:
> - backup db with old FB version
> - uninstall old FB
> - install new FB
> - restore your backup with new FB version
>
> But going from 2.1.0 to 2.1.3 I suspect that just uninstalling old FB
> and installing new FB is enough. Though with the former procedure
> you're always on the safe side.
>
> HTH,
> Markus
>