Re: .Net Dataview vs. Using Database View

Discussion in 'ASP .Net' started by Lucas Tam, Sep 23, 2004.

  1. Lucas Tam

    Lucas Tam Guest

    "=?Utf-8?B?TWlrZSBNb29yZQ==?=" <>
    wrote in news::

    > Is there any real differences to using the .Net dataview over using a
    > sql server database view?


    Yes, a SQl Server view is more efficent for large datasets than a .NET
    dataview.

    ..NET dataviews are applied on data downloaded to a client - so if you wish
    to filter a large table, the entire table must be downloaded to the client.

    It comes down to several factors whether to use a SQL view or .NET dataview
    such as the size of the dataset, the response time required, the type of
    data you're filtering against, etc.
    --
    Lucas Tam ()
    Please delete "REMOVE" from the e-mail address when replying.
    http://members.ebay.com/aboutme/coolspot18/
    Lucas Tam, Sep 23, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Manohar Kamath [MVP]

    Re: .Net Dataview vs. Using Database View

    Manohar Kamath [MVP], Sep 22, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    392
    Manohar Kamath [MVP]
    Sep 22, 2004
  2. =?Utf-8?B?TWlrZSBNb29yZQ==?=

    .Net Dataview vs. Using Database View

    =?Utf-8?B?TWlrZSBNb29yZQ==?=, Sep 22, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    336
    =?Utf-8?B?TWlrZSBNb29yZQ==?=
    Sep 22, 2004
  3. CodeMonkey
    Replies:
    1
    Views:
    721
    joyal jhaveri
    Feb 4, 2011
  4. daveydave999
    Replies:
    0
    Views:
    356
    daveydave999
    Oct 5, 2007
  5. Parthiv Joshi
    Replies:
    1
    Views:
    646
    Samuel L Matzen
    Jul 6, 2004
Loading...

Share This Page