In an RDBMS yes, on jBASE (MV platforms) you have to create an index.
Sent from my iPhone
> On Aug 1, 2020, at 8:51 AM, VK wrote:
>
>
> Sorry forgot to mention that there's no field with account number, it's just
> a part of @ID. Isn't @ID a primary index itself?
>
>
>> On Friday, 31 July 2020 17:15:36 UTC+2, VK wrote:
>> Hi coleagues.
>>
>> What is the fastest way to SELECT a set of records from a J4 table:
>>
>> @IDs are in the format: (account_number)-(date_in_internal_format), e.g.
>> 5001-18628.
>>
>> trying:
>>
>> SELECT THE.TABLE WITH @ID BETWEEN "5001-18628" "5001-23012"
>>
>> Result is bit more than a second (Windows 2019 server, enough memory and
>> CPUs). Maybe it can be improved?
>>
>> usr: 1.11 sys: 0.00 elapsed: 0m1.11s
>>
>> Usage of "GE ... LE" didn't help:
>>
>> usr: 1.36 sys: 0.00 elapsed: 0m1.36s
>>
>> Records number: circa 340,000.
>>
>> Resizing didn't help.
>>
>> Conversion to JR, as expected, made things a bit worse.
>>
>> Thought about year-based distribution but haven't given it a try yet.
>>
>> Last question - is jBASE indexing stable enough to be trusted?
>>
>> TAFC 13 (no, question isn't about T24!)
>>
>
> --
> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/jBASE?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jbase/ef1a5fa4-6e7d-498d-8c2a-b501af233ca5o%40googlegroups.com.
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to jBASE@googlegroups.com
To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jbase/E4D147D8-A283-4BDE-A336-EE086F6E7BC2%40gmail.com.