Is there any way to count rows that meet a certain coniditon
in specific column without moving dbserver pointer?
Dear ramo...:
On Thursday, May 6, 2021 at 1:54:12 PM UTC-7, ramo...@gmail.com wrote:
...
Is there any way to count rows that meet a certain coniditonCan you create an index on that date field, set ".not. empty()" as one of the conditions, and get a count of indexed items? If it is a "permanent" index, then you should have less performance penalty.
in specific column without moving dbserver pointer?
I don't do VO, so I cannot help beyond that. Something like: https://harbour.github.io/doc/rddads.html#adskeycount
David A. Smith
piątek, 7 maja 2021 o 15:44:43 UTC+2 dlzc napisał(a):
On Thursday, May 6, 2021 at 1:54:12 PM UTC-7, ramo...@gmail.com wrote:
...
Is there any way to count rows that meet a certain coniditonCan you create an index on that date field, set ".not. empty()"
in specific column without moving dbserver pointer?
as one of the conditions, and get a count of indexed items?
If it is a "permanent" index, then you should have less
performance penalty.
I don't do VO, so I cannot help beyond that. Something like: https://harbour.github.io/doc/rddads.html#adskeycount
thank You for suggestion but a) I can make index FOR
(condition) but it does not tell how many elements have
been indexed (at least I do not know how to get it)
and b) I do not use Harbour ADS so do not have any
advanced functions&methods.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 295 |
Nodes: | 16 (2 / 14) |
Uptime: | 17:53:19 |
Calls: | 6,640 |
Files: | 12,187 |
Messages: | 5,325,086 |