Hi Primoz!

You should stop thinking 'desktop database style' and always give the
users only relevant data. Normally, that would be one or a few orders,
not the entire 2004 or even September 2004 data (of course you could
provide aggregate data and let the users see old data, but most of the
time such data isn't interesting and should not be displayed by
default).

Set

--- In firebird-support@yahoogroups.com, "Planles" wrote:
> Basically just because of hidding old orders from user.
> So you suggest, that I should keep ALL orders in one table and omit
> accessable one with select statement e.g.
> select * from orders where OrderDate < some_date ?