Re: ADO.NET performance with large tables

Thanks for the replies !
I know you can limit the rows by using a SELECT query. But lets say a
customer table. The user wants to see a list of the customers. I cannot say
to my user : "the list is limited to only the customers starting with "A".
Of course he wants to see all customers. Same for quotations for example.
If I will tell my user : "the list is limited to quotations of the last 3
months", it will be weird. All users want a list represented in a datagrid
that is easy to scroll. But I realize that the more rows that will be in a
table, the slower the application will become.

Could you provide me with some good design practices ?

Many thanks in advance again !
Nico Callewaert
.

Relevant Pages

  • Re: Use BiztalkUtilities adapters?
    ... I didn't realize my replies would end up at the end of the ... with MS SQL Server and using the SQL Adapter that came with BizTalk, ... I'm also assuming you've added a bit column to the Customers ... provided earlier is the FOR XML AUTO added to the final query. ...
    (microsoft.public.biztalk.general)
  • Re: missing posts
    ... - only realised when someone replies to a post and I spot that I've not ... I'm on Blueyonder so wondered if any other customers of theirs had ...
    (uk.rec.competitions)
  • Re: Why wasnt the D7 update announced on Delphi Direct?
    ... John Kaster (Borland) wrote: ... > read all the replies in this thread? ... What do you hope to gain by telling all your customers that they're ...
    (borland.public.delphi.non-technical)
  • Re: Populating a combo box from a Validation
    ... Tom I thank you for the replies, but I cannot seem to get any of the ... code working. ... customers, thos 50 customers listed will populate a field/array/list ...
    (microsoft.public.excel.programming)
  • Re: Why wasnt the D7 update announced on Delphi Direct?
    ... > read all the replies in this thread? ... John, you might like to try that customer relations course that Nick Hodges ... with your customers. ... If confronting the customers in this manner works for ...
    (borland.public.delphi.non-technical)