It's been my experience that any count statement that uses a filter on a larges networked table take a long time.

Instead of using a filter and count statements, us a single SQL statement to return the count.

Something like:

SELECT COUNT(id) AS idCount;
FROM tableName;
WHERE id = "123";
AND whatever your filter statement is;
INTO CURSOR countTemp

*-- Display the resulting count
?countTemp.idCount


Hope this helps,

Jeff