speeding up loading records

[cj2]

I can't remember and can't find my notes anywhere. There were a couple
of commands that when used with I think the data adapter that allowed
for faster reading or writing of tables. I think one or both had
something to do with turning of the checking VB does to make sure the
data doesn't violate any of sql's rules--like a field is blank where sql
says it can't be. I think it was two commands both doing something to
help speed loading data from one table and writing it to another. I'm
pretty sure when I came across the commands I was copying tables from
informix via and odbc connection to a sql server. But I can't find
where I used the commands. Like I said I can't remember but perhaps
someone might know what I'm talking about.

 

[cj2]

Just found dataset.EnforceConstraints I think that might have been one.

 

[Jialiang Ge [MSFT]]

Hello CJ,

Turning off EnforceConstraints is one of the ways to improve the
performance of DataAdapter.Fill(dataset). The other way is to call
BeginLoadData and EndLoadData, which can turn off internal Dataset indexing
and notification. You may want to have a look at this article:

[DataReaders, DataSets, and performance]
http://www.eggheadcafe.com/articles/20030205.asp

Peter A. Bromberg has a good interpretation of the performance of
DataAdapter.Fill().

If you have any other questions or concerns, please DON'T hesitate to tell
me.

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[cj2]

That is it. That's what I couldn't remember. Thanks!