Re: [Firebird-devel] AutoOptimize

[Vlad H. <hv...@us...>]

> Playing with thread priorities in Firebird is playing with fire because
> any thread can get a lock on a page in cache.  If a low priority thread
> has a read lock on a page, it will block high priority threads that want
> to change that page.

    This is completely true. We can't use OS's priorities in FB and even if we can 
use it it will be wrong way. Thread CPU priority have nothing common  with thread 
IO priority which is much more important in DBMS at least when we doing some 
real work different from endless circles.

    So the question i want to ask - is anybody have good idea of how to rule
thread IO priority ? What i want to know is how to rule amount of thread IO 
requests so that particular thread don't eat many resources when other threads
have what to do

Regards,
Vlad