Subject | RecordCount |
---|---|
Author | Aage Johansen |
Post date | 2000-11-29T23:30:35Z |
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 need
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 or
not-so-great performance. Or, just say no! to <number of records> ...
Regards,
Aage J.
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 need
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 or
not-so-great performance. Or, just say no! to <number of records> ...
Regards,
Aage J.