how to optimize sending data to DB
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
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
.NET Programming
The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.
137K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
