[Bizgres-general] Off-list Re: [ENG] Re: Statement Queuing take II - Resource Scheduling (Running with cost and cursors)

[Jim C. Nasby]

On Sun, Aug 06, 2006 at 11:30:37PM -0400, Luke Lonergan wrote:
> Mark, 
> 
> > While we are talking outgrowths, administrators will probably 
> > want the ability to suspend or wakeup queued queries - or 
> > even reassign 'em to a different queues...
> 
> That is actually a potential work-around if we don't have the time
> sharing capability.  An admin would have to put a hoggy query to sleep,
> allowing others to continue, then restart it later.
> 
> This could even be a useful first step toward time slicing.

One of the things I love about Oracle is their dogfood compliance; so
many of their features build on top of other features that they've
already exposed to the users. IE: materialized views build on
replication, which builds on being able to look at log data.

So I think it'd be great if any built-in time slicing simply used
functionality that was already exposed to the user.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461