--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly

> So here are the questions:
>
> 1. Can we (and HOW to) give priority to USERS? (i.e. user
> DAYLY_SQL is
> granted more cycles than user MONTHLY_SQL)

No

> 2. Can we (and HOW to) give priority to SQL-queries? (i.e. queries
> without joins in their plan)

No

> 3. Can we (and HOW to) give priority to a specific machine?
> (i.e. one PC
> is the MonthlySQL machine)

No

> Unfortunately, all these queries must be executed on the same
> database,
> because it is changing fast and is too big (300mb) to be
> backed up too
> often.

Backup should take a few minutes, how about backup & restore to a
Separate database then use the copy just for the big bad queries.

Replication might be another option

>
>
>
> Please give us some advice on that issue or some idea for another
> INTERBASE based SQL server to migrate our application to.
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> <font face=arial size=-1><a
> href="http://us.ard.yahoo.com/SIG=12h2lcpba/M=362329.6886308.7
> 839368.1510227/D=groups/S=1705115386:TM/Y=YAHOO/EXP=1124111152
> /A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?p
> age_id=1992
> ">Fair play? Video games influencing politics. Click and talk
> back!</a>.</font>
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>