Results 1 to 4 of 4

Thread: How many records stored in Dataset?

  1. Jul 22nd, 2003, 03:28 AM #1
    sbasak
    sbasak is offline

    Thread Starter
    Fanatic Member sbasak's Avatar
    Join Date
    Aug 2001
    Location
    Globe Trotter
    Posts
    524

    How many records stored in Dataset?

    In VB.NET, the dataset stores records retrived from database in computer's memory. However if the underlying query fetches many records (say 1 million) how does dataset store so many records in memory? Is there any way to control how many records will be retrieved from database before dataset is disconnected from data source?

    Thanx
    Life is a one way journey, not a destination. Travel it with a smile and never regret anything.
    Yesterday is history, tomorrow is a mystery, today is gift - that's why we call it present.
    Reply With Quote Reply With Quote
  2. Jul 22nd, 2003, 03:56 AM #2
    CoMMiE
    CoMMiE is offline
    Addicted Member CoMMiE's Avatar
    Join Date
    Jul 2000
    Location
    Malaysia, Kuala Lumpur
    Posts
    179
    hi
    you can try using the top keyword in your sql query string where you can specify how many records to retrive.
    To follow the path:
    look to the master,
    follow the master,
    walk with the master,
    see through the master,
    become the master.-ZEN
    Reply With Quote Reply With Quote
  3. Jul 22nd, 2003, 04:07 AM #3
    sbasak
    sbasak is offline

    Thread Starter
    Fanatic Member sbasak's Avatar
    Join Date
    Aug 2001
    Location
    Globe Trotter
    Posts
    524
    AFAIK, top is not supported by all databases (eg. SQL Server supports it but Oracle doesn't). Also, I need a mechanism to retrive next set of rows in consistent mannter.
    Life is a one way journey, not a destination. Travel it with a smile and never regret anything.
    Yesterday is history, tomorrow is a mystery, today is gift - that's why we call it present.
    Reply With Quote Reply With Quote
  4. Jul 24th, 2003, 02:05 AM #4
    TonySaliba
    TonySaliba is offline
    Lively Member
    Join Date
    Jan 2001
    Posts
    79
    I think that this is an interesting subject. Is there any guru that can comment on this.

    Using datasets is fast but what is the effect on resources when datasets records grow too large.

    Is there a way of finding the best medium.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width