Subject Re: [Firebird-Architect] Table partitioning
Author Jan Radl
Jim Starkey wrote:

>Jan Radl wrote:
>
>
>
>>Hallo all,
>>
>>this is my first Firebird-Architect mail. I would like to ask you if you
>>plan to implement somethink like table partitioning (Oracle, ASE, DB2
>>has this option). This is only think we missed in Firebird 1.5 (or we
>>don't know how to use it). This is very usefull when you insert or
>>delete a lot of data from several connections into the same tables.
>>
>>
>>
>>
>>
>It might be appropriate to say what good it is and/or why you want it.
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Why i want it ? In case of lot of inserts in one table from dozen of
clients, partitioned table increase performance due to paralel write to
this table. If table is not partitioned the write processes are lock
each other because of write to the same part of disk (db space).

Jan