Subject Re: [IBO] RecordCount
Author Jason Wharton
NumberOfRecords is excellent to use in conjunction with search mode. I'm not
in the slightest considering removing it...

But, you raise an excellent point that there needs to be something to grab
the developer's attention about it to take the issue into consideration.

Thanks for the thoughts!

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Aage Johansen" <aagjohan@...>
To: <>
Sent: Wednesday, November 29, 2000 4:30 PM
Subject: [IBO] RecordCount

> Maybe the best solution for the RecordCount problems would be to remove or
> rename the RecordCount feature. And, I'm not kidding.
> 1. During conversion of a BDE project you will get error messages so you
> will have to fix the problem.
> 2. You should avoid the RecordCount like the plague, and if you really
> an estimate of <number of records> you do a 'select count ...'. When you
> use a where clause (just counting a small part of the table) performance
> will probably be tolerable. Give your users a choice: great performance
> not-so-great performance. Or, just say no! to <number of records> ...
> Regards,
> Aage J.