I need to store a chunk of text data in the database. I need to split long text in to multiple records and store them along with the string order. This way I avoid disturbing the page size of the DB. And we don't want to use the TEXT datatype and want to stick to varchar.
But I am confused if I should split the text on the client side or on the database side.
Which is better - sending a big chunk of data in one DB call over the network or using multiple DB calls with smaller chunks (< 255) ?
thanks in advance
environment: c#, .net 3.5, sybase ase 15