Den 2012-06-12 11:18 skrev Olaf Kluge såhär:

>
> Hello Mark,
>
> >If it is just for backup, why not just create a single backup table and
> >move all records into that table at year end. Then there is no need to
> >create a table per year (and it is easier to provide a unified view on
> >’archived' records).
> >
> >Mark
>
> my apprehension is that the queries will slow if I take the many
> hundred-thousand records every year in a simple table.
>

Depends on your indexing and queries, of course, but I currently have a
table with some 170 million records, and with indexed queries there are
no problems. With just ~1 million records per year, I'd say don't worry.

Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64





[Non-text portions of this message have been removed]