|
Posted by Piero 'Giops' Giorgi on 06/06/07 21:47
On Jun 6, 2:13 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> To me that sounds like a managability nightmare. While you can query
> the beast in one query, when you need to flush the rows for Orange
> County, you would have to explicitly to go to the CA table to
> switch partitions, which would mean a lot of dynamic SQL.
That can be, but the issue is the way counties update their records.
Some (VERY few) counties send a monthly "Update" file, but almost all
of them just send the whole dump of their DB.
This gives us two problems:
1) Normalizing the data in a common format (Naturally, no two counties
have the same record format)
2) Updating the db in an "Online" state for Orange County only (With
more than 3mil rows) checking for "Pre-Existing" records would just
kill the server, and there are 3077 counties...
Any better ideas?
Piero
Navigation:
[Reply to this message]
|