Most efficient way to append records containing lots of text
Posted: Tue 05 Oct 2010 21:31
I figured I'd put this question out there for the experts.
I have a table designated for logging events in our software program, and this table has a few ntext type columns for storing text specific to that event. Because this text can sometimes be quite long, I can't really embed it in a simple SQL INSERT command, so I'm forced to find an alternative method for appending these types of records.
With that being said, what's the best way to do this? I know I can use the TMSTable or TMSQuery components to directly append a row using the standard VCL TDataset methods, but how efficient is this? I obviously don't need to query or retrieve any of the existing records, so how should I go about simply and quickly appending a new record so I can write long text strings to the underlying ntext columns?
I have a table designated for logging events in our software program, and this table has a few ntext type columns for storing text specific to that event. Because this text can sometimes be quite long, I can't really embed it in a simple SQL INSERT command, so I'm forced to find an alternative method for appending these types of records.
With that being said, what's the best way to do this? I know I can use the TMSTable or TMSQuery components to directly append a row using the standard VCL TDataset methods, but how efficient is this? I obviously don't need to query or retrieve any of the existing records, so how should I go about simply and quickly appending a new record so I can write long text strings to the underlying ntext columns?