Subject RE: [firebird-support] Re: Performance of the count Function.
Author Nigel Weeks
> Is there a scheduler planned for FB, or maintaining this another job
> for an isql script in the windows scheduler or service sitting on the
> server?


A scheduler is easy! You've already got one!
crontab entry on Unix/Linux:

# Every hour, run a query
0 * * * * /usr/local/scripts/do_something.sh

and in that 'do_something.sh' file, we have:
/opt/firebird/bin/isql -u sysdba -p masterkey <
/usr/local/scripts/do_something.sql

And in that 'do_something.sql' (Note the .sql, not the .sh)
select 'Hello!' from rdb$database;


In windows, just use the 'scheduled tasks' system to launch a .bat file,
that launches 'isql' with a file full of sql commands.

Very easy, and very maintainable.

N