Sybase bcp in tuning needed
Hi, my bcp in is taking too long. Its running in batch of 5000 but taking too long. The bcp file is 30GB, taken from sybase bcp out. The table has text data too , the table size is 31GB and file size is 30GB. Its running too slow.
Used packets size of -A 8192 and 16284 too.
Increased number of pre-allocated extents to 32 too but no help.
Experts please advise. Otherwise this bcp will take ages to complete