Hi,

At Thursday, November 27, 2008, 8:46 AM, scr0546 wrote:

> Thanks for help.
> Maybe I will cancel the dataset with all records.
> So the user can only search for records and has no view to all data.
> I think it's time for this, because the recordcount increased from a
> few hundert to 30.000 customersrecords.

We came to the same conclusion with our software. For some customers,
the initial dataset was over 100,000 records, and we didn't anticipate
that amount of records initially. But now, the user doesn't see any
data, until they enter some criteria and then click a button to fetch
the data. And, we were surprised that our users didn't mind the
change, since the trade-off was a search form that appears
instantaneously. And, if I do have to load the data into a memory
table, I display a progress dialog as a visual feedback.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)