Hi Folks: my 1st post here.

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.

Sybase 12.5.1
Sun Solaris 2.8

Looking for some coments and some sugguestions
Regards Roger