Re: Rules slower than Dynamic SQL ?

Поиск
Список
Период
Сортировка
Искать

Re: Rules slower than Dynamic SQL ?

От:
Decibel! <decibel@decibel.org>
Дата:
On Nov 26, 2007, at 6:09 PM, Simon Riggs wrote:
> On Mon, 2007-11-26 at 16:01 -0800, Alex Vinogradovs wrote:
>> I've got a data warehouse with pretty high rate of insert into
>> partitioned tables. What I've noticed, is that rule-based  
>> partitioning
>> seems to be somewhat slower than insertions made directly into
>> partitions through execution of dynamic SQL.
>>
>> Is it really true ?
>
> Depends how complex your rules are, but I think yes is the short  
> answer.

My understanding is that each rule has to re-evaluate the query  
that's being run. That's going to add some overhead to a simple  
INSERT INTO table VALUES ... but if you think that's bad, try it with  
an expensive INSERT INTO table SELECT statement!
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Rules slower than Dynamic SQL ?

От:
Alex Vinogradovs <AVinogradovs@Clearpathnet.com>
Дата:
Hi all,


I've got a data warehouse with pretty high rate of insert into
partitioned tables. What I've noticed, is that rule-based partitioning
seems to be somewhat slower than insertions made directly into
partitions through execution of dynamic SQL. 

Is it really true ?


Thanks!


Best regards,
Alex Vinogradovs

Re: Rules slower than Dynamic SQL ?

От:
Simon Riggs <simon@2ndquadrant.com>
Дата:
On Mon, 2007-11-26 at 16:01 -0800, Alex Vinogradovs wrote:

> I've got a data warehouse with pretty high rate of insert into
> partitioned tables. What I've noticed, is that rule-based partitioning
> seems to be somewhat slower than insertions made directly into
> partitions through execution of dynamic SQL. 
> 
> Is it really true ?

Depends how complex your rules are, but I think yes is the short answer.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com
FAQ