(related to prasadbuddhika's problem) retrieving huge amount of data
-
is there any special way of retrieving data from a huge database , because i've developed an app that reads from database and returns a dataset.then in the app using the dataset i fill a listview with each record in dataset. when the records increasing in the DB the time taken to fill the list view also increasing,(i'm using a simple select * query) so i want to reduce this time .
yasith
-
is there any special way of retrieving data from a huge database , because i've developed an app that reads from database and returns a dataset.then in the app using the dataset i fill a listview with each record in dataset. when the records increasing in the DB the time taken to fill the list view also increasing,(i'm using a simple select * query) so i want to reduce this time .
yasith
-
is there any special way of retrieving data from a huge database , because i've developed an app that reads from database and returns a dataset.then in the app using the dataset i fill a listview with each record in dataset. when the records increasing in the DB the time taken to fill the list view also increasing,(i'm using a simple select * query) so i want to reduce this time .
yasith
Don't use a dataset. They are crippling memory hogs. For large amounts of data you need to use a data reader. If the data is sufficiently large you need to break the return up into chucks.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego. -
Don't use a dataset. They are crippling memory hogs. For large amounts of data you need to use a data reader. If the data is sufficiently large you need to break the return up into chucks.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego.Hear hear! DataSet is evil!
-
is there any special way of retrieving data from a huge database , because i've developed an app that reads from database and returns a dataset.then in the app using the dataset i fill a listview with each record in dataset. when the records increasing in the DB the time taken to fill the list view also increasing,(i'm using a simple select * query) so i want to reduce this time .
yasith
Hi, some controls don't need all the data all the time, they can run in virtual mode, needing only the data that is actually visible at any point in time. They fire an event when they need more data to show it. DataGrid is one of those controls. :)
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google - the quality and detail of your question reflects on the effectiveness of the help you are likely to get - use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets