Re: [GENERAL] Cost based SELECT/UPDATE

On 9/7/2005 10:45 PM, Leonid Safronie wrote: Hi, ppl Is there any way to do SELECTs with different priorities? Once a month I need to do some complex reports on table with over 7 billion rows, which implies several nested SELECTS and grouping (query runs over 20 minutes on P4/2.4GHz).

Re: [GENERAL] Cost based SELECT/UPDATE

On Thu, Sep 08, 2005 at 06:45:33AM +0400, Leonid Safronie wrote: Hi, ppl Is there any way to do SELECTs with different priorities? Once a month I need to do some complex reports on table with over 7 billion rows, which implies several nested SELECTS and grouping (query runs over 20

Re: [GENERAL] Cost based SELECT/UPDATE

Leonid Safronie wrote: Hi, ppl Is there any way to do SELECTs with different priorities? The issue is that response time for these 50 processes is very important unlike for report generation, and time spent by these processes while report running is unacceptable for my production environment

[GENERAL] Cost based SELECT/UPDATE

Is there any way to do SELECTs with different priorities? The issue is that response time for these 50 processes is very important unlike for report generation, and time spent by these processes while report running is unacceptable for my production environment (response time grows from 1-3

[GENERAL] Cost based SELECT/UPDATE

Hi, ppl Is there any way to do SELECTs with different priorities? Once a month I need to do some complex reports on table with over 7 billion rows, which implies several nested SELECTS and grouping (query runs over 20 minutes on P4/2.4GHz). Concurrently, there are over 50 processes updating