I have a database with 12 user tables, being fed bcp data every 30 minutes with a db purge executing every .45 minutes past the hour from 4 different servers.
I want to be able to insert 5000 rows every time bcp is executed from these 4 servers, however my real issue is
I want to also beable to purge lines of data older than a specified date from these same 12 tables at the same time
that bcp is being is being executed.
I was looking into partitioning the tables accross multiple devices.
Sun Solaris 2.8
Looking for some coments and some sugguestions