General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only