troubleshooting Question

how to optimize sending data to DB

Avatar of ol muser
ol muserFlag for United States of America asked on
Sybase Database.NET Programming
2 Comments2 Solutions679 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros