speeding up loading records

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • cj2

    speeding up loading records

    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

    #2
    Re: speeding up loading records

    Just found dataset.Enforce Constraints I think that might have been one.

    cj2 wrote:
    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.

    Comment

    • Jialiang Ge [MSFT]

      #3
      Re: speeding up loading records

      Hello CJ,

      Turning off EnforceConstrai nts is one of the ways to improve the
      performance of DataAdapter.Fil l(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]


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

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

      Regards,
      Jialiang Ge (jialge@online. microsoft.com, 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:
      msdnmg@microsof t.com.

      =============== =============== =============== =====
      Get notification to my posts through email? Please refer to
      http://msdn.microsoft.com/en-us/subs...#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/...tance&ln=en-us.
      =============== =============== =============== =====
      This posting is provided "AS IS" with no warranties, and confers no rights.

      Comment

      • cj2

        #4
        Re: speeding up loading records

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

        Jialiang Ge [MSFT] wrote:
        Hello CJ,
        >
        Turning off EnforceConstrai nts is one of the ways to improve the
        performance of DataAdapter.Fil l(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]

        >
        Peter A. Bromberg has a good interpretation of the performance of
        DataAdapter.Fil l().
        >
        If you have any other questions or concerns, please DON'T hesitate to tell
        me.
        >
        Regards,
        Jialiang Ge (jialge@online. microsoft.com, 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:
        msdnmg@microsof t.com.
        >
        =============== =============== =============== =====
        Get notification to my posts through email? Please refer to
        http://msdn.microsoft.com/en-us/subs...#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/...tance&ln=en-us.
        =============== =============== =============== =====
        This posting is provided "AS IS" with no warranties, and confers no rights.
        >

        Comment

        Working...