91,000 + entries from SQL and Datagrid

[Paul Brun]

I am trying to load up approximately 91,000 + records into a datagrid. Using
the SQL connection,
I am able to do so, however, I am wondering if there is another way that
will reduce memory
overhead and secondly, if there is a quick way to filter through the
datagrid. For instance, if I have
a field and I type in the letter "D", then all the records would filter down
to the letter "D" and so
forth.

Does anyone have experience with this or know of a mechanism that would
provide me with this
functionality, yet keep memory resources at a minimum.

Please let me know.
Thanks
Paul

 

[Marina]

You are not going to get good performance with over 91K worth of records.
There is no way to reduce memory, if you always have 91K worth or records in
memory.

You should work on selecting only the records you need to display to the
user...

 

[Lucas Tam]

I am trying to load up approximately 91,000 + records into a datagrid.

Very bad idea.

Using the SQL connection,
I am able to do so, however, I am wondering if there is another way
that will reduce memory
overhead and secondly, if there is a quick way to filter through the
datagrid.

1. Return only a subset of data for each page

2. Use a dataview to quickly filter all the data (if all the data has been
loaded into the dataset), or run a query on the SQL server to filter.

 

[Bernie Yaeger]

Hi Paul,

You will probably want to take a look at some of the third party grids. I
use component one true db grid and, although there is a bug here and a bug
there, it is a tremendous tool. However, loading 91,000 rows will take what
it takes. I load more on occasion. You will be told to filter it
beforehand, but your client may not want to do this, so you have to load it
all. With a gig of ram it will take about 30 seconds to load, depending on
the width of the table - not terrible. Then, using one of these grids,
filtering is a snap (it has a built-in filterbar, as I suspect many of the
others do as well).

HTH,

Bernie Yaeger

 

[Paul Brun]

yes.....however, the users of this tool are using systems with 128 MB of
RAM, so I
need to be conversative with memory usage.

Thanks
Paul