On Tue, 15 Apr 2003, linweidong wrote:
> Under this condition, I want get some useful suggestion from you. How to
> optimize the database? How to improve the Count(*)? Because we want to get
> the number of records in the recordset we got.
Well, you can always use the trick of putting an on insert / delete
trigger on the table that maintains a single row table with the current
count. That way, whenever a row is added or removed, the count is
updated. this will slow down inserts and deletes a little, but TANSTAAFL.