|
|
Posted by Ed Murphy on 06/06/07 05:02
Erland Sommarskog wrote:
> Piero 'Giops' Giorgi (giorgi.piero@gmail.com) writes:
>> I know that, but partitioning by county makes the DB a lot easier to
>> maintain.
>> I have to work that way because I'm dealing with criminal records, and
>> they are separated by county with a ton of different files, so for
>> many of them I have to clear the table and reload the whole county
>> every time I get an update. Easier on partitions... :-)
>>
>> Table size can be anywhere from 8000 to 3 million records, depending
>> on the county.
>
> Deleting 8000 rows is a breeze, but deleting 3 million rows takes
> some resources, particularly if the rows are wide. But it still only
> a matter of minutes.
I do assume that (state, county) is an index. If not, then get
that fixed yesterday.
Navigation:
[Reply to this message]
|