Re: RecordCount and Filtered

Yes, this is normal behavior. Filter is implemented on the client in
the VCL. To provide the best performance it only scans enough of the
table to find the number of records the client is requesting to fill
the current screen. To know the record count the VCL would have to scan
the entire table and count the records that passed the filter. This
would be very slow on large tables. One way to get an accurate record
count is to use an SQL SELECT to get the records you want.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: Please help with a serious issue
    ... does a filter statement on an adotable happen on the client machine or the ... >>User 1 selects customer 1. ... >>server db for all the clients. ...
    (borland.public.delphi.database.ado)
  • Re: TDI driver event queueing
    ... filter connections on TDI level. ... Also, I feel that TDI queueing is not very simple task, and it even may not ... S> occurrs) not by the kernel-mode client. ... S> (which is the clients handler). ...
    (microsoft.public.development.device.drivers)
  • Re: 2 plans - 1 a sub set of another
    ... Dave Eade wrote: ... Putiing all client ... What I was hoping was that I could have a plan 'linked' to the main plan ... I don't just want to 'filter' one plan and show the Client, ...
    (microsoft.public.project)
  • Re: ISAPI Authentication
    ... The job of your authentication filter is to accept ... non-Windows credentials from the client and then map them to a Windows ...
    (microsoft.public.inetserver.iis.security)
  • Re: 2 plans - 1 a sub set of another
    ... Dave Eade wrote: ... paste into a new msp which is then passed onto the client. ... What I was hoping was that I could have a plan 'linked' to the main plan ... I don't just want to 'filter' one plan and show the Client, ...
    (microsoft.public.project)