Ted Roche wrote:
Terabytes are easy enough to manage. If you've really got a lot (and I
mean a lot a LOT) of data, you can start optimizing storage and
performance with separate spindles for logs, data and indexes and SANs
and RAID and so forth, but you're gonna need a lot of data for that.
How big are we talking?
Much thanks for all your input, Ted!
Actually, by most standards, not that much data. Currently the entire
database is just now passing 500MB, but it passed 400MB last August, so
the data is growing quickly. And, as you can imagine, because the data
is accessed via a database manager the growth of the database doesn't
impact response performance as much as it does with DBF files and a
desktop client sucking everything over the wire just to find a few bytes.
I really do find putting inventory into one table and leaving it there
with updates to indicate status to be much simpler and more manageable.
I think I'll go that direction. Thanks again.
Mike
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
